Application A holds an Exclusive lock on table TAB1 and needs to acquire an Exclusive lock on
table TAB2. Application B holds an Exclusive lock on table TAB2 and needs to acquire an
Exclusive lock on table TAB1. If lock timeout is set to -1 and both applications are using the Read
Stability isolation level, which of the following will occur?
A.
Applications A and B will cause a deadlock situation
B.
Application B will read the copy of table TAB1 that was loaded into memory when Application A
first read it
C.
Application B will read the data in table TAB1 and see uncommitted changes made by
Application A
D.
Application B will be placed in a lock-wait state until ApplicationA releases its lock