Q29MCQ2 marks, −0.67Consider the following schedule S of transactions T1,T2,T3,T4:T1, T2, T3, T4:T1,T2,T3,T4: T1T2T3T4Reads(X)Writes(X)CommitWrites(X)CommitWrites(Y) Reads(Z)CommitReads(X)Reads(Y)Commit{\begin{array}{|l|l|l|l|}\hline \textbf{T1}& \textbf{T2}& \textbf{T3}& \textbf{T4} \\\hline & \text{Reads(X)} \\ && \text{Writes(X)} \\ && \text{Commit} \\ \text{Writes(X)} \\ \text{Commit}& \\ & \text{Writes(Y) } \\ & \text{Reads(Z)} \\ & \text{Commit} \\ &&& \text{Reads(X)} \\ &&& \text{Reads(Y)} \\ & &&\text{Commit} \\\hline \end{array}}T1Writes(X)CommitT2Reads(X)Writes(Y) Reads(Z)CommitT3Writes(X)CommitT4Reads(X)Reads(Y)Commit Which one of the following statements is CORRECT?(A)S is conflict-serializable but not recoverable(B)S is not conflict-serializable but is recoverable(C)S is both conflict-serializable and recoverable(D)S is neither conflict-serializable not is it recoverableSign in to save attempts.Show answer← PreviousNext →SolutionsDiscussionLoading…Sign in with Google