Question: Refer to the table and schedule below. The UPDATE statement in transaction T 1 holds an exclusive lock on the Class table. With strict two

Refer to the table and schedule below. The UPDATE statement in transaction T1 holds an exclusive lock on the Class table. With strict two-phase locking, when does the SELECT statement in transaction T2 execute?
A schedule with two transactions. Line 1, T1: UPDATE Class. Line 2, T1: SET TeacherID =32412. Line 3, T1: WHERE ClassID =80;. Line 4, T2: SELECT CourseTitle. Line 5, T2: FROM Class WHERE ClassID =80;. Line 6, T1: ROLLBACK;.
Group of answer choices
Immediately after the UPDATE statement in T1 executes
After the ROLLBACK statement in T1 executes
At the same time as the UPDATE statement in T1 executes
The SELECT statement in T2 will never execute

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!