This is the story of 6 transactions as seen the database change logs. The Action

Question

This is the story of 6 transactions as seen the database change logs. The Action Key below explains how to interpret the entries in the sample logs below. These questions are limited entries in the logs. Assume this is a correct and serializable schedule with appropriate interleaved reads and writes that do NOT cause anomalies. Answer all the following questions based on the log shown below: Answer all the following questions: a) What is the status of the Transactions above at Arrow 1? b) What is the status of the Transactions above at Arrow 2?

Explanation / Answer

Trans

#

8b)

Trans

#

Trans

#

Actions done so far to ech Trans # 1 It has begun. Which means all resources required for the transaction have been locked. 2 It has begun, updated and committed. Which means the updates done have been written permanently to the db, the resources that were locked for the trancaction have been released. 3 It has begun. Which means all resources required for the transaction have been locked 4 It has begun. Which means all resources required for the transaction have been locked 5 Nothing 6 Nothing

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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