OCP换题库了，最新052考试题库及答案整理-51

51、Examine this query and its output:

SQL> select sid,event,blocking_session

from v$session

where blocking_session is not null;

SID EVENT BLOCKING_SESSION

---- --------------------------- ----------------

105 enq:TX - row lock contention 15

Which two are true?

A. The blocked session is waiting on a shared table lock.

B. The blocked session is waiting on an enqueue.

C. The blocking session is waiting on a row-level lock.

D. Session 105 is blocked by session 15.

E. Session 105 is blocking session 15.

Correct Answer: BD

北京CUUG整理，转载请注明，OCP讨论群：569933648/836361015