Multiple choice technology mainframe

If you want to maximize data concurrency without seeing uncommitted data, which isolation level should you use?

  1. RR

  2. RS

  3. UR

  4. CS

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

UR (Uncommitted Read) isolation level provides maximum data concurrency while preventing access to uncommitted data. This is achieved by allowing transactions to read data that other transactions have modified but not yet committed, while still protecting against reading uncommitted changes. RS (Read Stability), CS (Cursor Stability), and RR (Repeatable Read) are more restrictive levels that reduce concurrency to prevent various types of phenomena like non-repeatable reads and phantom reads.