Multiple choice technology databases

You write a 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 Read Uncommitted isolation level allows dirty reads because it doesn't lock shared data and can read uncommitted modifications from other transactions. Since the requirement is to avoid dirty reads while accepting reduced accuracy, Read Uncommitted is the isolation level to avoid.

Keep practicing — related questions