Which Statement About the View Created from the Following SQL

question 87

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

---

Definitions:

Labor Market

The supply of available workers in relation to available work.

Job Applicants

Individuals who apply for a specific job opening, offering their qualifications and expressing their interest in the position.

Etiquette Guidelines

A set of rules and conventions governing socially acceptable behavior in given contexts or social situations.

Smartphone Use

The utilization of smartphones for a variety of purposes, including communication, entertainment, work, and accessing information.