Redo operations are performed exclusively using

Both Physical logging and Physical log records

Which of the following is used for undo operations alone?

Physical logging and Physical log records

Explore topic-wise MCQs in Database.

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

Discussion

2.	For correct behaviour during recovery, undo and redo operation must b?
A.	Commutative
B.	Associative
C.	Idempotent
D.	Distributive
Answer» D. Distributive

Discussion

3.	Shadow paging has
A.	no redo
B.	no undo
C.	redo but no undo
D.	neither redo nor undo
Answer» B. no undo

Discussion

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

Discussion

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

Discussion

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

Discussion

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.

Discussion

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

Discussion

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

Discussion

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

Discussion

Explore topic-wise MCQs in Database.

IF_____________ARE_NOT_OBTAINED_IN_UNDO_OPERATION_IT_WILL_CAUSE_PROBLEM_IN_UNDO-PHASE.?$

For correct behaviour during recovery, undo and redo operation must b?

Shadow paging has

Immediate database modification technique uses

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

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.

Redo operations are performed exclusively using

Which of the following is used for undo operations alone?

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

Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.