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

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Shawna

14 days ago

I wonder if the 'write_log' function is as exciting as it sounds. Maybe it just writes 'Another day, another sale' in the log.

upvoted 0 times

...

Truman

15 days ago

E is correct. The given statement would delete the defined trigger.

upvoted 0 times

...

Carli

16 days ago

D is incorrect. The 'write_log' function is called regardless of its return value.

upvoted 0 times

...

Reita

17 days ago

C is incorrect. The trigger is defined to execute the function after the update, not before.

upvoted 0 times

Carlee

1 days ago

A) It is defining a trigger 'trigger_1'.

upvoted 0 times

...

Avery

3 days ago

A) It is defining a trigger 'trigger_1'.

upvoted 0 times

...

2 months ago

I think statement A and B are correct.

upvoted 0 times

...