Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q114: How do the following three types of
Q115: Rows can be updated through a simple
Q116: The <u>WITH CHECK OPTION</u> can be used
Q117: Rows cannot be added to a table
Q118: The _ keywords can be used to
Q120: DML operations are not allowed on views
Q121: Which type of view is created from
Q122: DML operations are not allowed on a
Q123: Views are database objects that store data.
Q124: DML operations are not allowed on a