DBMS-DATABASE RECOVERY SYSTEMS Questions and Answers

Practice Mode
Showing 10 of 41 questions
Q31
When using a transaction log based recovery scheme, it might improve performance as well as providing a recovery mechanism by
  • A writing the appropriate log records to disk during the transaction's execution
  • B writing the log records to dick when each transaction commits
  • C never writing the log records to disk.
  • D waiting to write the log records until multiple transactions commit and writting them as a batch.
Answer: Option A
Q32
Which of the following is an example of a NO-UNDO/REDO algorithm /
  • A Shadow paging
  • B Immediate update
  • C Deferred update
  • D None of these
Answer: Option A
Q33
Which of the following is an example of a UNDO/REDO algorithm ?
  • A Shadow paging
  • B Immediate update
  • C Deferrd update
  • D None of these
Answer: Option B
Q34
If the shadowing approach is used for flushing a data item back to disk, then the item is written to
  • A the same disk location from which it was read.
  • B disk before the transaction commits.
  • C disk only after the transaction commits.
  • D a different location on disk.
Answer: Option A
Q35
If the shadowing approach is used for flushing a data item back to disk, then the item is written to
  • A the same disk location form which it was read.
  • B disk before the trasaction commits
  • C disk only after the transaction commits.
  • D a different location on disk.
Answer: Option A
Q36
Shadow paging was introduced by
  • A Lorie
  • B Codd
  • C IBM
  • D Boyce
Answer: Option A
Q37
Shadow paging technique maintains
  • A two page tables
  • B three page tables
  • C four page tables
  • D five page tables
Answer: Option A
Q38
The checkpoint technique is used to limit
  • A the volume of log information.
  • B amount of searching
  • C subsequent processing that is needed to carry out on the transaction log file.
  • D All of these
Answer: Option A
Q39
Which of the following recovery technique does not need log ?
  • A Shadow paging
  • B Immediate update
  • C Deferred update
  • D None of these
Answer: Option D
Q40
The failure may be the result of
  • A a system crash due to hardware or software erors
  • B a media failure such as head crash
  • C a software error in the application such as a logical error in the program that is accessing the database
  • D All 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