PostgreSQL_CE
PGCES-02 · Question #91
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;
The correct answer is D. When executing 'UPDATE user_view', data is updated in the table that is the origin of the view. See the full explanation below for the reasoning.
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.
How the community answered
(28 responses)- A4% (1)
- B14% (4)
- C7% (2)
- D71% (20)
- E4% (1)
Community Discussion
No community discussion yet for this question.