Classify concurrency anomaly between two transactions

Q: Classify concurrency anomaly between two transactions

This question evaluates proficiency in database concurrency control and transaction isolation within the Software Engineering Fundamentals domain, focusing on identifying concurrency anomalies that affect data integrity and update correctness.

Q: How do I approach Software Engineering Fundamentals interview questions?

Software Engineering Fundamentals questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master software engineering fundamentals interviews.

Question

Two transactions T1 and T2 run concurrently and access the same data item A. Their operations (in order of time) are:

T1 reads A = 100 .
T2 reads A = 100 .
T1 writes A = A + 10 (so conceptually writes 110 ).
T2 writes A = A - 10 (using its previously read value 100 , so writes 90 ).

Which description best characterizes the concurrency problem here?

Options:

A. This operation cannot be repeatably read (non-repeatable read).
B. This operation has no problems.
C. This operation reads dirty data.
D. This operation loses modifications (lost update).

Classify concurrency anomaly between two transactions

Solution

Comments (0)

Classify concurrency anomaly between two transactions

Overview

Solution

Comments (0)