Question

(i)
1
a) Explain what problems can happen there is no
concurrency control where multiple transactions are
being executed at the same time
b) What is strict consistency and why is not possible
to achieve in a distributed system?​

Answer 1

Answer:

Potential problems of Concurrency

Lost Updates occur when multiple transactions select the same row and update the row based on the value selected. Uncommitted dependency issues occur when the second transaction selects a row which is updated by another transaction (dirty read)