DBMS-DATABASE RECOVERY SYSTEMS

DBMS-DATABASE RECOVERY SYSTEMS
21. Which of the following failure is caused by hardware failures ?
  • Operations
  • Design
  • Physical
  • None of these
Show Answer
22. For incremental logging with immediate updates, a transaction log record would contain
  • a transaction name, data item name, old value of item and new value of item.
  • a transaction name, data item name, old value of item.
  • a transaction name, data item name, old new value of item.
  • a transaction name and data item name.
Show Answer
23. For incremental logging with immediate updates, a transaction log record would contain
  • a transaction name, data item name, old value of item and new value of item.
  • a transaction name, data item name, old value of item.
  • a transaction name, data item name, old new value of item.
  • a transaction name and data item name.
Show Answer
24. Which of the following is most dangerous type of failures ?
  • Hardware
  • Network
  • Media
  • Software
Show Answer
25. When a failure occurs, the transaction log is referred and each operation is either undone or redone This is a problem because.
  • searching the entire transaction log is time consuming
  • many redo operations are necessary
  • Both (a) and (b)
  • None of these
Show Answer
26. When a failure occurs, the transaction log is referred and ech operation is either undone or redone. This is a problem because
  • Searching the entire transaction log is time consuming.
  • Many redo operations are necessary
  • Both (a) and (b)
  • None of these
Show Answer
27. Hardware failure may incoude
  • memory errors
  • disk crashes
  • disk full errors
  • All of these
Show Answer
28. Software failures may include failures related to softwares such as
  • operating system
  • DBMS software
  • application programs
  • All of these.
Show Answer
29. Which of the followingl is a facility provided by the DBMS to assist the recovery process ?
  • Recovery manager
  • Logging facilities
  • Backup mechanism
  • All of these
Show Answer
30. In the event of failure, principal effects that happen are
  • loss of main memory including the database buffer.
  • the loss of the disk copy secondary storage) of the database.
  • Both (a) and (b)
  • None of these
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test