DBMS-DATABASE RECOVERY SYSTEMS Questions and Answers

Practice Mode
Showing 10 of 41 questions
Q21
Which of the following failure is caused by hardware failures ?
  • A Operations
  • B Design
  • C Physical
  • D None of these
Answer: Option B
Q22
For incremental logging with immediate updates, a transaction log record would contain
  • A a transaction name, data item name, old value of item and new value of item.
  • B a transaction name, data item name, old value of item.
  • C a transaction name, data item name, old new value of item.
  • D a transaction name and data item name.
Answer: Option A
Q23
For incremental logging with immediate updates, a transaction log record would contain
  • A a transaction name, data item name, old value of item and new value of item.
  • B a transaction name, data item name, old value of item.
  • C a transaction name, data item name, old new value of item.
  • D a transaction name and data item name.
Answer: Option A
Q24
Which of the following is most dangerous type of failures ?
  • A Hardware
  • B Network
  • C Media
  • D Software
Answer: Option C
Q25
When a failure occurs, the transaction log is referred and each operation is either undone or redone This is a problem because.
  • A searching the entire transaction log is time consuming
  • B many redo operations are necessary
  • C Both (a) and (b)
  • D None of these
Answer: Option C
Q26
When a failure occurs, the transaction log is referred and ech operation is either undone or redone. This is a problem because
  • A Searching the entire transaction log is time consuming.
  • B Many redo operations are necessary
  • C Both (a) and (b)
  • D None of these
Answer: Option C
Q27
Hardware failure may incoude
  • A memory errors
  • B disk crashes
  • C disk full errors
  • D All of these
Answer: Option D
Q28
Software failures may include failures related to softwares such as
  • A operating system
  • B DBMS software
  • C application programs
  • D All of these.
Answer: Option D
Q29
Which of the followingl is a facility provided by the DBMS to assist the recovery process ?
  • A Recovery manager
  • B Logging facilities
  • C Backup mechanism
  • D All of these
Answer: Option D
Q30
In the event of failure, principal effects that happen are
  • A loss of main memory including the database buffer.
  • B the loss of the disk copy secondary storage) of the database.
  • C Both (a) and (b)
  • D None of these
Answer: Option C

📚 More from Database

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