Home › GATE CSE › computerscience › Database Management Systems › After a crash, with checkpointing, the recovery …
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.
Related questions
The main reasons production DBMSs avoid shadow paging in favour of WAL are that shadow pagWhat is the purpose of a Compensation Log Record (CLR) in ARIES?ARIES recovery is structured as exactlyFuzzy checkpoints differ from naive checkpoints byIn standard log-based recovery, the order of operations isA complete log record for a write operation includesPer WAL semantics, a transaction is officially committed at the momentThe write-ahead rule states that