Give an example of a serializable schedule that could be produced at SNAPSHOT isolation, but could not be produced by a strict two-phase locking concurrency control.

What will be an ideal response?

Solution:

r1(x) w1(x) r2(x) r2(y) w2(y) r1(y) c1 c2

Computer Science & Information Technology

You might also like to view...

Which of the following code segments prints a single line containing hello there with the words separated by a single space?

a. std::cout <

Computer Science & Information Technology

Explain the multiple meanings of the operators << and >>.

What will be an ideal response?

Computer Science & Information Technology