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;
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.
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.
Glenn
1 months agoFelicia
2 months agoKatie
27 days agoLenna
1 months agoTatum
2 months agoCyndy
2 months agoJuliann
2 months agoVal
2 months agoJuliann
2 months ago