🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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 →
  1. Q1. After a system crash, what happens to transactions that had committed?
  2. Q2. What does the write-ahead logging rule require?
  3. Q3. In the log record <T1, A, 100, 150, which value is used to UNDO the change?
  4. Q4. Which scheme never needs undo?
  5. Q5. What is the main benefit of a checkpoint?
  6. Q6. T5 started after the last checkpoint and committed just before the crash. What does recovery do with T5?
  7. Q7. T2 is in the checkpoint's active list and has no commit record. What does recovery do?
  8. Q8. Why must undo process the log backwards?
  9. Q9. What is shadow paging?
  10. Q10. The disk holding the database fails completely. What is needed to recover?