Database Recovery System Multiple Choice Questions and Answers 1 PDF Download

Learn database recovery system MCQs, mastering database management system test 1 for online learning, course exam prep. Practice aries algorithm in dbms MCQs, database recovery system multiple choice 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 test for online computer engineering degree courses distance learning.

Free online database recovery system quiz, self-study student guide has multiple choice question: log records contain with options new value , old value , both a and b and error value for online tutoring, subjective theory tests and online associate of science degree preparation. Study to learn online aries algorithm in dbms quiz questions with database management system MCQs for IT certifications competitive exam prep.

MCQ on Database Recovery System Test 1 Quiz PDF Download

MCQ: Log records contain

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

C

MCQ: Type of blocks that resides on disk are known as

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

B

MCQ: Error that causes loss of data of volatile storage, and halts 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 database to consistent state of before failure is called

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

A

MCQ: Pass that determines which transactions to undo is known as

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

B