Home » MCQs » DBMS MCQs » DBMS States of Transaction MCQs

The database recovery system ensures that the database is back to its ___ if any of the checkpoints fail and the transaction reaches a failed state

11. The database recovery system ensures that the database is back to its ___ if any of the checkpoints fail and the transaction reaches a failed state.

1. Previous Consistent state
2. Post Consistent State
3. Inconsistent State
4. None of the above

Answer: A) Previous Consistent state

Explanation:

The database recovery system ensures that the database is back to its previous consistent state if any of the checkpoints fail and the transaction reaches a failed state.