Which statement is not correct? a. Deadlock prevention can be achieved by static 2PL. b. One approach
Question:
Which statement is not correct?
a. Deadlock prevention can be achieved by static 2PL.
b. One approach for deadlock resolution is victim selection, which means choosing and aborting one of the transactions involved in the deadlock.
c. The use of short-term locks violates rule 3 of the 2PL Protocol, so serializability can no longer be guaranteed.
d. The read committed isolation level uses long-term read locks, but short-term write locks.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Principles Of Database Management The Practical Guide To Storing Managing And Analyzing Big And Small Data
ISBN: 9781107186125
1st Edition
Authors: Wilfried Lemahieu, Seppe Vanden Broucke, Bart Baesens
Question Posted: