QUESTION BANK for UT-III Sub:DBMS

DBMS QB for UT3

1.     Explain the concept of shadow paging techniques. What are the different drawbacks of it

2.     Explain two-phase locking protocol in detail.

3.     What is Deadlock? Explain detection of deadlock and recovery from deadlock with an example.

4.     List the ACID properties and explain each property in detail with   a suitable example.

5.     Explain recoverability with example.

6.     Write a short note on Conflict Serializability.

7.     Write note on granting of locks.

8.     Explain deadlock handling.

9.     Give and explain the good reasons for allowing concurrency in detail.

10.   Explain cascaded rollback with example.

11.   Explain generation of update and commit record in log file.

12.  Explain transaction state and concept with diagram

13.  Write a short note on Conflict Serializability.

14.  Explain Time-stamp ordering protocol.

15.   Write note on validation based protocols

16.   Explain wait for graph.

17.   Explain storage types.

18. Deferred database modification is better or immediate database modification