Question: 2 . 1 ) ( 2 Points ) Consider the following two transactions T 1 and T 2 : T 1 : R ( X
Points Consider the following two transactions T and T:
T: RX WX RY WY Commit
T: RY WY RX WX Commit
Draw a schedule for T and T operations that leads to a deadlock when you
use exclusiveshared locking iestate locking Draw the waitfor graph
for your schedule. Answer if deadlock exists or not.
Question Points:
Explain how does the recovery manager ensure atomicity of transactions?
Explain how does the recovery manager ensure durability of transactions?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
