Consider a transaction T1 that committed prior to checkpoint. The record appears in the log before the record. Any modifications made by T1 must have been written to the stable storage either with the checkpoint or prior to it. Thus at recovery time:

Question

Consider a transaction T1 that committed prior to checkpoint. The  record appears in the log before the  record. Any modifications made by T1 must have been written to the stable storage either with the checkpoint or prior to it. Thus at recovery time:

TuteeHUB · Accepted Answer

All of the mentioned

TuteeHUB · Answer

There is a need to perform an undo operation on T1

TuteeHUB · Answer

There is a need to perform a redo operation on T1

TuteeHUB · Answer

There is no need to perform an undo and redo operation on T1

1.	Consider a transaction T1 that committed prior to checkpoint. The record appears in the log before the record. Any modifications made by T1 must have been written to the stable storage either with the checkpoint or prior to it. Thus at recovery time:
A.	There is a need to perform an undo operation on T1
B.	There is a need to perform a redo operation on T1
C.	There is no need to perform an undo and redo operation on T1
D.	All of the mentioned
Answer» D. All of the mentioned

Consider a transaction T1 that committed prior to checkpoint. The record appears in the log before the record. Any modifications made by T1 must have been written to the stable storage either with the checkpoint or prior to it. Thus at recovery time:

Discussion

No Comment Found

Related MCQs

Reply to Comment