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

250.You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk

load operation.

The bulk load operation must also be a scheduled job that executes as soon as the first file that contains

data arrives on the system.

How would you create these jobs?

A. Create both jobs by using events raised by the scheduler

B. Create both jobs by using events raised by the application

C. Create a job to rebuild indexes by using events arised by the application and then create another job to

perform bulk load by using events raised by the scheduler

D. Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to

perform bulk load by using events raised by the application

Answer: D

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm#ADMIN12361

从以下可知，bulk load是File arrival events raised by a file watcher，rebuild indexes是Events raised by your application，An application can raise an event to be consumed by the Scheduler.

两个都是基于事件的。

About Events

An event is a message sent by one application or system process to another to indicate that some action or occurrence has been detected. An event israised (sent) by one application or process, and consumed (received) by one or more applications or processes.

There are two kinds of events consumed by the Scheduler:

• Events raised by your application

  An application can raise an event to be consumed by the Scheduler. The Scheduler reacts to the event by starting a job. For example, when an inventory tracking system notices that the inventory has gone below a certain threshold, it can raise an event that starts an inventory replenishment job.

  See "Starting Jobs with Events Raised by Your Application".

• File arrival events raised by a file watcher

  You can create a file watcher—a Scheduler object introduced in Oracle Database 11g Release 2—to watch for the arrival of a file on a system. You can then configure a job to start when the file watcher detects the presence of the file. For example, a data warehouse for a chain of stores loads data from end-of-day revenue reports uploaded from the point-of-sale systems in the stores. The data warehouse load job starts each time a new end-of-day report arrives.

  See "Starting a Job When a File Arrives on a System"