Answer to Question #266805 in Databases | SQL | Oracle | MS Access for Brahmateja Yamanur

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

The given transactions

$R1(A) W1(A) R2(A) W2(B) W1(B)$ commit commit2

From the above transaction, we can see that the above transaction is following all the condition of conflict serializable. The condition for the conflict serializable is given below -

1. They belong to different transaction.

2. They access the same item.

3. At least one operation is write operation.

Here $R_1(A)$ and $W_1(A)$ are two different transaction and they access the same item. so it is conflict serializable. So, option A is the correct answer.