MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
IF_____________ARE_NOT_OBTAINED_IN_UNDO_OPERATION_IT_WILL_CAUSE_PROBLEM_IN_UNDO-PHASE.?$ |
| A. | Higher-level lock |
| B. | Lower-level lock |
| C. | Read only lock |
| D. | Read write |
| Answer» C. Read only lock | |
| 2. |
For correct behaviour during recovery, undo and redo operation must b? |
| A. | Commutative |
| B. | Associative |
| C. | Idempotent |
| D. | Distributive |
| Answer» D. Distributive | |
| 3. |
Shadow paging has |
| A. | no redo |
| B. | no undo |
| C. | redo but no undo |
| D. | neither redo nor undo |
| Answer» B. no undo | |
| 4. |
Immediate database modification technique uses |
| A. | Both undo and redo |
| B. | Undo but no redo |
| C. | Redo but no undo |
| D. | Neither undo nor redo |
| Answer» B. Undo but no redo | |
| 5. |
An operation is said to be __________ if executing it several times in a row gives the same result as executing it once. |
| A. | Idempotent |
| B. | Changed |
| C. | Repetitive |
| D. | All of the above |
| Answer» B. Changed | |
| 6. |
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. |
| A. | Persistent |
| B. | Resistant |
| C. | Consistent |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 7. |
Redo operations are performed exclusively using |
| A. | Logical logging |
| B. | Physical logging |
| C. | Physical log records |
| D. | Both Physical logging and Physical log records |
| Answer» E. | |
| 8. |
Which of the following is used for undo operations alone? |
| A. | Logical logging |
| B. | Physical logging |
| C. | Physical log records |
| D. | Physical logging and Physical log records |
| Answer» B. Physical logging | |
| 9. |
Once the lower-level lock is released, the operation cannot be undone by using the old values of updated data items, and must instead be undone by executing a compensating operation; such an operation is called |
| A. | Logical operation |
| B. | Redo operation |
| C. | Logical undo operation |
| D. | Undo operation |
| Answer» B. Redo operation | |
| 10. |
Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value. |
| A. | Higher-level lock |
| B. | Lower-level lock |
| C. | Read only lock |
| D. | Read write |
| Answer» B. Lower-level lock | |