Transaction Processing Concepts, Concurrency and Recovery Each of the following

Question

Transaction Processing Concepts, Concurrency and Recovery

Each of the following protocols has a purpose: serializable schedules or deadlock prevention. Tell what it is for each one: Two-phase locking, wait-die, timestamp ordering. A. 2PL serializability wait-die deadlock prevention timestamp ordering serializability B 2PL serializability wait-die deadlock prevention timestamp ordering deadlock prevention C. 2PL deadlock prevention wait-die deadlock prevention timestamp ordering serializability D. 2PL serializability wait-die serializability timestamp ordering deadlock prevention

Explanation / Answer

Say Ti wants a lock that Tj holds
Two policies are possible:
Wait-Die: If Ti has higher priority, Ti waits for Tj;
otherwise Ti aborts
so wait die comes under the Dead lock prevention.

time stamp order is also comes under dead lock prevention

so answer is option B

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.