Oracle Database 12c: Advanced Administration — Question 94

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?

Answer options

• A. Create both jobs by using Scheduler raised events.
• B. Create both jobs using application raised events.
• C. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
• D. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.

Correct answer: A

Explanation

The correct answer is A because using Scheduler raised events allows for the bulk load job and the index rebuild job to be coordinated effectively as per the requirements. Options B, C, and D incorrectly mix the event types or fail to utilize the Scheduler effectively for both tasks, which is crucial for managing job execution in this context.