Question: 2 . 1 ) ( 2 Points ) Consider the following two transactions T 1 and T 2 : T 1 : R ( X

2.1)(2 Points) Consider the following two transactions T1 and T2:
T1: R(X) W(X) R(Y) W(Y) Commit
T2: R(Y) W(Y) R(X) W(X) Commit
Draw a schedule for T1 and T2 operations that leads to a deadlock when you
use exclusive/shared locking (i.e.3-state locking). Draw the wait-for graph
for your schedule. Answer if deadlock exists or not.
Question 3(2 Points):
3.1) Explain how does the recovery manager ensure atomicity of transactions?
3.2) 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!