Multiple choice

Consider the following transaction T0 and T1<To start><To , A, 1050, 970><To, B, 2030, 2070><To commit><T1 start><T1, C, 720,640><T1 commit> If the system crashes just after log record for the step write C of transaction T1 has been written to stable storage, the log at the time of crash will be

  1. <T0 start> <T0, A, 935><T0, B, 2055>

  2. <T0 start><T0, A, 957><T0, B, 2055><T0 commit><T1 start><T1, C, 640>

  3. <T0 start><T0, A, 957><T0, B, 2055><T0 commit><T1 start><T1, C, 62><T1, Commit>

  4. none of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The log at the time of crash will be option B, which reaches up to commit statement but not including commit statement. Option (2) gives the correct log at the time of crash.

Keep practicing — related questions