Bsc CSIT Semester 4 – Database Management System – Unit 10: Database Recovery Techniques (3 Hrs.)

Database Recovery Approaches Database recovery is the process of restoring a database to a consistent state after failures such as system crashes, hardware failures, or transaction errors. Recovery

1. What is a Checkpoint? A Checkpoint is a mechanism in DBMS to reduce the amount of work needed during recovery after a system failure. - It is a snapshot of the database state at a particular mome

1. Definition Buffer Management in DBMS is a technique used to temporarily store data from disk in main memory (RAM) before it is processed. - The buffer is a memory area that acts as an intermediar

1. Why Database Recovery is Essential Database recovery is the process of restoring the database to a correct state after a failure. Reasons why recovery is essential: 1. System Failures: - Cra

Database Recovery and Immediate Update (5 Marks) 1. Why Recovery is Essential - To maintain consistency, integrity, and durability after failures like system crash, transaction failure, or media fail

Deferred Update Approach in Database Recovery The Deferred Update approach, also known as the No-Undo/Redo method, is a database recovery technique in which all updates made by a transaction are not w