Advanced Database Management System - Tutorials and Notes: Advanced database management system quiz SET 01

Tuesday, 26 May 2020

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:


No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents