OCP-1Z0-053-V13.02-645题

645.Which two statements are true about a job chain? (Choose two.)

A. A job chain can contain a nested chain of jobs.

B. The jobs in a job chain cannot have more than one dependency.

C. A job of the CHAIN type can be run using event-based or time-based schedules.

D. The jobs in a job chain can be executed only by using the events generated by the Scheduler

Answer: AC

答案解析：

Defining Chain Steps

After creating a chain object, you define one or more chain steps. Each step can point to one of the following:

• A Scheduler program object (program)

• Another chain (a nested chain)

• An event schedule, inline event, or file watcher

You define a step that points to a program or nested chain by using the DEFINE_CHAIN_STEP procedure. An example is the following, which adds two steps tomy_chain1:

BEGIN

  DBMS_SCHEDULER.DEFINE_CHAIN_STEP (

   chain_name      =>  'my_chain1',

   step_name       =>  'my_step1',

   program_name    =>  'my_program1');

  DBMS_SCHEDULER.DEFINE_CHAIN_STEP (

   chain_name      =>  'my_chain1',

   step_name       =>  'my_step2',

   program_name    =>  'my_chain2');

END;

/

参考： http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sched.htm#ARPLS72960

job_type

Job action type ('PLSQL_BLOCK', 'STORED_PROCEDURE', 'EXECUTABLE', or 'CHAIN')

 

repeat_interval

Inline time-based schedule

event_condition

Event condition for event-based jobs