itgle.com

View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?()A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an

题目
View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?()

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

B. A user belonging to DSS_QUERIES can log in to a new session but the session will be queued

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

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

相似考题

1.The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline.Which two operations are performed by the optimizer in this scenario?（）A. The optimizer adds the new plan to the plan history.B. The optimizer selects the new plan for the execution of the SQL statement.C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

2.Youhavecreatedaresourceplan，DB_PLAN，usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan？（）A.assignuserstoconsumergroupsB.settheresourceplanfortheinstanceC.configureasimpleresourceplanandspecifyplandirectivesD.configureacomplexresourceplanandspecifyplandirectives

3.Youhavecreatedaresourceplan，DAY.Youexecutethefollowingcode：SQL>BEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE（PLAN=>’DAY’，COMMENT=>’DEPARTMENTSPLAN’，GROUP_OR_SUBPLAN=>’DEPARTMENTS’，CPU_P1=0）；END；Then，youissuethefollowingcode：SQL>BEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE（PLAN=>’DAY’，COMMENT=>’DEPARTMENTSPLAN’，GROUP_OR_SUBPLAN=>’DEVELOPERS’，CPU_P2=100）；END；Whatwillbetheimpactofexecutingtheabovecode？（）

4.Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements.What would you do with these SQL statements?（）A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B. Capture the plans from the previous version using STS and then load them into the stored outline.C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

更多“View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?() ”相关问题

  • 第1题：

    Youwanttoenabletheuser，Scott，tochangetotheGRP1consumergroupbyissuingthefollowingcode：SQL>EXECDBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP（’SCOTT’，’GRP1’，FALSE）；Howwillyougranttheswitchprivilegetotheuser，Scott？（）

    A.byusingtheDBMS_SESSIONpackage

    B.bygrantingtheDBArole

    C.byusingtheDBMS_RESOURCE_MANAGERpackage

    D.byusingtheDBMS_RESOURCE_MANAGER_PRIVSpackage


    参考答案：D

  • 第2题：

    YouareusingtheDatabaseResourceManagertomanagedatabaseresources.YoucreatedaresourceplandirectivefortheMANAGERSresourceconsumergroupundertheSALES_PLANbyusingthefollowingstatement：

    SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE

    （PLAN=>’SALES_PLAN’，

    GROUP_OR_SUBPLAN=>’MANAGERS’，

    CPU_P1=>100，CPU_P2=>0，

    SWITCH_GROUP=>’CLERKS’，

    SWITCH_TIME_IN_CALL=>600）；

    Auser，SCOTT，whoisassignedtotheMANAGERSgroup，startsadatabasesessionandexecutesaqueryonthedatabase.Whatistheoutcomeifthequerytakesapproximately15minutestocomplete？（）


    参考答案：D

  • 第3题：

    13、以下命令中修改变量值用法错误的是哪个？

    A．hive> set hivevar:name=qiuqiu;

    B．hive> set hiveconf:hive.cli.print.current.db=true;

    C．hive> set hiveconf:hive.cli.print.current.db=true;

    D．hive> set env: HOME=/root;


    A

  • 第4题：

    Youupdatedtheresourceplandirectivefortheresourceconsumergroup，DSS_USERS.TheresourceplandirectiveisassignedtotheDSS_PLANbyusingthefollowingstatement：

    SQL>EXECDBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE（PLAN=>’DSS_PLAN’，

    GROUP_OR_SUBPLAN=>’DSS_USERS’，

    NEW_CPU_P1=>80，

    NEW_SWITCH_GROUP=>’CANCEL_SQL’，

    NEW_SWITCH_ESTIMATE=>TRUE，

    NEW_SWITCH_TIME=>600）；

    Auserconnectstothedatabaseandstartsanoperation.WhatistheoutcomeifOracleestimatesthattheexecutiontimeforthisoperationwillexceed600seconds？（）


    参考答案：B

  • 第5题：

    要隐藏view组件中的内容，应该将view组件的（）属性设置为true？

    A．hidden

    B．display

    C．height

    D．width


    hidden

  • 第6题：

    下列哪个标签定义导航链接的部分

    A．＜nav＞

    B．＜datalist＞

    C．＜details＞

    D．＜output＞


    ＜nav＞

相关内容