Start learning →

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.
Practise this question with Quill — GATE CSE →

Keep practising Database Management Systems

Browse all Database Management Systems questions for GATE CSE, or explore more Computer Science topics.

Start a Database Management Systems lesson →
Related questions