ITPub博客

首页 > 数据库 > Oracle > OCP认证052考试最新题库及答案整理-51

OCP认证052考试最新题库及答案整理-51

原创 Oracle 作者:alice9313 时间:2018-09-13 10:11:17 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2018-08-16

  • 博文量
    74
  • 访问量
    36407