Question 7+3 marksOne or more correct optionsConsider the following log records of transactions where an immediate database modification scheme is used. 1⟨T0,start⟩\langle T0, start \rangle⟨T0,start⟩2⟨T0,A,200,300⟩\langle T0, A, 200, 300 \rangle⟨T0,A,200,300⟩3⟨T1,start⟩\langle T1, start \rangle⟨T1,start⟩4⟨T1,B,1300,1000⟩\langle T1, B, 1300, 1000 \rangle⟨T1,B,1300,1000⟩5⟨T2,start⟩\langle T2, start \rangle⟨T2,start⟩6⟨T2,C,500,300⟩\langle T2, C, 500, 300 \rangle⟨T2,C,500,300⟩7⟨T1,commit⟩\langle T1, commit \rangle⟨T1,commit⟩8⟨T3,start⟩\langle T3, start \rangle⟨T3,start⟩9⟨T0,commit⟩\langle T0, commit \rangle⟨T0,commit⟩10⟨T3,D,400,500⟩\langle T3, D, 400, 500 \rangle⟨T3,D,400,500⟩11⟨CheckpointL1⟩\langle CheckpointL1 \rangle⟨CheckpointL1⟩12⟨T3,commit⟩\langle T3, commit \rangle⟨T3,commit⟩13⟨T2,commit⟩\langle T2, commit \rangle⟨T2,commit⟩14⟨T4,start⟩\langle T4, start \rangle⟨T4,start⟩15⟨T4,E,2000,1500⟩\langle T4, E, 2000, 1500 \rangle⟨T4,E,2000,1500⟩ Suppose failure occurred after the step 15, then which of the following option(s) is/ are the correct?Select all that apply.AT0 and T1 can be ignored.BT0,T1, T2 and T3 can be ignored.CT4 need to be undone.DT0 and T3 need to be redone.
