← All topics
Quiz: Database Recovery: questions with answers
10 questions, each with the answer and a short explanation.
Take the timed quiz + get a certificate →- Q1. After a system crash, what happens to transactions that had committed?
- Q2. What does the write-ahead logging rule require?
- Q3. In the log record <T1, A, 100, 150, which value is used to UNDO the change?
- Q4. Which scheme never needs undo?
- Q5. What is the main benefit of a checkpoint?
- Q6. T5 started after the last checkpoint and committed just before the crash. What does recovery do with T5?
- Q7. T2 is in the checkpoint's active list and has no commit record. What does recovery do?
- Q8. Why must undo process the log backwards?
- Q9. What is shadow paging?
- Q10. The disk holding the database fails completely. What is needed to recover?