Home »
MCQs »
DBMS MCQs »
DBMS Checkpoint MCQs
What will the transaction T2 and T3 have in the log file?
11. What will the transaction T2 and T3 have in the log file?
- <Tn, Start>
- <Tn, Commit>
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
T2 and T3 will have <Tn, Start> and <Tn, Commit> in the log file.
Case: T1 at the Checkpoint, T2 and T3 in the middle of Checkpoint and Failure, T4 at the Failure respective to time.