PostgreSQL Exam PGCES-02 Topic 10 Question 88 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 88
Topic #: 10

The following SQL defines an INSERT with respect to item_view. Select the keyword that is applicable in the underlined blank. CREATE _______ foo AS ON INSERT TO item_view DO INSTEAD INSERT INTO item_table VALUES (NEW.id, NEW.itemname);

ARULE

BVIEW

CTRIGGER

DFUNCTION

ECONSTRAINT

Show Suggested Answer

Suggested Answer: A

by Carlton at Jul 14, 2025, 02:25 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Diane

1 days ago

I'm not sure, but I think it could also be A) RULE.

upvoted 0 times

...

Luisa

3 days ago

I think the correct answer is C) TRIGGER. This SQL statement seems to be creating a trigger that inserts data into the item_table when a new row is inserted into the item_view.

upvoted 0 times

...

Val

4 days ago

I agree with Nina, it makes sense to use a trigger in this context.

upvoted 0 times

...

Nina

6 days ago

I think the keyword is C) TRIGGER.

upvoted 0 times

...