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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31550393/viewspace-2214087/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31550393/viewspace-2214087/