Multiple choice

What will the command EXECUTE DBMS_SCHEDULER.PURGE_LOG(); do?

  1. Purge only the window logs.

  2. Purge only the job logs.

  3. Purge all window and job logs.

  4. Purge only yesterday's job logs.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DBMS_SCHEDULER.PURGE_LOG() purges both window logs and job logs from the scheduler. It doesn't selectively purge only one type or only yesterday's logs. The command cleans up all accumulated logs to manage disk space.

Keep practicing — related questions