Home › GATE CSE › computerscience › Database Management Systems › Which is NOT a recovery-relevant failure type pe…
Which is NOT a recovery-relevant failure type per the chapter?
Atransaction failure (logical error in the transaction itself)
Buser data-entry typo on a form
Csystem crash (DBMS process dies, memory lost)
Dmedia failure (disk itself fails)
Answer & Solution
Correct answer: B. user data-entry typo on a form
Typos are caught by application validation, not by the recovery subsystem. The three failure modes recovery cares about are transaction, system, and media. A typo that passes validation just becomes a committed transaction the DBMS treats as legitimate.
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 isAfter a crash, with checkpointing, the recovery system scans the logA complete log record for a write operation includesPer WAL semantics, a transaction is officially committed at the moment