Which statement is true about the view created with the following command?
CREATE OR REPLACE VIEW 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

Which statement is true about the view created with the following command?
CREATE OR REPLACE VIEW 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

Quizplus · Accepted Answer

The "WITH READ ONLY" option in the view creation command prevents any DML operations (INSERT, UPDATE, DELETE) from being performed through the view, which means that none of the data visible through the view, including order#, shipping date, or any other column, can be modified.

Which Statement Is True About the View Created with the Following