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
11. The REDO operation copies the old values from log to the database, thus restoring the database prior to a state before the start of the transaction.
- TRUE
- FALSE
12. In case of deferred update technique, updates are not written to the database until after a transaction has reached its COMMIT point.
- TRUE
- FALSE
13. In case of an immediate update. all updates to the database are applied immediately as they occur with waiting to reach the COMMIT point and a record of all changes is kept in the transction log.
- TRUE
- FALSE
14. A checkpoint is a point of synchronisation between the database and the transaction log file.
- TRUE
- FALSE
15. In checkpointing, all buffers are force-writen to secondary storage.
- TRUE
- FALSE
16. The deferred update technique is also known as the UNDO/REDO algorithm
- TRUE
- FALSE
17. Which of the following is not a recovery technique ?
- Shadow paging
- Deferred update
- Write-ahead logging
- Immediate update
18. Incremental logging with deferred updates implies that the recovery system must necwssarily store
- the old value of the updated item in the log
- the new value of the updated item in the log.
- both the lod and new value of the updated item in the log.
- only the begin transaction and commit transaction records in the log.
19. Which of the following are copies of physical database files ?
- Transaction log
- Physical backup
- Logical backup
- None of these
20. In case of transaction failure under a deferred update incremental logging scheme, which of the following will be needed:
- An undo operation
- A redo operation
- both undo and redo operations
- None of these