Get startedGet started for free

Choosing the correct isolation level

Non-repeatable reads occur when a transaction reads a record twice, but the first result is different from the second result as a consequence of another committed transaction altering this data.

From all the isolation levels you have studied so far, which isolation level prevents non-repeatable reads?

This exercise is part of the course

Transactions and Error Handling in SQL Server

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise