PostgreSQL PGCES-02 Exam - 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

Tammy

2 months ago

I thought it was a FUNCTION at first, but TRIGGER makes more sense.

upvoted 0 times

...

Enola

2 months ago

I agree, TRIGGER is the right choice here.

upvoted 0 times

...

Blythe

2 months ago

I think it's a RULE, but I'm not sure.

upvoted 0 times

...

Hobert

3 months ago

Wait, can you really use INSTEAD with a VIEW?

upvoted 0 times

...

Juliann

3 months ago

Definitely a TRIGGER! That's how it works.

upvoted 0 times

...

Stephaine

3 months ago

I’m confused; I thought FUNCTIONS were more about returning values, not handling INSERTs directly.

upvoted 0 times

...

Lashonda

3 months ago

I’m leaning towards VIEW, but I recall that INSERT operations usually relate more to TRIGGERS.

upvoted 0 times

...

Bettye

4 months ago

I remember something about RULES and how they can be used for rewriting queries, but this feels different.

upvoted 0 times

...

Elenor

4 months ago

I think the answer might be TRIGGER, but I'm not entirely sure. We did practice some similar questions in class.

upvoted 0 times

...

Malinda

4 months ago

This is a good SQL question that tests our understanding of database triggers. Based on the code provided, I think the correct answer is TRIGGER. The keyword we're looking for is the one used to define the trigger that intercepts the INSERT to item_view and performs a different INSERT into item_table.

upvoted 0 times

...

Cassie

4 months ago

I'm a little confused by this question. The code mentions an INSERT, but it's not clear if that's the keyword we're supposed to select. I'll have to review the SQL syntax for triggers and see if that's the right approach here.

upvoted 0 times

...

Paz

4 months ago

Okay, I've read through the question a few times now. I'm pretty confident the answer is TRIGGER. The code is defining a trigger that runs on an INSERT to item_view and does an INSERT into item_table instead. The keyword we're looking for is TRIGGER.

upvoted 0 times

...

Sunny

4 months ago

Hmm, I'm a bit unsure about this one. The code mentions an INSERT, but it's not clear if the trigger is being created for the INSERT or if it's doing an INSERT as part of its logic. I'll have to think this through carefully.

upvoted 0 times

...

Luz

5 months ago

This looks like a SQL question about database triggers. I think the keyword we're looking for is TRIGGER, since the code is defining a trigger that runs on an INSERT to the item_view table.

upvoted 0 times

...

Floyd

6 months ago

Ah, the age-old question - TRIGGER or not TRIGGER, that is the SQL query. I'm voting C, because anything else would be a major SQL sin. Though I do like the 'CONSTRAINT' idea - maybe we can make it a 'Don't mess with item_view or else' kind of thing.

upvoted 0 times

Zita

5 months ago

I prefer using a RULE in this case. It gives more flexibility in handling the INSERT operation.

upvoted 0 times

...

Nada

5 months ago

I think a CONSTRAINT could also work well in this scenario. It adds an extra layer of protection.

upvoted 0 times

...

Corinne

5 months ago

I agree, TRIGGER is the way to go. It ensures data integrity.

upvoted 0 times

...

Craig

7 months ago

Wait, is this a trick question? What if the answer is E) CONSTRAINT? You know, like a 'Don't even think about inserting anything into item_view without me handling it first' kind of thing. Just kidding, it's totally a TRIGGER.

upvoted 0 times

...

Howard

7 months ago

This is clearly a TRIGGER. What else could it be? A view? A function? That doesn't make any sense. Triggers are the way to handle this kind of insert operation.

upvoted 0 times

Latonia

5 months ago

B) VIEW

upvoted 0 times

...

Valentin

6 months ago

A) RULE

upvoted 0 times

...

Royal

7 months ago

I believe it's C) TRIGGER because it specifies an action to be taken when a certain event occurs.

upvoted 0 times

...

Audry

7 months ago

The answer has to be C) TRIGGER. I can't imagine any other keyword that would work in that blank. Triggers are the way to go for this kind of functionality.

upvoted 0 times

Tasia

6 months ago

Using a trigger in this case makes the most sense.

upvoted 0 times

...

Bulah

7 months ago

Triggers are definitely the right choice for this scenario.

upvoted 0 times

...

Brandon

7 months ago

I agree, the keyword should be C) TRIGGER.

upvoted 0 times

...

Leota

7 months ago

It's definitely a TRIGGER. The code is setting up an action to happen when a new row is inserted into the item_view table.

upvoted 0 times

Hobert

7 months ago

Yes, a TRIGGER makes sense here. It allows you to react to changes in the database, like when a new row is inserted.

upvoted 0 times

...

Cristy

7 months ago

I think it's a TRIGGER too. It's used to specify a set of actions to be taken when a certain event occurs on a specified table.

upvoted 0 times

...

Diane

7 months ago

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

upvoted 0 times

...

Luisa

7 months 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