PostgreSQL_CE
PGCES-02 · Question #12
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…
The correct answer is A. RULE. See the full explanation below for the reasoning.
Question
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);
Options
- ARULE
- BVIEW
- CTRIGGER
- DFUNCTION
- ECONSTRAINT
How the community answered
(23 responses)- A74% (17)
- C13% (3)
- D4% (1)
- E9% (2)
Community Discussion
No community discussion yet for this question.