In the Student Registration System, give an example of a schedule in which a deadlock occurs.
What will be an ideal response?
Consider the concurrent execution of a registration transaction, T1, and a deregistration transaction, T2, for the same course and assume the DBMS uses page locking:
T2 first deletes the rowin Transcript describing the student registered in that course and then decrements CurReg in Course. The registration transaction, T1, first updates Course, and then inserts a tuple in Transcript.
The schedule is:
w2(x) w1(y) w2(y) w1(x)
A deadlock might result since T1 and T2 obtain their locks in the opposite order.
You might also like to view...
Draw a house on the beach where we put the mysterious box previously.
What will be an ideal response?
The OneNote Web App has four password protection options
Indicate whether the statement is true or false
Info, Share, Export, and Close are commands found in Backstage view
Indicate whether the statement is true or false
How are Balloons default settings deletions formatted?
A) bolded B) struck out with a line C) italicized D) underlined