What is the difference between a non-repeatable read and a dirty read?

Explanation

A dirty read involves reading uncommitted data from another transaction, while a non-repeatable read happens when a committed row changes value between two reads in the same transaction.

Key points

A dirty read accesses uncommitted data from another transaction
A non-repeatable read encounters a committed row changing value within the same transaction
Both scenarios involve reading data inconsistencies due to concurrent transactions

Ready to go further?

Start full exam Practice more questions