IF SEVERAL SESSIONS REQUEST AN EXCLUSIVE LOCK ON THE SAME ROW, WHA...

12. If several sessions request an exclusive lock on the same row, what will

happen? (Choose the best answer.)

A. The first session will get the lock; after it releases the lock there is a

random selection of the next session to get the lock.

B. The first session will get an exclusive lock, and the other sessions will get

shared locks.

C. The sessions will be given an exclusive lock in the sequence in which they

requested it.

D. Oracle will detect the conflict and roll back the statements that would

otherwise hang.