the subject is database and it is about recovery. Database Recovery A) Using simple UNDO and REDO

the subject is database  and it is about recovery.

 

Transcribed Image Text:

Database Recovery A) Using simple UNDO and REDO techniques, what actions are taken for T1, T2, and T3 in the following schedule logs? Include what values each data item is restored to, as well as any additional log entries that are required. Schedule 1 Schedule 2 Schedule 3 Recovery Actions: Schedule 1: Schedule 2: Schedule 3: B) Will the following schedule cause a cascading rollback? Why or why not? WRITE(A) WRITE(B) + commit WRITE(C) T READ(A) READ(B) checkpoint crash time Database Recovery A) Using simple UNDO and REDO techniques, what actions are taken for T1, T2, and T3 in the following schedule logs? Include what values each data item is restored to, as well as any additional log entries that are required. Schedule 1 Schedule 2 Schedule 3 Recovery Actions: Schedule 1: Schedule 2: Schedule 3: B) Will the following schedule cause a cascading rollback? Why or why not? WRITE(A) WRITE(B) + commit WRITE(C) T READ(A) READ(B) checkpoint crash time