A transaction using the Read Stability isolation level scans the same table multiple times before it
terminates. Which of the following can occur within this transaction’s processing?
A.
Uncommitted changes made by other transactions can be seen from one scan to the next.
B.
Rows removed by other transactions that appeared in one scan will no longer appear in
subsequent scans.
C.
Rows added by other transactions that did not appear in one scan can be seen in subsequent
scans.
D.
Rows that have been updated can be changed by other transactions from one scan to the next.
Read stability (RS)
The read stability isolation level locks only those rows that an application retrieves during a unit of work. RS ensures that any qualifying row read during a UOW cannot be changed by other application processes until the UOW completes, and that any row changed by another application process cannot be read until the change is committed by that process. Under RS, access to uncommitted data and non-repeatable reads are not possible. However, phantom reads are possible.
0
0