Advanced database management system quiz SET 01

Database management systems TRUE/FALSE quiz questions with answers, important quiz questions on RDBMS, quiz questions for entrance exams and interviews

RDBMS TRUE/FALSE Quiz Questions with Answers - SET 01

1. If all transactions are read-only transactions, then every schedule will be serializable schedules.

(a) TRUE                                         (b) FALSE

2. If no transaction reads the same element twice, then the serialization level READ COMMITTED is equivalent to REPEATABLE READ.

(a) TRUE                                          (b) FALSE

3. If no transaction inserts or deletes records to/from the database, then the serialization level REPEATABLE READ is equivalent to SERIALIZABLE.

(a) TRUE                                         (b) FALSE

4. The difference between Two Phase Locking and Strict Two Phase Locking is that the latter avoids deadlocks, while the former may allow deadlocks.

(a) TRUE                                          (b) FALSE

5. Only one transaction can hold an exclusive lock at any time.

(a) TRUE                                         (b) FALSE

6. In a static database, every serializable schedule is also conflict serializable.

(a) TRUE                                          (b) FALSE

7. In a static database, strict Two-Phase-Locking is guaranteed to produce a serializable schedule.

(a) TRUE                                         (b) FALSE

8. If a schedule is not conflict serializable, it is not possible for there to be an equivalent serial schedule.

(a) TRUE                                          (b) FALSE

9. If we use the cascade referential integrity policy, changes in one table of a database can cause tuples in another table to be deleted.

(a) TRUE                                         (b) FALSE

10. If a transaction is executed using the read committed isolation level, it is possible to get two different values if the same data is read twice.

(a) TRUE                                         (b) FALSE

***************

Answers:

1-(T), 2-(F), 3-(T), 4-(F), 5-(T), 6-(F), 7-(T), 8-(F), 9-(T), 10-(T)

***************

Related links:

• Go to DBMS General Quiz Questions Home page 

• Go to DBMS All Quiz Questions Home page 

• Go to Solved Exercises in DBMS Home page

• Quiz - TRUE / FALSE questions (Data storage and access) 

• Quiz - True/False questions (Data storage and access)

• Quiz - True/False questions (SQL)

• Quiz - True/False questions (index, B+ tree, fixed length records)

• Quiz - True/False questions (index, logging, 2PL)

• Quiz - True/False questions (schedules, triggers, keys)

• Quiz - True/False questions (query plan, join, triggers)