PGCES-02 practice question 3 of 10

Select two suitable statements regarding the following SQL statement: CREATE TRIGGER trigger_1 AFTER UPDATE ON sales FOR EACH ROW EXECUTE PROCEDURE write_log();

Full set: 142 questions
Answer options
A: It is defining a trigger "trigger_1".
B: Every time 'UPDATE' is executed on the "sales" table, the "write_log" function is called once.
C: The "write_log" function is called before 'UPDATE' takes place.
D: 'UPDATE' is not executed if "write_log" returns NULL.
E: 'DROP TRIGGER trigger_1 ON sales;' deletes the defined trigger.
Correct Answer:
Scroll to Top