Multiple Choice
Which statement about the view created from the following SQL statement is correct?
CREATE VIEW balancedue
AS SELECT customer#,order#,SUM(quantity*retail) amtdue
FROM customers NATURAL JOIN orders NATURAL JOIN
Orderitems NATURAL JOIN books
GROUP BY customer#,order#;
A) No DML operations can be performed through the view.
B) DML operations can only be performed on the CUSTOMERS table since it is the primary key for the view.
C) Only rows can be added through the view - no other DML operations are allowed.
D) none of the above
Correct Answer:

Verified
Correct Answer:
Verified
Q82: How is a "TOP-N" analysis performed?
Q83: An inline view is a temporary table
Q84: The pseudo column <u>ROW</u> can be used
Q85: Rows in an underlying table cannot be
Q86: <u>Rows</u> cannot be added to a table
Q88: Values cannot be inserted through a view
Q89: Which of the following describes a type
Q90: Any DDL operation can be performed on
Q91: Which statement is not true about the
Q92: "TOP-N" analysis can be used to find