BSC CSIT Semester 4 – Database Management System () Questions & Answers | Past TU Exam Papers

Question 1

What are the different approaches of Database recover? What should log file maintain in log-based recovery?

Marks: 5

Year: 2076 Final TU

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

Question 2

What is Checkpoints in database recovery? How does it help in database recovery? Explain.

Marks: 5

Year: 2078 Final TU

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

Question 3

What is Buffer Management in DBMS? Expalain.

Marks: 5

Year: 2079 Final TU

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

Question 4

Why database recovery is essential? Explain recovery technique based on immediate update.

Marks: 5

Year: 2080 Final TU

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

Question 5

Why database recovery is essential? Explain recovery technique based on immediate update.

Marks: 5

Year: 2080 Final TU

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

Question 6

Explain deferred update approach in database recovery.

Marks: 5

Year: 2081 Final TU

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