Question: Question 2: Does the following partial schedule S obey two phase locking? If it does not change it to obey two phase locking. TI T2

Question 2: Does the following partial schedule S obey two phase locking? If it does not change it to obey two phase locking. TI T2 Lock-X(B) Read(B) Write (B) Lock-X(A) Lock-S(A) Read(A) Unlock(A) Lock-S(B) Read(B) Unlock(B) Unlock(B) Read(A) Write(A) Unlock(A) Question 3: Given the following log: [Start Ti] [T1, B, 20, 25] [Start T2] [check point] [T2, C, 70,60] [T2 Commit] [Start T3] [T3, A, 50, 40] Which transaction IDs are in the undo list and which are in the redo list? 2. What are the values of A, B, and C after the algorithm has finished assume that the log entry is written as [Tid, Item, Old value, New value]? Question 4: 1. Provide an example for dirty read (temporary update) problem? 2. What is meant by term well-formed transaction
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
