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 errorB. A user belonging to DSS_QUERIES can log in to a new session but the session will be queuedC. 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
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
相关考题：
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.
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.
Youhavecreatedaresourceplan，DB_PLAN，usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan？（）A.assignuserstoconsumergroupsB.settheresourceplanfortheinstanceC.configureasimpleresourceplanandspecifyplandirectivesD.configureacomplexresourceplanandspecifyplandirectives
Youhavecreatedaresourceplan，DAY.Youexecutethefollowingcode：SQLBEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE（PLAN=’DAY’，COMMENT=’DEPARTMENTSPLAN’，GROUP_OR_SUBPLAN=’DEPARTMENTS’，CPU_P1=0）；END；Then，youissuethefollowingcode：SQLBEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE（PLAN=’DAY’，COMMENT=’DEPARTMENTSPLAN’，GROUP_OR_SUBPLAN=’DEVELOPERS’，CPU_P2=100）；END；Whatwillbetheimpactofexecutingtheabovecode？（）
Youwanttoenabletheuser，Scott，tochangetotheGRP1consumergroupbyissuingthefollowingcode：SQLEXECDBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP（’SCOTT’，’GRP1’，FALSE）；Howwillyougranttheswitchprivilegetotheuser，Scott？（）A.byusingtheDBMS_SESSIONpackageB.bygrantingtheDBAroleC.byusingtheDBMS_RESOURCE_MANAGERpackageD.byusingtheDBMS_RESOURCE_MANAGER_PRIVSpackage
Youupdatedtheresourceplandirectivefortheresourceconsumergroup，DSS_USERS.TheresourceplandirectiveisassignedtotheDSS_PLANbyusingthefollowingstatement：SQLEXECDBMS_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？（）
YouareusingtheDatabaseResourceManagertomanagedatabaseresources.YoucreatedaresourceplandirectivefortheMANAGERSresourceconsumergroupundertheSALES_PLANbyusingthefollowingstatement：SQLEXECDBMS_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？（）
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．＜nav＞B．＜datalist＞C．＜details＞D．＜output＞