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 T holds an exclusive lock on the Class table. With strict twophase locking, when does the SELECT statement in transaction T execute?
A schedule with two transactions. Line T: UPDATE Class. Line T: SET TeacherID Line T: WHERE ClassID ; Line T: SELECT CourseTitle. Line T: FROM Class WHERE ClassID ; Line T: ROLLBACK;.
Group of answer choices
Immediately after the UPDATE statement in T executes
After the ROLLBACK statement in T executes
At the same time as the UPDATE statement in T executes
The SELECT statement in T will never execute
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
