You want to retain the job entries for the last five days and purge all job entries from the job log that are older than five days. Select the command that will enable you to do the job.
A.
EXECUTE DBMS_SCHEDULER.PURGE_LOG ( log_history => 5, which_log => ‘JOB_LOG’);
B.
EXECUTE DBMS_SCHEDULER.PURGE_LOG();
C.
EXECUTE DBMS_SCHEDULER.PURGE_LOG ( log_history => 5, job_name => ‘JOB_LOG’);
D.
EXECUTE DBMS_SCHEDULER.PURGE_LOG ( log_history => 5,which_log => ‘WINDOW_LOG’);
Explanation:
Purging Logs Manually
The PURGE_LOG procedure enables you to manually purge logs. As an example, the following statement purges all entries from both the job and window logs:
DBMS_SCHEDULER.PURGE_LOG();
Another example is the following, which purges all entries from the jog log that are older than three days. The window log is not affected by this statement.
DBMS_SCHEDULER.PURGE_LOG(log_history =>3, which_log => ‘JOB_LOG’); (A)
The following statement purges all window log entries older than 10 days and all job log entries older than 10 days that relate to job1 and to the jobs in class2:
DBMS_SCHEDULER.PURGE_LOG(log_history => 10, job_name => ‘job1, sys.class2’);REF: Oracle(r) 10g Administrator Guide , 28-14