nerdexam
Oracle

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.

Managing Data and Concurrency

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)
  • A
    81% (35)
  • B
    2% (1)
  • C
    5% (2)
  • E
    12% (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.

ACreate a file watcherCorrect

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.

BCreate a bulk loader watcher

"Bulk loader watcher" is not a standard or recognized component within Oracle Scheduler for monitoring file system events.

CCreate a light weight job for bulk insert

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.

DCreate an event-based job for bulk insertCorrect

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.

ECreate a job chain with a step for 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

#Oracle Scheduler#file watcher#event-based job#bulk insert

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice