PostgreSQL Exam PGCES-02 Topic 10 Question 76 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 76
Topic #: 10

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;

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.

Show Suggested Answer

Suggested Answer: B

by Edward at Oct 19, 2024, 03:08 PM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Juliann

3 hours ago

I think the correct answer is C.

upvoted 0 times

...