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;
A) The order# of an order can be changed through the view.
B) The shipping date of an order can be changed through the view.
C) A new order can be added through the view as long as no constraints on the underlying table are violated.
D) all of the above

Question

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;
A) ​The order# of an order can be changed through the view.
B) ​The shipping date of an order can be changed through the view.
C) ​A new order can be added through the view as long as no constraints on the underlying table are violated.
D) ​all of the above

Quizplus · Accepted Answer

The Answer of 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;
A) ​The order# of an order can be changed through the view.
B) ​The shipping date of an order can be changed through the view.
C) ​A new order can be added through the view as long as no constraints on the underlying table are violated.
D) ​all of the above

Which Statement Is True About the View Created with the Following