Skills101
← All practice quizzes

Quiz: Database Recovery

5 questions · new set on every retakeNo time limitPass: 60%+10 XP on first pass

How a database keeps the D in ACID when the power goes off mid-transaction. Types of failure, the log, write-ahead logging, deferred and immediate update, checkpoints and a full undo/redo worked example.

Log in to take the quiz

Free account · see your score, answers and explanations, earn XP

  1. Question 1

    After a system crash, what happens to transactions that had committed?

  2. Question 2

    What does the write-ahead logging rule require?

  3. Question 3

    In the log record <T1, A, 100, 150>, which value is used to UNDO the change?

  4. Question 4

    Which scheme never needs undo?

  5. Question 5

    What is the main benefit of a checkpoint?

🎯 Today’s placement challenge — 10 questions, no login. Can you score 10/10?Take today’s challenge →