Oracle Database 12c: Advanced Administration — Question 41

Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?

Answer options

• A. A job is specified as part of a program definition.
• B. A program can be used in the definition of multiple jobs.
• C. A program and job can be specified as part of a schedule definition.
• D. A program and schedule can be specified as part of a job definition.
• E. A program and window can be specified as part of a job definition.

Correct answer: B, C, D

Explanation

The correct answers B, C, and D highlight the flexibility and reusability of programs and schedules in the Oracle Job Scheduler. Specifically, a program can be linked to multiple jobs (B), a program and job can be included in a schedule (C), and a program can also be part of a job definition alongside a schedule (D). Option A is incorrect because it implies a job is only part of a program definition, which is not accurate, and option E incorrectly associates a window with a job definition without mentioning the job's relationship with programs.