_____ occurs when a transaction accesses data before and after one or more other transactions finish working with such data.
A) Inconsistent retrieval
B) The phenomena of uncommitted data
C) Lost update problems
D) Dirty read problems

Question

_____ occurs when a transaction accesses data before and after one or more other transactions finish working with such data.
A) Inconsistent retrieval 
B) The phenomena of uncommitted data
C) Lost update problems
D) Dirty read problems

Quizplus · Accepted Answer

Inconsistent retrieval occurs when a transaction accesses data that has been modified by other transactions, resulting in the retrieval of inconsistent results. This can happen if other transactions have not yet committed their changes or if the transaction is working with outdated data. This is also known as a non-repeatable read. The other options listed (B, C, and D) are different types of concurrency problems that can occur in database transactions.

_____ Occurs When a Transaction Accesses Data Before and After