nerdexam
Oracle

1Z0-034 · Question #128

Which statement is true about a Scheduler-generated event?

The correct answer is D. it requires jobs to be defined with an event condition and a queue specification. Consuming Job State Events with your Application To consume job state events, your application must subscribe to the Scheduler event queue SYS.SCHEDULER$_EVENT_QUEUE. This queue is a secure queue and is owned by SYS. To create a subscription to this queue for a user, do the…

Application Development Features

Question

Which statement is true about a Scheduler-generated event?

Options

  • AIt can be generated when a file arrives on the file system.
  • Bit indicates state changes that occur within the Scheduler itself.
  • Cit is raised by an application that is consumed by the Scheduler to start a job.
  • Dit requires jobs to be defined with an event condition and a queue specification.

How the community answered

(29 responses)
  • A
    3% (1)
  • B
    14% (4)
  • C
    7% (2)
  • D
    76% (22)

Explanation

Consuming Job State Events with your Application To consume job state events, your application must subscribe to the Scheduler event queue SYS.SCHEDULER$_EVENT_QUEUE. This queue is a secure queue and is owned by SYS. To create a subscription to this queue for a user, do the following: 1. Log in to the database as the SYS user or as a user with the MANAGE ANY QUEUE privilege. 2. Subscribe to the queue using a new or existing agent. 3. Run the package procedure DBMS_AQADM.ENABLE_DB_ACCESS as follows: DBMS_AQADM.ENABLE_DB_ACCESS(agent_name, db_username); where agent_name user for whom you want to create a subscription. There is no need to grant dequeue privileges to the user. The dequeue privilege is granted on the Scheduler event queue to PUBLIC.

Topics

#Oracle Scheduler#scheduler events#event-based jobs#state changes

Community Discussion

No community discussion yet for this question.

Full 1Z0-034 Practice