1) What do you understand by backup and recovery? How you can recover data from catastrophic failures.
2) Describe how concurrency can lead to inconsistency in the Database.
3) Using suitable ex show the Data integrity Problem which could be caused by a concurrent update process.
4) Using suitable ex illustrate how Two Phase Locking works.
5) What do you mean by Deadlocks and how does DBMS resolves it.
6) What do you mean by Log File? What is Automatic Recovery? What is exactly done during Automatic Recovery?
7) When does a server Roll Forward and rollback a Transaction.
8) What do you mean by site autonomy? What do you mean by granularity of lock?
9) What is a Transaction? What are the properties of a Transaction? What are different transaction states?
10) What do you mean by Serializability? What is a conflict and View Serializable schedule?