Examine the code examples. Which one is correct?
A.
CREATE OR REPLACE TRIGGER authorize_action
BEFORE INSERT ON EMPLOYEES
CALL log_exectution;
/
B.
CREATE OR REPLACE TRIGGER authorize_action
BEFORE EMPLOYEES INSERT
CALL log_exectution;
C.
CREATE OR REPLACE TRIGGER authorize_action
BEFORE EMPLOYEES INSERT
CALL log_exectution;
D.
CREATE OR REPLACE TRIGGER authorize_action
CALL log_exectution; BEFORE INSERT ON EMPLOYEES;
/
Explanation:
Answer A is the correct syntax for creating a Trigger and calling a procedure Incorrect answers:
Answer B is incorrect. This is incorrect syntax for creating a Trigger Answers C and D are incorrect syntax and will result in an error
A similar question:
Which one is correct?
A.
CREATE OR REPLACE TRIGGER authorize_action
BEFORE INSERT ON EMPLOYEES
CALL log_execution;
/
B.
CREATE OR REPLACE TRIGGER authorize_action
BEFORE INSERT ON EMPLOYEES
CALL log_execution
/
C.
CREATE OR REPLACE TRIGGER authorize_action
BEFORE EMPLOYEES INSERT
CALL log_execution;
D.
CREATE OR REPLACE TRIGGER authorize_action
CALL log_execution BEFORE INSERT ON EMPLOYE
/
Answer: B