Question 1: Recognize three typical lists of transactions which are maintained by the recovery of subsystem.
Question 2: What do you mean by the term transaction rollback? Illustrate the meaning of cascading rollback?
Question 3: Why do practical recovery techniques use protocols which don’t permit cascading rollback? Which recovery methods don’t need any rollback?
Question 4: Describe the UNDO and REDO operations and the recovery methods that use each.
Question 5: Describe the deferred update method of recovery.
Question 6: What are the merits and demerits of this method? Why is it termed as the NO-UNDO/REDO method?
Question 7: How can recovery handle the transaction operations which don’t influence the database, like the printing of reports by a transaction?
Question 8: Describe the instant update recovery method in both single-user and multiuser environments. What are the merits and demerits of instant update?
Question 9: Illustrate the difference between the UNDO/REDO and the UNDO/NO-REDO algorithms for recovery with instant update? Make the outline for an UNDO/NO REDO algorithm.
Question 10: Explain the shadow paging recovery method. Under what conditions does it not need a log?
Question 11: Describe how recovery from the catastrophic failures is handled.