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

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 schedule is conflict serializable as the schedule can be transformed into a serial schedule after swapping of non-conflicting operations