Q29

Consider the partial Schedule $S$ involving two transactions $T1$ and $T2$. Only the $\textit{read}$ and the $\textit{write}$ operations have been shown. The $\textit{read}$ operation on data item $P$ is denoted by $\textit{read(P)}$ and $\textit{write}$ operation on data item $P$ is denoted by $\textit{write(P)}$.

$$\overset{\large{\text{Schedule S}}}{\begin{array}{c|ll} \textbf{Time Instance}& \rlap{\text{Transaction ID}}\\&\textbf{T1}& \textbf{T2} \\\hline 1& \text{read(A)} \\ 2& \text{write(A)}\\ 3& & \text{read(C)} \\ 4& & \text{write(C)} \\ 5& & \text{read(B)} \\ 6& & \text{write(B)} \\ 7& & \text{read(A)} \\ 8& & \text{commit} \\ 9& \text{read(B)} \\ \end{array}}$$

Suppose that the transaction $T1$ fails immediately after time instance 9. Which of the following statements is correct?