DBMS-DATABASE RECOVERY SYSTEMS Questions and Answers
DBMS – Database Recovery Systems Questions with Answers help students understand how databases maintain consistency and restore data after failure. Topics include transaction logs, checkpoints, and recovery techniques. These DBMS programming interview questions with answers are valuable for candidates preparing for placements at Oracle, TCS, and Wipro. Practicing these ensures better conceptual clarity on database reliability and integrity mechanisms.
DBMS-DATABASE RECOVERY SYSTEMS
Showing 10 of
41 questions
1. Concurrency control and database recovery are interwined and both are a part of the transaction management
- TRUE
- FALSE
2. Database recovery is a service that is provided by the DBMS to ensure that the database is reliable and remains in consistent state in case of a failure.
- TRUE
- FALSE
3. Forward recovery is the recovery procedure, which is used in case of physical damage.
- TRUE
- FALSE
4. Backward recovery is the recovery procedure, which is uded in case an error occurs in the midst of normal operation on the database.
- TRUE
- FALSE
6. Media recovery is perormed when there is a head crash (record scratched by a phonograph needle) on the disk.
- TRUE
- FALSE
7. The recovery process is closely associated weith the operating system.
- TRUE
- FALSE
8. Shadow paging technique does not require the use of a transaction log in a single-user environment
- TRUE
- FALSE
9. In shadow both the before-image and after-image are kept on the disk, thus avoiding the need for a transaction log for the recovery process.
- TRUE
- FALSE
10. The REDO operation updates the database with new values (after-image) that is stored in the log.
- TRUE
- FALSE