PostgreSQL Exam PGCES-02 Topic 4 Question 72 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 72
Topic #: 4

[All PGCES-02 Questions]

Select two suitable statements regarding the following SQL statement:

CREATE TRIGGER trigger_1 AFTER UPDATE ON sales FOR EACH ROW EXECUTE PROCEDURE write_log();

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.

Show Suggested Answer

Suggested Answer: C

by Shawnta at Sep 12, 2024, 09:07 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

16 hours ago

A and B are correct. The trigger is defined to execute the 'write_log' function after an update on the 'sales' table.

upvoted 0 times

...

14 days ago

I'm not sure about statement C, I think the function is called after the update.

upvoted 0 times

...

20 days ago

I agree with Gwen, the trigger is defined and the function is called after each update.

upvoted 0 times

...

25 days ago

I think statement A and B are correct.

upvoted 0 times

...