Intermediate
Database Management Systems
Q70 / 100
What is a non-repeatable read?
Correct! Well done.
Incorrect.
The correct answer is D) When a transaction reads the same row twice and gets different values because another committed transaction modified it in between
D
Correct Answer
When a transaction reads the same row twice and gets different values because another committed transaction modified it in between
Explanation
Non-repeatable reads occur at READ COMMITTED isolation: re-querying the same row mid-transaction can return updated values from a transaction that committed in between. REPEATABLE READ isolation prevents this by maintaining a consistent snapshot.
Progress
70/100