DBMS-DATABASE RECOVERY SYSTEMS

DBMS-DATABASE RECOVERY SYSTEMS
1. Concurrency control and database recovery are interwined and both are a part of the transaction management
  • TRUE
  • FALSE
Show Answer
2. Database recovery is a service that is provided by the DBMS to ensure that the database is reliable and remains in consistent state in case of a failure.
  • TRUE
  • FALSE
Show Answer
3. Forward recovery is the recovery procedure, which is used in case of physical damage.
  • TRUE
  • FALSE
Show Answer
4. Backward recovery is the recovery procedure, which is uded in case an error occurs in the midst  of normal operation on the database.
  • TRUE
  • FALSE
Show Answer
5. Media failures are the most dangerous failure.
  • TRUE
  • FALSE
Show Answer
6. Media recovery is perormed when there is a head crash (record scratched by a phonograph needle) on the disk.
  • TRUE
  • FALSE
Show Answer
7. The recovery process is closely associated weith the operating system.
  • TRUE
  • FALSE
Show Answer
8. Shadow paging technique does not require the use of a transaction log in a single-user environment
  • TRUE
  • FALSE
Show Answer
9. In shadow both the before-image and after-image are kept on the disk, thus avoiding the need for a transaction log for the recovery process.
  • TRUE
  • FALSE
Show Answer
10. The REDO operation updates the database with new values (after-image) that is stored in the log.
  • TRUE
  • FALSE
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test