Answer to Question #265817 in Databases | SQL | Oracle | MS Access for larry

Question

Consider the following schedule of transactions W1(A) W2(A) W1(A) W2(A) W1(A) 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

$W_1(A)W_2(A)W_1(A)W_2(A)W_1(A)$

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 $W_1(A)$ and $W_2(A)$ are two different transaction and they access the same item. so itt is conflict serializable. So, option A is the correct answer.