alleryStart learning →After a crash, with checkpointing, the recovery system scans the log
Afrom the very beginning of the database's life
Bonly the last 1000 log records
Cfrom the most recent checkpoint record forward
Din random order until it finds a commit marker
Answer & Solution
Correct answer: C. from the most recent checkpoint record forward
A checkpoint guarantees that everything before it has its dirty pages flushed.
So the log records before the checkpoint cannot affect the current state.
Recovery starts at the checkpoint record (or just before, to pick up the list of active transactions) and works forward.
Without checkpoints, scanning the entire log would be required.
Keep practising Database Management Systems
Browse all Database Management Systems questions for GATE CSE, or explore more Computer Science topics.