Database Recovery System Multiple Choice Questions 1 PDF Download

Practice database recovery system multiple choice questions (MCQs), db test 1 for online course prep exams. Learn aries algorithm in dbms MCQs questions and answers on aries algorithm in dbms, types of database failure, failure classification in dbms, dbms failure classification, algorithms for recovery and isolation exploiting semantics with answers.

Free database recovery system quiz online, study guide has multiple choice question on log records contain with options new value , old value , both a and b and error value to test online e-learning skills for viva exam prep and job's interview questions with answers key. Study to learn aries algorithm in dbms quiz questions with online learning MCQs for competitive exam preparation test.

MCQ on Database Recovery System Quiz PDF Download Test 1

MCQ. Log records contain

  1. Old value
  2. New value
  3. Both A and B
  4. Error value

C

MCQ. The type of blocks that resides on the disk are known as

  1. Logical blocks
  2. Physical blocks
  3. Disk blocks
  4. Buffer blocks

B

MCQ. The error that causes loss of the data of volatile storage, and halts the transaction processing is known as

  1. System error
  2. Application error
  3. System crash
  4. Transaction error

C

MCQ. An integral part of database that can restore the database to the consistent state of before failure is called

  1. Recovery scheme
  2. Backup scheme
  3. Restoring scheme
  4. Transaction scheme

A

MCQ. The pass that determines which transactions to undo is known as

  1. Redo pass
  2. Analysis pass
  3. Undo pass
  4. Logical pass

B