Upgrade Oracle DBA 11g to Oracle Database 12c — Question 10

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: D

Explanation

The correct answer is D because it effectively separates the tasks by utilizing Scheduler raised events for the index rebuild, ensuring it occurs after the bulk load, which is managed by application raised events. Options A and B incorrectly suggest using the same event type for both jobs, while option C misplaces the event types for the tasks.