Multiple choice technology databases

What are three steps of data recovery when database goes in recovery mode.

  1. Analysis ,redo,undo

  2. Redo.Analysis ,undo

  3. Undo,analysis,Redo

  4. Analysis,Redo,Recovery
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Database recovery follows three steps: Analysis phase determines what needs recovery, Redo phase replays committed transactions, and Undo phase reverses uncommitted transactions. This is ARIES-style recovery. The order is Analysis→Redo→Undo. Option D incorrectly says 'Recovery' as a step rather than 'Undo'.

Keep practicing — related questions