DBMS-DATABASE RECOVERY SYSTEMS Questions and Answers
DBMS – Database Recovery Systems Questions with Answers help students understand how databases maintain consistency and restore data after failure. Topics include transaction logs, checkpoints, and recovery techniques. These DBMS programming interview questions with answers are valuable for candidates preparing for placements at Oracle, TCS, and Wipro. Practicing these ensures better conceptual clarity on database reliability and integrity mechanisms.
DBMS-DATABASE RECOVERY SYSTEMS
Showing 10 of
41 questions
21. Which of the following failure is caused by hardware failures ?
- Operations
- Design
- Physical
- None of these
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.
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.
24. Which of the following is most dangerous type of failures ?
- Hardware
- Network
- Media
- Software
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
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
27. Hardware failure may incoude
- memory errors
- disk crashes
- disk full errors
- All of these
28. Software failures may include failures related to softwares such as
- operating system
- DBMS software
- application programs
- All of these.
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
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