Question

consider the following schedule s1 and s2 consist of transaction ( T1,T2,T3) and s3 and s4 consists of transaction (t1 andt2) .
S1:W1(X) W2(X) R3(X)
S2:W1(X) R3(X) W2(X)
S3:R1(X) W2(X) W1(X)
S4:R1(X) W1(X) W2(X)
Identify the correct statements
A. Schedule s1 and s2 are view equivalent
B. Schedule s1 and s2 are not view equivalent
C. Schedule s3 and s4 are view equivalent
D. Schedule s3 and s4 are not view equivalent

Answer 1

Schedule s1 and s2 are not view equivalent

Answer 2

The correct option is following -  B. Schedule s1 and s2 are not view equivalent.

The concurrency control provides correct result for the generated concurrent operations as soon as possible.

If any failure is occurred in the concurrency control, it can result the data corruption from the torn read or the write operations.