1Z0-062 · Question #359
You want a job that performs a bulk insert as soon as the loader file arrives on the local file system. Which two would you do to accomplish this? (Choose two.)
The correct answer is A. Create a file watcher D. Create an event-based job for bulk insert. To automatically execute a bulk insert when a new loader file arrives, Oracle Scheduler allows combining a file watcher with an event-based job.
Question
You want a job that performs a bulk insert as soon as the loader file arrives on the local file system. Which two would you do to accomplish this? (Choose two.)
Options
- ACreate a file watcher
- BCreate a bulk loader watcher
- CCreate a light weight job for bulk insert
- DCreate an event-based job for bulk insert
- ECreate a job chain with a step for bulk insert
How the community answered
(43 responses)- A81% (35)
- B2% (1)
- C5% (2)
- E12% (5)
Why each option
To automatically execute a bulk insert when a new loader file arrives, Oracle Scheduler allows combining a file watcher with an event-based job.
Creating a file watcher configures the Oracle database to monitor a specified directory on the operating system for file arrival events, which are then published to the database scheduler.
"Bulk loader watcher" is not a standard or recognized component within Oracle Scheduler for monitoring file system events.
Creating a "light weight job for bulk insert" describes a job's characteristic but does not provide a mechanism for automatically triggering the job based on a file system event.
An event-based job in Oracle Scheduler can be configured to start automatically upon receiving a specific event, such as the file arrival event published by a file watcher, thereby triggering the bulk insert.
A job chain defines a sequence of job steps but does not, by itself, provide the functionality to detect a file's arrival and initiate the chain; it would still require an external trigger or scheduled start.
Concept tested: Oracle Scheduler event-based jobs with file watchers
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-oracle-scheduler.html#GUID-0CC9C22C-425B-4C90-8C84-638363F3F592
Topics
Community Discussion
No community discussion yet for this question.