You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）

单项选择题Youwanttopurgejobentriesolderthan5daysfromthejoblog.Youdonotwanttopurgewindowlogentries.Whichcommandwillyouusetoaccomplishthistask？（）

A. EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history => 5， job_name => ’JOB1’）；
B. EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， job_name => ’JOB_LOG’）；
C. EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log => ’JOB1’）；
D. EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log =>’JOB_LOG’）；

单项选择题Yoursystemperformsheavytransactionprocessingbetween8：00A.M.and5：00P.M.butrunsbatchprocessingandreportsafterthat.Youdecidetocreateaseparateresourceplantogovernresourceallocationforeachtimeperiod.Whichschedulerobjectwillyouusetoswitchautomaticallybetweenthetworesourceplans？（）

A. Window
B. Program
C. Job_Class
D. Window group

单项选择题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.

单项选择题Williamiscreatingajobclass.WilliamspecifiestheLOGGING_FULLsettingfortheLOGGING_LEVELattributeatthetimeofjobclasscreation.Whatistheimpactofusingthissetting？（）

A. Detailed information regarding the first run of each job in the class will be written in the job log， and every operation performed on the job class will be logged.
B. Detailed information regarding each run of only the first job in the class will be written in the job log， and every operation performed on the job class will be logged.
C. Detailed information regarding each run of each job in the class will be written in the job log， and every operation  performed on the job class will be logged.
D. Detailed information regarding each run of each job in the class will be written in the job log， but operations performed on the job class will not be logged.

单项选择题You are creating a job class. You have issued the following command to create the job class：  SQL> BEGIN   DBMS_SCHEDULER.CREATE_JOB_CLASS（        JOB_CLASS_NAME => ’LOW_PRIORITY_CLASS’，        RESOURCE_CONSUMER_GROUP => ’LOW_GROUP’，        LOGGING_LEVEL => DBMS_SCHEDULER.LOGGING_FULL，        LOG_HISTORY => 1200，   COMMENTS => ’LOW JOB PRIORITY CLASS’）；        END；        SQL>     What will be the result of the above command？（）

A. The command will be executed successfully.
B. The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
C. The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
D. The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
E. The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.