Chapter 10, Problem 5P

Explanation of Solution

Database recovery process:

It is the process of restoring a database to a previous consistent state. It reverses the process of transaction from inconsistent state to previous consistent state. The duration of database recovery may vary depending on the type and extent of the failure. The user cannot access the previous data without backup.

The database recovery process has the set of predictable scenario is as follows:

• Determine the type and time estimation for the required recovery.
• The recovery process uses the backup copy of the database that needs to convert the consistent state.
• Transaction log can be used to restore all subsequent transactions.

Techniques that was used in database recovery:

The technique of database recovery used to bringing the database to a consistent state after a failure...