Which statement is true about the view created with the following command?
CREATE VIEW outstanding
AS SELECT customer#,order#,orderdate,shipdate
FROM orders
WHERE shipdate IS NULL
WITH CHECK OPTION;
A) The order# of an order cannot be changed through the view.
B) The shipping date of an order cannot be changed through the view.
C) No DML operations are permitted through the view.
D) none of the above

Question

Which statement is true about the view created with the following command?
CREATE VIEW outstanding
AS SELECT customer#,order#,orderdate,shipdate
FROM orders
WHERE shipdate IS NULL
WITH CHECK OPTION;
A) ​The order# of an order cannot be changed through the view.
B) ​The shipping date of an order cannot be changed through the view.
C) ​No DML operations are permitted through the view.
D) ​none of the above

Quizplus · Accepted Answer

The "WITH CHECK OPTION" ensures that any updates or inserts through the view must satisfy the view's WHERE clause condition, which is "shipdate IS NULL". Therefore, the shipping date cannot be changed to a non-null value through the view.

Which Statement Is True About the View Created with the Following