You wish to create jobs to satisfy these requirements: 1. Automatically bulk load data from a flat file. 2. Rebuild indexes on the SALES table after completion of the bulk load. How would you create…

The correct answer is C. Create one job to rebuild indexes using application raised events and another job to perform bulk. The bulk loader would be started in response to a file watcher scheduler event and the indexes would be rebuilt in response to an application event raised by the bulk loader. https://docs.oracle.com/cd/E18283_01/server.112/e17120/scheduse005.htm#CIABIEJA Your application can…

New Features for Manageability

Question

You wish to create jobs to satisfy these requirements: 1. Automatically bulk load data from a flat file. 2. Rebuild indexes on the SALES table after completion of the bulk load. How would you create these jobs?

Options

ACreate both jobs by using Scheduler raised events.
BCreate both jobs using application raised events.
CCreate one job to rebuild indexes using application raised events and another job to perform bulk
DCreate one job to rebuild indexes using Scheduler raised events and another job to perform bulk

How the community answered

(18 responses)

A
6% (1)
B
11% (2)
C
78% (14)
D
6% (1)

Explanation

The bulk loader would be started in response to a file watcher scheduler event and the indexes would be rebuilt in response to an application event raised by the bulk loader. https://docs.oracle.com/cd/E18283_01/server.112/e17120/scheduse005.htm#CIABIEJA Your application can raise an event to notify the Scheduler to start a job. A job started in this way is referred to as an event-based job. The job can optionally retrieve the message content of the https://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse008.htm#CHDIAJEB

Topics

#Oracle Scheduler#scheduler events#application raised events#job dependencies

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice