Each transaction begins at the time slot of its first Read and commits right after its last
No answer yet for this question.
Ask a Tutor
Question:
Each transaction begins at the time slot of its first Read and commits right after its last Write (same time slot).
Regarding the following questions, give and justify your answers.
1) Assume a checkpoint is made between t4 and t5, what should be done to the four transactions when the crash happens between t6 and t7.
2) Is the transaction schedule conflict serializable? Give the precedence graph to justify your answer.
3) Give a serial schedule of these four transactions.)
4) Construct a schedule (which is different from above) of these four transactions which causes deadlock when using two-phase locking protocol. If no such schedule exists, explain why.
Expert Answer:
Posted Date:
