2PL requires Two keys Two tables Two lock types Two programming languages A log

Question

2PL requires Two keys Two tables Two lock types Two programming languages A log is used to A void dirty read anomalies Avoid update anomalies Lock tables Abort transactions If the S-Lock is held until the end of a transaction (commit time), the isolation level is at least: read committed read uncommitted serializable repeatable read A serializable schedule is equivalent to a serial schedule a parallel schedule a serial query an atomic transaction any interleaved schedule If there were no interleaving of transactions, then a transaction might have to wait for another one to finish first locks would not be released deadlocks could occur no transaction would be atomic

Explanation / Answer

36: two lock types

37: Abort transactions

38: serializeable

39: Serial schedule

40: A transaction might have to wait for another one to finish first

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

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