UMKC Isolation Levels & Index Locking Deadlock Database Management Design Question
Question Description
Hello,
I need someone to respond this one multiple choice and this exercise, covers isolation levels, predicate and index locking, deadlock prevention, etc.
Question 1:
Choose which of the following histories will result with 2PL and a cautious wait strategy. The follwoing is order of operations as given to the scheduler.
r1(x); w1(x); r2(y); w2(x); r3(z); w1(z); c1; c2; c3
a. r1(x); w1(x); r2(y); w2(x); r3(z); w1(z); c1; c2; c3
b. r1(x); w1(x); r2(y); a2; r3(z); c3; w1(z); c1; c2
c. r1(x); w1(x); r2(y); r3(z); c3; w1(z); c1; w2(x); c2
d. Deadlock occurs.
Question 2
T1 is going to read all the students from the student table who live in the state of MO. Show the lock the table with predicate locking.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."