Under read committed isolation, which of these can still happen inside a single transaction?

Options

• ✗ Reading another transaction's uncommitted change (a dirty read)
• ✓ Reading the same row twice and getting different values (a non-repeatable read) Correct
• ✗ Losing a write after the commit was acknowledged
• ✗ Overwriting another transaction's uncommitted write (a dirty write)

Why

Read committed only promises that you see committed data; another transaction can commit between your two reads. Repeatable read or snapshot isolation gives the whole transaction one consistent view.

Review this in your daily deck → All cards in Databases