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

Glenn

2 days ago

Option B seems to be the correct answer. The 'CREATE OR REPLACE RULE' statement will replace the existing 'rule_1' if it already exists.

upvoted 0 times

...

Felicia

8 days ago

Wow, this question is really testing our SQL knowledge! I guess the developers who wrote this exam are trying to keep us on our toes. *chuckles*

upvoted 0 times

...

Tatum

11 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

13 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

...