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

Tatum

2 days ago

I think option C is the incorrect statement. Executing 'UPDATE user_view' will still output errors if the update operation is not permitted on the underlying table.

upvoted 0 times

...

Cyndy

4 days ago

Option D is incorrect. When 'UPDATE user_view' is executed, the data is not updated in the table that is the origin of the view. The update is instead suppressed by the INSTEAD NOTHING rule.

upvoted 0 times

...