PostgreSQL_CE
PGCES-02 · Question #74
PGCES-02 Question #74: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #74. The question stem and answer options stay visible for context.
Question
Select two suitable statements regarding the following SQL statement: CREATE TRIGGER trigger_1 AFTER UPDATE ON sales FOR EACH ROW EXECUTE PROCEDURE write_log();
Options
- AIt is defining a trigger "trigger_1".
- BEvery time 'UPDATE' is executed on the "sales" table, the "write_log" function is called once.
- CThe "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.
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.