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

Question

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

Quizplus · Accepted Answer

This view is a result of a SELECT statement with GROUP BY clause, so it aggregates data from the base tables. DML operations cannot be performed through the view since it doesn't correspond to a single table directly.

Which Statement About the View Created from the Following SQL