nerdexam
Oracle

1Z0-062 · Question #1

Which three statements are true about a job chain?

The correct answer is A. It can contain a nested chain of jobs. B. It can be used to implement dependency-based scheduling. E. It can be executed using event-based or time-based schedules. Oracle Scheduler job chains support nested chains, dependency-based scheduling, and both event-based and time-based execution triggers.

Performing Database Maintenance

Question

Which three statements are true about a job chain?

Options

  • AIt can contain a nested chain of jobs.
  • 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 or time-based schedules.

How the community answered

(32 responses)
  • A
    91% (29)
  • C
    6% (2)
  • D
    3% (1)

Why each option

Oracle Scheduler job chains support nested chains, dependency-based scheduling, and both event-based and time-based execution triggers.

AIt can contain a nested chain of jobs.Correct

A job chain can reference another chain as a step, allowing nested chains to model complex workflows with sub-dependencies.

BIt can be used to implement dependency-based scheduling.Correct

Job chains are specifically designed to link steps with conditional logic and dependencies, so one step only runs after a prior step completes with a defined outcome.

CIt cannot invoke the same program or nested chain in multiple steps in the chain.

Oracle Scheduler does allow the same program or nested chain to appear in multiple steps within a single chain, so this restriction does not exist.

DIt cannot have more than one dependency.

A job chain step can have multiple dependencies on other steps using AND or OR conditions, so the one-dependency limit is incorrect.

EIt can be executed using event-based or time-based schedules.Correct

A job chain can be attached to a schedule or event so it fires either at a scheduled time or in response to a system or user-defined event.

Concept tested: Oracle Scheduler job chain capabilities and scheduling

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/oracle-scheduler-concepts.html#GUID-F8EBC834-3F59-4DA2-BD6C-FA61F290CB8A

Topics

#Job scheduler#Job chains#Dependency-based scheduling#Event-based schedules

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice