Give an example of a schedule of two transactions in which a two-phase locking concurrency control aborts one of the transactions (because of a deadlock) but a SNAPSHOT isolation control allows both transactions to commit.

What will be an ideal response?

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

Computer Science & Information Technology

You might also like to view...

Which of the following is a best practice when setting up a client to use the LDAPS protocol with a server?

A. The client should follow LDAP referrals to other secure servers on the network B. The client should trust the CA that signed the server's certificate C. The client should present a self-signed certificate to the server D. The client should have access to port 389 on the server

Computer Science & Information Technology

execution time = O(n) is an example of big-O ____________________.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology