Multiple choice technology databases

If an application issues the same query more than once in the same unit of work,which isolation level will not permit this application to see additional rows inserted by other application?

  1. Read stability (RS)

  2. Repeatable Read (RR)

  3. Uncommited Read (UR)

  4. Cursor Stability (CS)
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Repeatable Read (RR) isolation level prevents phantom reads, ensuring that a query executed multiple times in the same transaction does not see new rows inserted by other applications. Read Stability (RS) only prevents modifications to existing rows but allows new rows to appear, making it incorrect here.

Keep practicing — related questions