053试题 216/456/512/645 job chain

题目：

216.Which three elements can a job chain process involve? (Choose three)
A. an event
B. a schedule
C. a program
D. another chain
E. a lightweight job
 
参考答案 BDE （有争议）
解析
题目意思问，job chain包含那三个元素？
根据官方文档：说明选择ACD ？

参考文档：

https://docs.oracle.com/cd/E11882_01/server.112/e25494/schedover.htm#ADMIN12362

Chains

Chains are the means by which you can implement dependency scheduling, in which job starts depend on the outcomes of one or more previous jobs. A chain consists of multiple steps that are combined using dependency rules. The dependency rules define the conditions that can be used to start or stop a step or the chain itself. Conditions can include the success, failure, or completion- or exit-codes of previous steps. Logical expressions, such as AND/OR, can be used in the conditions. In a sense, a chain resembles a decision tree, with many possible paths for selecting which tasks run and when.

In its simplest form, a chain consists of two or more Scheduler program objects (programs) that are linked together for a single, combined objective. An example of a chain might be "run program A followed by program B, and then run program C only if programs A and B complete successfully, otherwise wait an hour and then run program D."

As an example, you might want to create a chain to combine the different programs necessary for a successful financial transaction, such as validating and approving a loan application, and then funding the loan.

A Scheduler job can point to a chain instead of pointing to a single program object. The job then serves to start the chain. This job is referred to as the chain job. Multiple chain jobs can point to the same chain, and more than one of these jobs can run simultaneously, thereby creating multiple instances of the same chain, each at a different point of progress in the chain.

Each position within a chain is referred to as a step. Typically, after an initial set of chain steps has started, the execution of successive steps depends on the completion of one or more previous steps. Each step can point to one of the following:

• A program object (program)

  The program can run a database program unit (such as a stored procedure or PL/SQL anonymous block) or an external executable.

• Another chain (a nested chain)

  Chains can be nested to any level.

• An event schedule, inline event, or file watcher

  After starting a step that points to an event schedule or that has an inline event specification, the step waits until the specified event is raised. Likewise, a step that references a file watcher inline or that points to an event schedule that references a file watcher waits until the file arrival event is raised. For a file arrival event or any other type of event, when the event occurs, the step completes, and steps that are dependent on the event step can run. A common example of an event in a chain is a user intervention, such an approval or rejection.

Multiple steps in the chain can invoke the same program or nested chain.

END

-- 2019-09-06 add

题目：

456.Which of the following is true about job chains?
A. They consist of one or more Scheduler programs.
B. They are used to implement dependency scheduling.
C. They are used to implement time-based scheduling.
D. They are used to implement event-based scheduling.
E. None of the above.
 
参考答案 B
chain是实现依赖关系调度的手段，其中作业启动取决于一个或多个先前作业的结果。选择B 。

参考文档，参考上面题目的文档。

end

-- 2019-09-08 add

题目：

512.Which two statements correctly describe the relationship among the Scheduler components: job, program, and schedule? (Choose two)
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
 
参考答案 A （有误，应该是BD ）
解析
job,program,schedule的关系。

参考文档：

https://docs.oracle.com/cd/E11882_01/server.112/e25494/schedover.htm#ADMIN12357

Programs

A program object (program) describes what is to be run by the Scheduler. A program includes:

• An action: For example, the name of a stored procedure, the name of an executable found in the operating system file system (an "external executable"), or the text of a PL/SQL anonymous block.

• A type: STORED_PROCEDURE, PLSQL_BLOCK, or EXTERNAL, where EXTERNAL indicates an external executable.

• Number of arguments: The number of arguments that the stored procedure or external executable accepts.

A program is a separate entity from a job. A job runs at a certain time or because a certain event occurred, and invokes a certain program. You can create jobs that point to existing program objects, which means that different jobs can use the same program and run the program at different times and with different settings. With the right privileges, different users can use the same program without having to redefine it. Therefore, you can create program libraries, where users can select from a list of existing programs.

If a stored procedure or external executable referenced by the program accepts arguments, you define these arguments in a separate step after creating the program. You can optionally define a default value for each argument.

Schedules

A schedule object (schedule) specifies when and how many times a job is run. Schedules can be shared by multiple jobs. For example, the end of a business quarter may be a common time frame for many jobs. Rather than defining an end-of-quarter schedule each time a new job is defined, job creators can point to a named schedule.

There are two types of schedules:

• time schedules

  With time schedules, you can schedule jobs to run immediately or at a later time. Time schedules include a start date and time, optional end date and time, and optional repeat interval.

• event schedules

  With event schedules, you can specify that a job executes when a certain event occurs, such as inventory falling below a threshold or a file arriving on a system. For more information on events, see "Using Events to Start Jobs".

END

-- 2019-09-11 add

题目：

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
参考答案 AC
解析
job chain可以包含一个nested chain . A 正确
job chain type可以基于事件或基于时间。 C正确。

参考文档，参考上面的题目的文档。

END