Question

Consider a transaction T1 that committed prior to checkpoint. The <T1 commits> record appears in the log before the <checkpoint> 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

I had been asked this question during a job interview.

This question is from Atomic Transactions topic in division Process Synchronization of Operating System

Answer 1

Right option is (c) There is no need to perform an undo and redo operation on T1

To explain: None.