black

1z0-043

登录

单项选择题

The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement:       SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’;  What will be the outcome of this statement?()  

A. The statement will deactivate DAY_PLAN.
B. The statement will activate DAY_PLAN as the top plan.
C. The statement will activate MANAGERS_PLAN as the top plan.
D. The statement will return an error because MANAGERS_PLAN is not the top plan.

相关考题

单项选择题 You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement:   SQL>EXEC DBMS_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);   A user, SCOTT, who is assigned to the MANAGERS group, starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete?()

单项选择题 Click the Exhibit(s) button to view the DEPARTMENTS plan.    After analyzing the Exhibit, what conclusion will you draw?()

单项选择题 You issued the following statement:   SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1;   Which parameter is NOT overridden by using the above statement?()

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

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064