DBMS-DATABASE RECOVERY SYSTEMS

DBMS-DATABASE RECOVERY SYSTEMS
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
Show Answer
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
Show Answer
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
Show Answer
14. A checkpoint is a point of synchronisation between the database and  the transaction log file.
  • TRUE
  • FALSE
Show Answer
15. In checkpointing, all buffers are force-writen to secondary storage.
  • TRUE
  • FALSE
Show Answer
16. The deferred update technique is also known as the UNDO/REDO algorithm
  • TRUE
  • FALSE
Show Answer
17. Which of the following is not a recovery technique ?
  • Shadow paging
  • Deferred update
  • Write-ahead logging
  • Immediate update
Show Answer
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.
Show Answer
19. Which of the following are copies of physical database files ?
  • Transaction log
  • Physical backup
  • Logical backup
  • None of these
Show Answer
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
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test