nerdexam
Oracle

1Z0-147 · Question #19

Examine the code examples. Which one is correct?

The correct answer is B. CREATE OR REPLACE TRIGGER authorize_action BEFORE INSERT ON EMPLOYEES CALL log_execution. See the full explanation below for the reasoning.

Question

Examine the code examples. Which one is correct?

Options

  • ACREATE OR REPLACE TRIGGER authorize_action BEFORE INSERT ON EMPLOYEES CALL log_execution; /
  • BCREATE OR REPLACE TRIGGER authorize_action BEFORE INSERT ON EMPLOYEES CALL log_execution;
  • CCREATE OR REPLACE TRIGGER authorize_action BEFORE EMPLOYEES INSERT CALL log_execution;
  • DCREATE OR REPLACE TRIGGER authorize_action CALL log_execution BEFORE INSERT ON EMPLOYEES; /

How the community answered

(34 responses)
  • A
    3% (1)
  • B
    74% (25)
  • C
    9% (3)
  • D
    15% (5)

Community Discussion

No community discussion yet for this question.

Full 1Z0-147 Practice