Which statement is not correct? a. A lost update problem occurs if an otherwise successful update of
Question:
Which statement is not correct?
a. A lost update problem occurs if an otherwise successful update of a data item by a transaction is overwritten by another transaction that wasn’t “aware” of the first update.
b. If a transaction reads one or more data items that are being updated by another, as yet uncommitted, transaction, we may run into the uncommitted dependency problem.
c. The inconsistent analysis problem denotes a situation in which a transaction reads partial results of another transaction that simultaneously interacts with (and updates) the same data items.
d. The lost update problem does not always result in an inconsistent database state, whereas an uncommitted dependency or inconsistent analysis always yields an inconsistent database state.
Step by Step Answer:
Principles Of Database Management The Practical Guide To Storing Managing And Analyzing Big And Small Data
ISBN: 9781107186125
1st Edition
Authors: Wilfried Lemahieu, Seppe Vanden Broucke, Bart Baesens