10 Questions Total

Recovery Management MCQs

Topic-wise practice questions for Database Management Systems. Test your knowledge, check solutions on demand, and pace your preparation.

Zero-leak answer engine • Rate-limited explanations

Practice in Timed Mode

Q1hard

A database server crashes at Time T. The recovery manager inspects the log and finds the following sequence. Which action should the manager take for Transactions T1 and T2? db-recovery-log


[08:00] <T1, Start>
[08:05] <T1, Write, A, 100, 200>
[08:10] <T2, Start>
[08:15] <T1, Commit>
[08:20] <T2, Write, B, 50, 75>
-- SYSTEM CRASH --

Discuss on Board

Q2easy

In the ARIES recovery algorithm, the "Analysis Phase" creates two tables. What are they?

Discuss on Board

Q3easy

The Write-Ahead Logging (WAL) protocol dictates that:

Discuss on Board

Q4easy

Why must the Redo and Undo operations in a recovery algorithm be Idempotent?

Discuss on Board

Q5medium

In a database using the Deferred Update (No-Undo/Redo) protocol, what will be the state of the physical data on disk if a transaction modifies an item but the system crashes before the COMMIT command is executed?

Discuss on Board

Q6medium

A data center experiences a catastrophic fire that physically destroys the primary database hard drives. To recover the data, which of the following is strictly required?

Discuss on Board

Q7medium

A database performs a Checkpoint every 30 minutes. If the system crashes 29 minutes after the last checkpoint, which part of the log must the recovery manager scan?

Discuss on Board

Q8medium

Consider the following log entry for an Immediate Update protocol: <T1, X, 50, 100>. During the Undo phase of recovery, what value is written to data item X?

Discuss on Board

Q9easy

What is the primary difference between a System Crash and an Aborted Transaction from a recovery perspective?

Discuss on Board

Q10easy

What is the purpose of the Log Sequence Number (LSN) in modern recovery management?

Discuss on Board