单选题You executed the following code：   BEGIN   DBMS_SCHEDULER.SET_ATTRIBUTE  （  NAME => ’JOB_A’，   ATTRIBUTE => ’JOB_PRIORITY’，   VALUE => 7）；   END；  /   After analyzing the above code， what conclusion will you draw？（）AThe code will be executed successful

第1题：

Consider the following code snippet：   BEGIN  DBMS_SCHEDULER.SET_ATTRIBUTE （ name => ，，lne_job1， attribute => ，，job_priority， value => 1）；  END；  /   If this code were executed， which of the following statements would be true？（）

• A、 The priority of the lne_job1 job would be set to 1.
• B、 The lne_job1 job would be executed synchronously.
• C、 The lne_job1 job would run immediately in the users current session.
• D、 The lne_job1 job would retain its current priority.
• E、 The job will immediately take priority over all running jobs.

第2题：

You executed the following code：   BEGIN   DBMS_SCHEDULER.SET_ATTRIBUTE  （  NAME => ’JOB_A’，   ATTRIBUTE => ’JOB_PRIORITY’，   VALUE => 7）；   END；  /   After analyzing the above code， what conclusion will you draw？（）  

• A、 The code will be executed successfully.
• B、 The code will not be executed successfully because the value of the VALUE parameter must be 1， 2， or 3.
• C、 The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
• D、 The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.

第3题：

第4题：

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.

第5题：

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.

第6题：

Where can you add your own PL/SQL code in relation-handling triggers?（）

• A、Before the "End default relation program section" comment. 
• B、After the "Begin default relation program section" comment. 
• C、Before the "Begin default relation program section" comment. 
• D、It is not possible to modify the relation-handling code that Forms automatically creates for relations.

第7题：

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.

第8题：

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

第9题：

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.

第10题：

You work as an application developer at Certkiller .com. You have recently created an application domain for Certkiller .com. A few weeks later you are asked to retrieve information from this application domain， which is the current application domain. What can you do to achieve this objective？（）

• A、 Use the following code： AppDomain appInfo = ApplicationDomain.Current；
• B、 Use the following code： AppDomain appInfo = AppDomain.CurrentDomain （）；
• C、 Use the following code： AppDomain appInfo = Thread.GetDomain （）；
• D、 Use the following code： AppDomain appInfo = MainThread.GetDomain （）；