black

1z0-043

登录

单项选择题

You want to enable the user, Scott, to change to the GRP1 consumer group by issuing the following code:       
SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP 
(’SCOTT’,       ’GRP1’, FALSE);  
How will you grant the switch privilege to the user, Scott?()  

A. by using the DBMS_SESSION package
B. by granting the DBA role
C. by using the DBMS_RESOURCE_MANAGER package
D. by using the DBMS_RESOURCE_MANAGER_PRIVS package

相关考题

单项选择题 You issue the following code:    EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP        (’SCOTT’ ’GRP1’, TRUE);   What will be the result of executing the above code?()

单项选择题 You updated the resource plan directive for the resource consumer group, DSS_USERS. The resource plan directive is assigned to the DSS_PLAN by using the following statement:   SQL>EXEC DBMS_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); A user connects to the database and starts an operation. What is the outcome if Oracle estimates that the execution time for this operation will exceed 600 seconds?()

单项选择题 TheDatabaseResourceManagerisnotcurrentlyactiveinyourdatabasethatisupandrunning.YoucreatedaresourceplannamedDAY_PLANthatcontainstwosub-plansnamedMANAGERS_PLANandCLERKS_PLAN.YoudecidedtoactivateDAY_PLANbyexecutingthefollowingstatement:SQL>ALTERSYSTEMSETRESOURCE_MANAGER_PLAN=’managers_plan’;Whatwillbetheoutcomeofthisstatement?()

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064