Answer to Question #269964 in Databases | SQL | Oracle | MS Access for Tarurendra Kushwah

Question

Check whether Schedule is serial, serializable, Conflict serializable

S:R2(Z),R2(Y),W2(Y),R3(Y),R3(Z),R1(X),W1(X),W3(Y)W3(Z)R2(X)R1(Y)W1(Y)

Answer 1

The schedule is conflict serializable; when

R1(X) is still reading X, W1(X) is also reading X so when R1 reads reads X it overrides W1(X) and the transaction is lost.