DB Recovery Systems Mcqs

Our collections of Multiple choice questions and answers focuses on study of ” DB Recovery Systems “. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate knowledge on DB Recovery Systems comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. DB Recovery Systems Mcqs
  8. »
  9. Page 6

Computer MCQS

Sciences MCQS

76.
Which of the following is used for undo operations alone ?

Logical logging

Physical logging

Physical log records

Physical logging and Physical log records

Answer Discus (0)

77.
Redo operations are performed exclusively using

Logical logging

Physical logging

Physical log records

Both Physical logging and Physical log records

Answer Discus (0)

78.
To perform logical redo or undo, the database state on disk must be operation ___________ that is, it should not have partial effects of any operation.

Persistent

Resistant

Consistent

None of the mentioned

Answer Discus (0)

79.
An operation is said to be __________ if executing it several times in a row gives the same result as executing it once.

Idempotent

Changed

Repetitive

All of the above

Answer Discus (0)

80.
Immediate database modification technique uses

Both undo and redo

Undo but no redo

Redo but no undo

Neither undo nor redo

Answer Discus (0)

82.
For correct behavior during recovery, undo and redo operation must be

Commutative

Associative

Idempotent

Distributive

Answer Discus (0)

83.
If ___________ are not obtained in undo operation it will cause problem in undo-phase.

Higher-level lock

Lower-level lock

Read only lock

Read write

Answer Discus (0)

Engineering MCQS

General Subjects MCQS

0Shares
0
Scroll to Top