a)John a database administrator, created an account for a user. Explain two privileges that the user may be granted
b)A student has been asked to analyze the process of transaction execution in a database. Explain each of the following database transaction states that he may have analyzed
i)atomicity
ii)consistency
iii)isolation
c)With the aid of an SQL statement in each case,explain the following commands
i)insert
ii)select
d)The following datatypes were used in a database table
i)float
ii)varchar
ii)text
Describe each of the following datatypes