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.
Keep practising Database Management Systems
Browse all Database Management Systems questions for GATE CSE, or explore more Computer Science topics.