Which statement is True about the view created with the following command? CREATE VIEW OR REPLACE outstanding
AS SELECT customer#, order#, orderdate, shipdate
FROM orders
WHERE shipdate IS NULL
WITH READ ONLY;
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) all of the above

Question

Quizplus · Accepted Answer

The view is created as READ ONLY, which means no modifications can be made to the underlying data through this view. Therefore, options A and B are true. As the view is read-only, no DML operations like INSERT, UPDATE, or DELETE can be performed through this view, making option C true as well.

Which Statement Is True About the View Created with the Following