SQL Data Definition Quiz PDF: Questions and Answers - 319

MCQ 1591: Each type may include a special value called the

1. Real value
2. Duplicate value
3. Null value
4. Float value

MCQ 1592: Before the transaction is completed, carried updates of the transaction is traced over the disk by ensuring the

1. Consistency
2. Durability
3. Reliability
4. Atomicity

MCQ 1593: The database manager who authorizes all the new users, modifies database and takes grants privilege is, is known to be

1. Administrator
2. Author
3. Authorizer
4. Authenticator

MCQ 1594: A write operation in multiversion two-phase locking, may result into the

1. Lock Wait
2. Deadlock
3. Rollback
4. Both A and B

MCQ 1595: The create table command may also include

1. Atomicity statements
2. Boolean statements
3. Integrity-constraints statements
4. Evaluative statements