Answer to Question #264601 in Databases | SQL | Oracle | MS Access for jjj

Question

Consider the following schedule of transactions

R1(A) W1(A) R2(A) W2(B) W1(B) Commit1 Commit2

Which of the following properties are true for the above schedule and justify the reason for your answer

with explanation?

a) Conflict Serializable

b) View Serializable

c) Recoverable

Answer 1

Given,

Schedule of transaction

R1(A) W1(A) R2(A) W2(B) W1(B) Commit1 Commit2

From the above, we can say$R_1(A)$ $W_1(A)$ $R_2(A)$ $W_2(B)$ $W_1(B)$ is a Conflict Serializable