Transaction Processing Concepts, Concurrency and Recovery How can you identify t

Question

Transaction Processing Concepts, Concurrency and Recovery

How can you identify the begining of the shrinking phase of the two phase locking protocol? When does the shrinking phase begin for the rigorous 2PL? A. When the transaction uses an unlock. As soon as the first unlock of the transaction. B. Shrinking phase begins with first unlock or downgrade and no lock after first unlock. C. Normally: first unlock or downgrade; rigorous form: after committing or aborting. D. When no new locks can be obtained but can release locks.

Explanation / Answer

B. Shrinking phase begins with first unlock or downgrade and no lock after first unlock.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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