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

Quizplus · Accepted Answer

The view created only selects the rows where the shipdate is null. Therefore, the shipping date of an order cannot be changed through the view. However, there is no restriction on changing the order#, customer# or orderdate. The WITH CHECK OPTION clause only ensures that inserted or updated rows meet the WHERE clause condition of the view, it does not restrict DML operations.

Which Statement Is True About the View Created with the Following