Multiple choice technology databases

You write a SQL Server stored procedure that will return data for a report. The accuracy of the data is not so important; however, you want to avoid dirty reads. Which isolation level should you avoid?

  1. Read Committed

  2. Read Uncommitted

  3. Repeatable Read

  4. Serializable
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The requirement is to avoid dirty reads, which Read Uncommitted explicitly allows (it reads uncommitted data). Read Committed, Repeatable Read, and Serializable all prevent dirty reads. Since dirty reads must be avoided, Read Uncommitted is the level to avoid.

Keep practicing — related questions