Examine the trigger heading:
CREATE OR REPLACE TRIGGER salary_check
BEFORE UPDATE OF sal, job ON emp
FOR EACH ROW
Under which condition does this trigger fire?
A.
When a row is inserted into the EMP table.
B.
When the value of the SAL or JOB column in a row is updated in the EMP table.
C.
When any column other than the SAL and JOB columns in a row are updated in the EMP table.
D.
Only when both values of the SAL and JOB columns in a row are updated together in the EMP
table.
Explanation:
The triggering event is based on an UPDATE of the SAL or the JOB column in the EMP Table.
Incorrect Answers:
A: The triggering event is not an INSERT into the table.
C: The Trigger is defined to fire when either the SAL or JOB columns are updated. The trigger will
not fire if any of the other columns in the table are updated.
D: The Trigger fires based on an Update of the SAL OR JOB Column . This is not an AND
Operator.