August 2009
Intermediate to advanced
893 pages
26h 48m
English
Content preview from Database Systems: Concepts, Design and Applications
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Review Questions
| 1. | Discuss the different types of transaction failures that may occur in a database environment. |
| 2. | What is database recovery? What is meant by forward and backward recovery? Explain with an example. |
| 3. | How does the recovery manager ensure atomicity and durability of transactions? |
| 4. | What is the difference between stable storage and disk? |
| 5. | Describe how the transaction log file is a fundamental feature in any recovery mechanism. |
| 6. | What is the difference between a system crash and media failure? |
| 7. | Describe how transaction log file is used in forward and backward recovery. |
| 8. | Explain with the help of examples why it is necessary to store transaction log records in a stable storage before committing that transaction when immediate update ... |