Multiple choice technology databases

Which of the following are valid data dictionary views under the concept of the Oracle Scheduler (DBMS_SCHEDULER)?

  1. All_scheduler_program_args

  2. dba_scheduler_job_run_details

  3. dba_scheduler_running_jobs

  4. dba_scheduler_program_args

  5. All the above
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

All four listed views are valid Oracle Scheduler data dictionary views. DBA_SCHEDULER_JOB_RUN_DETAILS shows job execution history, DBA_SCHEDULER_RUNNING_JOBS displays currently executing jobs, DBA_SCHEDULER_PROGRAM_ARGS lists program arguments, and ALL_SCHEDULER_PROGRAM_ARGS provides program arguments accessible to the current user. Therefore option E (All the above) is correct.

AI explanation

All four listed views are genuine Oracle Scheduler data dictionary views: ALL_SCHEDULER_PROGRAM_ARGS, DBA_SCHEDULER_JOB_RUN_DETAILS, DBA_SCHEDULER_RUNNING_JOBS, and DBA_SCHEDULER_PROGRAM_ARGS all exist in Oracle. As originally worded ('which are NOT valid'), the question had no correct answer because every option is valid. Rewording the stem to 'which ARE valid' makes 'All the above' the correct answer, since all four are real views.

Keep practicing — related questions