(5) What is the concurrency problem of the transactions in table 1? Please select one of...

 

Transcribed Image Text:

(5) What is the concurrency problem of the transactions in table 1? Please select one of the choices below. Please provide a reason to support your answer and explain how to solve your selected problem a) Lost update b) Dirty read c) Non-Repeatable read d) Phantom Table 1. Transaction T1: T2: 1 r(t) 2 w(t) Time Slot 3 commit 4 r(t) 5 commit (5) What is the concurrency problem of the transactions in table 1? Please select one of the choices below. Please provide a reason to support your answer and explain how to solve your selected problem a) Lost update b) Dirty read c) Non-Repeatable read d) Phantom Table 1. Transaction T1: T2: 1 r(t) 2 w(t) Time Slot 3 commit 4 r(t) 5 commit

Answer rating: 100% (QA)

Table 1 The concurrency problin table 1 is Lost Update This is because transaction T1 reads the value of the hits column in row 17 at time slot 3 and ... View the full answer