1Z0-062 · Question #372
Which three statements are true about a job chain? (Choose three.)
The correct answer is B. It can be used to implement dependency-based scheduling. E. It can be executed using event-based schedules. F. It can be executed using time-based schedules. Oracle job chains are a powerful scheduling feature that supports dependency-based execution and can be initiated by both time-based and event-based schedules.
Question
Which three statements are true about a job chain? (Choose three.)
Options
- AThe DBA role is required to create a job chain.
- BIt can be used to implement dependency-based scheduling.
- CIt cannot invoke the same program or nested chain in multiple steps in the chain.
- DIt cannot have more than one dependency.
- EIt can be executed using event-based schedules.
- FIt can be executed using time-based schedules.
How the community answered
(40 responses)- B93% (37)
- C3% (1)
- D5% (2)
Why each option
Oracle job chains are a powerful scheduling feature that supports dependency-based execution and can be initiated by both time-based and event-based schedules.
The `CREATE JOB` privilege is typically sufficient to create a job chain, not necessarily the full DBA role.
Job chains are specifically designed to allow steps to execute based on the completion or outcome of preceding steps, enabling complex dependency-based workflows.
A job chain can invoke the same program or nested chain multiple times in different steps, allowing for reuse and complex logical flows.
A job chain step can have multiple dependencies, meaning it can wait for several preceding steps to complete before it starts execution.
Job chains can be started by an event schedule, meaning they can be triggered when a specific event occurs, such as a file arriving or a message being queued.
Job chains can be started by a time schedule, allowing them to run at specific times or intervals, similar to traditional cron jobs.
Concept tested: Oracle Scheduler Job Chains
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-jobs-with-oracle-scheduler.html#GUID-E53406CE-67F7-4E64-A85A-617637EC44F0
Topics
Community Discussion
No community discussion yet for this question.