PostgreSQL_CE
PGCES-02 · Question #91
PGCES-02 Question #91: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #91. The question stem and answer options stay visible for context.
Question
Select an incorrect statement regarding the following SQL statement. Note that "user_view" is a view. CREATE OR REPLACE RULE rule_1 AS ON UPDATE TO user_view DO INSTEAD NOTHING;
Options
- AIt is defining a rule "rule_1".
- BIt will replace "rule_1" if it already exists.
- CExecuting 'UPDATE user_view' will no longer output errors.
- DWhen executing 'UPDATE user_view', data is updated in the table that is the origin of the view.
- E'DROP RULE rule_1 ON user_view' deletes the above definition.
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.