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

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 Solution

3.34 Rating (148 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

d The lost update problem does not always result in an inconsistent database state whereas an uncomm... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Principles Of Database Management Questions!