单选题You issued the following block of code：        SQL>BEGIN   DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（        ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）；        END；        SQL>/   Which option is NOT a result of executing the above code？（）AThe swi

第1题：

You accepted the recommended SQL Profile by executing the following code：   DECLARE   sqlprofile_name varchar2（30）；  BEGIN   sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（  task_name => ’my_task’，   profile_name => ’my_profile’）；   END；   Which advisor will analyze this profile？（）  

• A、 SQL Access Advisor
• B、 Undo Advisor
• C、 Segment Advisor
• D、 SQL Tuning Advisor

第2题：

You execute the following block of code：   SQL>BEGIN   DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN   （ SIMPLE_PLAN => ’DEPARTMENTS’，   CONSUMER_GROUP1 => ’PAYROLLL’，   GROUP1_CPU => 50，   CONSUMER_GROUP2 => ’SALES’，   GROUP2_CPU => 25，   CONSUMER_GROUP3 => ’MARKETING’，   GROUP3_CPU => 25）；   END；   SQL>/   What is a prerequisite for using the simple resource plan created by executing the above code？（）

• A、 You must assign users to consumer groups.
• B、 You must grant the switch privilege to the users.
• C、 You must create a resource plan directive.
• D、 You must specify the complex resource plan.

第3题：

You created the ORDERS table in your database by using the following code：   SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；   Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；   SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；   SQL> COMMIT；   Next， you issued the following statement to change the time zone for the database：   SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；   What will be the result of executing the above statement？（）  

• A、 The statement will fail.
• B、 The statement will be executed successfully， and the new time zone will be set for the database.
• C、 The statement will be executed successfully， but the new time zone will be set for the current session.
• D、The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.

第4题：

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？（）  

• A、 The switch privilege will be granted to the user， Scott， for changing the consumer group to GRP1.
• B、 The switch privilege will be granted to the user， Scott， for changing the consumer group from GRP1 to any other group.
• C、 The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.
• D、The code will execute successfully but no privilege will be granted to the user， Scott.

第5题：

You issued the following block of code：        SQL>BEGIN   DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（        ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）；        END；        SQL>/   Which option is NOT a result of executing the above code？（）  

• A、 The switch privilege is granted to the PROG_ROLE role.
• B、 The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.
• C、 The users cannot grant the switch privilege to other users.
• D、 The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade，you observe that the DBA executes the following script：   SQL> @utlrp.sql   What is the significance of executing this script？（）  

• A、 It performs parallel recompilation of only the stored PL/SQL code.
• B、 It performs sequential recompilation of only the stored PL/SQL code.
• C、 It performs parallel recompilation of any stored PL/SQL as well as Java code.
• D、 It performs sequential recompilation of any stored PL/SQL as well as Java code.

第14题：

Evaluate the following code：   SQL>VARIABLE task_name VARCHAR2（255）； SQL>VARIABLE sql_stmt VARCHAR2（4000）； SQL>BEGIN ：sql_stmt ：= ’SELECT COUNT（*） FROM customers  WHERE cust_state_province =’’CA’’’； ：task_name ：= ’MY_QUICKTUNE_TASK’；  DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR，  ：task_name， ：sql_stmt）；  END；   What is the outcome of this block of code？（）  

• A、 It creates a task and workload， and executes the task.
• B、 It creates a task and workload but does not execute the task.
• C、 It produces an error because a template has not been created.
• D、 It produces an error because the SQL Tuning Set has not been created.

第15题：

You have created a resource plan， DAY. You execute the following code：        SQL> BEGIN        DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE   （ PLAN => ’DAY’，        COMMENT => ’DEPARTMENTS PLAN’，   GROUP_OR_SUBPLAN => ’DEPARTMENTS’，        CPU_P1=0）；        END；   Then， you issue the following code：        SQL> BEGIN   DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE        （ PLAN => ’DAY’，        COMMENT => ’DEPARTMENTS PLAN’，        GROUP_OR_SUBPLAN => ’DEVELOPERS’，        CPU_P2=100）；        END；   What will be the impact of executing the above code？（）  

• A、 The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.
• B、 The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.
• C、 The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.
• D、 The second code will not execute because one resource plan cannot be used by more than one subplan.

第16题：

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script: SQL> @utlrp.sql What is the significance of executing this script?（）

• A、It performs parallel recompilation of only the stored PL/SQL code.
• B、It performs sequential recompilation of only the stored PL/SQL code.
• C、It performs parallel recompilation of any stored PL/SQL as well as Java code.
• D、It performs sequential recompilation of any stored PL/SQL as well as Java code.

第17题：

You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）  

• A、 The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.
• B、 The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.
• C、 The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
• D、 The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：