Application A is running under the Repeatable Read isolation level and holds an Update lock on
table TAB1. Application B wants to query table TAB1 and cannot wait for Application A to release
its lock. Which isolation level should Application B run under to achieve this objective?
A.
Repeatable Read
B.
Read Stability
C.
Cursor Stability
D.
Uncommitted Read
Uncommitted read
For a SELECT INTO, a FETCH with a read-only cursor, subquery, or fullselect used in an INSERT statement, level Uncommitted Read (UR) allows:
Any row read during the unit of work to be changed by other activation groups that run under a different commitment definition.
Any row changed (or a row that is currently locked with an UPDATE row lock) by another activation group running under a different commitment definition to be read even if the change has not been committed.
0
0