MENU
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);
Suggested Answer: A
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
36 comments · newest first
TA
Tammy
10 months ago
I thought it was a FUNCTION at first, but TRIGGER makes more sense.
EN
Enola
10 months ago
I agree, TRIGGER is the right choice here.
BL
Blythe
10 months ago
I think it's a RULE, but I'm not sure.
HO
Hobert
10 months ago
Wait, can you really use INSTEAD with a VIEW?
JU
Juliann
10 months ago
Definitely a TRIGGER! That's how it works.
ST
Stephaine
11 months ago
I’m confused; I thought FUNCTIONS were more about returning values, not handling INSERTs directly.
LA
Lashonda
11 months ago
I’m leaning towards VIEW, but I recall that INSERT operations usually relate more to TRIGGERS.
BE
Bettye
11 months ago
I remember something about RULES and how they can be used for rewriting queries, but this feels different.
EL
Elenor
11 months ago
I think the answer might be TRIGGER, but I'm not entirely sure. We did practice some similar questions in class.
MA
Malinda
11 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.
CA
Cassie
12 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.
PA
Paz
12 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.
SU
Sunny
12 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.
LU
Luz
1 year 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.
FL
Floyd
1 year 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.
ZI
Zita
1 year ago
I prefer using a RULE in this case. It gives more flexibility in handling the INSERT operation.
NA
Nada
1 year ago
I think a CONSTRAINT could also work well in this scenario. It adds an extra layer of protection.
CO
Corinne
1 year ago
I agree, TRIGGER is the way to go. It ensures data integrity.
CR
Craig
1 year 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.
HO
Howard
1 year 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.
LA
Latonia
1 year ago
B) VIEW
VA
Valentin
1 year ago
A) RULE
RO
Royal
1 year ago
I believe it's C) TRIGGER because it specifies an action to be taken when a certain event occurs.
AU
Audry
1 year 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.
TA
Tasia
1 year ago
Using a trigger in this case makes the most sense.
BU
Bulah
1 year ago
Triggers are definitely the right choice for this scenario.
BR
Brandon
1 year ago
I agree, the keyword should be C) TRIGGER.
LE
Leota
1 year 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.
HO
Hobert
1 year ago
Yes, a TRIGGER makes sense here. It allows you to react to changes in the database, like when a new row is inserted.
CR
Cristy
1 year 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.
DI
Diane
1 year ago
I'm not sure, but I think it could also be A) RULE.
LU
Luisa
1 year 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.
DE
Dewitt
1 year ago
Yes, a trigger makes sense in this context.
AL
Alesia
1 year ago
I agree, it should be C) TRIGGER.
VA
Val
1 year ago
I agree with Nina, it makes sense to use a trigger in this context.
NI
Nina
1 year ago
I think the keyword is C) TRIGGER.