11

Database Recovery System

1.   Define recovery manager. What are the properties of transactions that it preserves?

Ans: The component of DBMS that is responsible for performing the recovery operations is called recovery manager. The main aim of recovery is to restore the database to the most recent consistent state.

The recovery manager ensures that the two important properties of transactions namely, atomicity and durability are preserved. It preserves atomicity by undoing actions of uncommitted transactions and durability by ensuring that all the actions of committed transactions survive any type of failure.

2.   What information is maintained by recovery manager during normal execution of transactions?

Ans: The recovery manager maintains ...

Get Express Learning: Database Management Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.