Which of the following is an example of lost update?
A) The system assigns the last aisle seat on a flight to John whereas Peter receives a window seat, although both indicated preference for an aisle seat
B) John and Peter receive each a window seat as they both requested
C) John is initially assigned the last window seat, but this seat is later on assigned to Peter
D) None of the above

Question

Quizplus · Accepted Answer

A lost update occurs when multiple transactions try to update the same data item simultaneously, and the system fails to preserve all updates. Therefore, in this scenario, John is initially assigned the last window seat but later loses it to Peter, making it an example of a lost update. Option A involves an incorrect assignment, but it is not a case of lost update. Option B has no conflicting updates, and option D is not correct as there is an instance of lost update in option C.

Which of the Following Is an Example of Lost Update