DBMS-DATABASE RECOVERY SYSTEMS Questions and Answers

Practice Mode
Showing 10 of 41 questions
Q11
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.
  • A TRUE
  • B FALSE
Answer: Option B
Q12
In case of deferred update technique, updates are not written to the database until after a transaction has reached its COMMIT point.
  • A TRUE
  • B FALSE
Answer: Option A
Q13
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.
  • A TRUE
  • B FALSE
Answer: Option A
Q14
A checkpoint is a point of synchronisation between the database and  the transaction log file.
  • A TRUE
  • B FALSE
Answer: Option A
Q15
In checkpointing, all buffers are force-writen to secondary storage.
  • A TRUE
  • B FALSE
Answer: Option A
Q16
The deferred update technique is also known as the UNDO/REDO algorithm
  • A TRUE
  • B FALSE
Answer: Option B
Q17
Which of the following is not a recovery technique ?
  • A Shadow paging
  • B Deferred update
  • C Write-ahead logging
  • D Immediate update
Answer: Option C
Q18
Incremental logging with deferred updates implies that the recovery system must necwssarily store
  • A the old value of the updated item in the log
  • B the new value of the updated item in the log.
  • C both the lod and new value of the updated item in the log.
  • D only the begin transaction and commit transaction records in the log.
Answer: Option C
Q19
Which of the following are copies of physical database files ?
  • A Transaction log
  • B Physical backup
  • C Logical backup
  • D None of these
Answer: Option B
Q20
In case of transaction failure under a deferred update incremental logging scheme, which of the following will be needed:
  • A An undo operation
  • B A redo operation
  • C both undo and redo operations
  • D None of these
Answer: Option A

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test