单项选择题

You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task？（）

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’）；

点击查看答案&解析

上一题目录下一题

相关考题

单项选择题

Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（）

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.

单项选择题

William is creating a job class. William specifies the LOGGING_FULL setting for the LOGGING_LEVEL attribute at the time of job class creation. What is the impact of using this setting？（）

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.