Upgrade Oracle DBA 11g to Oracle Database 12c — Question 36

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

Option B is correct because a program can indeed be referenced in the definitions of multiple jobs, allowing for reusability. Option C is also accurate as both programs and jobs can be included in a schedule. Option D is correct since a program and a schedule can be part of a job definition, while option A and E are incorrect, as they do not reflect the valid relationships defined in the Oracle Job Scheduler.