DBMS-DATABASE RECOVERY SYSTEMS Questions and Answers

Practice Mode
Showing 10 of 41 questions
Q1
Concurrency control and database recovery are interwined and both are a part of the transaction management
  • A TRUE
  • B FALSE
Answer: Option A
Q2
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.
  • A TRUE
  • B FALSE
Answer: Option A
Q3
Forward recovery is the recovery procedure, which is used in case of physical damage.
  • A TRUE
  • B FALSE
Answer: Option A
Q4
Backward recovery is the recovery procedure, which is uded in case an error occurs in the midst  of normal operation on the database.
  • A TRUE
  • B FALSE
Answer: Option A
Q5
Media failures are the most dangerous failure.
  • A TRUE
  • B FALSE
Answer: Option A
Q6
Media recovery is perormed when there is a head crash (record scratched by a phonograph needle) on the disk.
  • A TRUE
  • B FALSE
Answer: Option A
Q7
The recovery process is closely associated weith the operating system.
  • A TRUE
  • B FALSE
Answer: Option A
Q8
Shadow paging technique does not require the use of a transaction log in a single-user environment
  • A TRUE
  • B FALSE
Answer: Option A
Q9
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.
  • A TRUE
  • B FALSE
Answer: Option A
Q10
The REDO operation updates the database with new values (after-image) that is stored in the log.
  • A TRUE
  • B FALSE
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