Question: Transactions T 1 , T 2 , . . . , Tn are executed under two - phase locking policy. They follow all locks process
Transactions T T Tn are executed under twophase locking policy. They follow all locks process all unlock execution. Select all situations from the following list that could occur under this execution. Give your reason very briefly points
i The execution could generate redundant locking.
ii One or more transactions could be rolledback multiple times.
iii. Two or more transactions could involve in a cycle.
iv There could be a possibility of cascade rollbacks.
v A transaction could read dirty data dirty read
vi Update of a transaction could be lost lost update
vii. Transaction response time will be good quick response
viii. Locking overhead will be high.
ix Transaction rollback as a result of conflict will be very few.
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
