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.

Computer Science & Information Technology

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?

Computer Science & Information Technology

The OneNote Web App has four password protection options

Indicate whether the statement is true or false

Computer Science & Information Technology

Info, Share, Export, and Close are commands found in Backstage view

Indicate whether the statement is true or false

Computer Science & Information Technology

How are Balloons default settings deletions formatted?

A) bolded B) struck out with a line C) italicized D) underlined

Computer Science & Information Technology