The ____ constraint ensures that any DML operations performed on the view (e.g. ,adding rows,changing data)will not prevent the row from being accessed by the view because it no longer meets the condition in the WHERE clause.
A) ON UPDATE CHECK
B) WITH CHECK OPTION
C) WITH READ ONLY
D) READ-WRITE ONLY

Question

The ____ constraint ensures that any DML operations performed on the view (e.g. ,adding rows,changing data)will not prevent the row from being accessed by the view because it no longer meets the condition in the WHERE clause.​
A) ​ON UPDATE CHECK
B) ​WITH CHECK OPTION
C) ​WITH READ ONLY
D) ​READ-WRITE ONLY

Quizplus · Accepted Answer

The WITH CHECK OPTION constraint ensures that any DML operations performed on the view will not result in any rows being displayed that do not meet the condition in the WHERE clause. This ensures data consistency and prevents unintended updates or inserts on the base table. ON UPDATE CHECK is not a valid option for view constraints, while WITH READ ONLY and READ-WRITE ONLY do not address the issue of maintaining the view's filtering condition.

The ____ Constraint Ensures That Any DML Operations Performed on the View