Question: Transactions T 1 , T 2 , . . . , Tn are executed under two - phase locking policy. They follow all locks process

Transactions T1, T2,..., Tn are executed under two-phase 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 (8 points).
i. The execution could generate redundant locking.
ii. One or more transactions could be rolled-back multiple times.
iii. Two or more transactions could involve in a cycle.
iv. There could be a possibility of cascade roll-backs.
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 roll-back 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 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!