400-090-9964


博客 | 论坛

教学文章

【ocp 12c】OCP 062最新考试题库原题解析-第14题

时间:2019-04-23 来源:

2018年OCP 11g考试原题解析已经讲解30多次课,500多道考试原题,最终达到98%以上的考题覆盖度及95%以上的考试通过率。

2019年OCP 11g将升级到12c,OCP 12c考试解析免费公开课也已经开始了,欢迎大家收看!

OCP解析公开课时间:【每周五晚8点】

OCP解析公开课地址:https://ke.qq.com/course/326223

OCP解析群资料分享:569933648 验证:ocp

另外,除了OCP公开课,OCM题库直播也同步进行中,OCM最新题库大爆料-【每周四晚8点】,【微信群直播】,可以联系咨询老师进群参与

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

QUESTION 14

Examine the resources consumed by a database instance whose current Resource Manager

plan is displayed.

SQL> SELECT name, active_sessions, queue_length,

Consumed_cpu_time, cpu_waits, cpu_wait_time

FROM v$rsrc_consumer_group;

Which two statements are true?

A. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.

B. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.

C. The CPU_WAIT_TIME column indicates the total time that sessions in t he consumer group waited for the CPU due to resource management.

D. The CPU_WAIT_TIME column indicates the total time that sessions in t he consumer group waited for the CPU due to I/O waits and latch or enqueue contention.

E. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.

Correct Answer: CE

版权所有@北京神脑资讯技术有限公司(CUUG,中国UNIX用户协会) Copyright 2017 ALL Rights Reserved 京ICP备11008061号 京公网110108006275号

CUUG旗下网站:www.cuug.com.cn www.cuug.com oracle.cuug.com bbs.cuug.com bd.cuug.com

电话:010-59426307 010-59426319 邮政编码:100089

海淀校区:北京市海淀区紫竹院路88号紫竹花园4号楼D座703(CUUG)