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:

Alveolar-capillary Membrane

The thin tissue layer in the lungs where the exchange of oxygen and carbon dioxide takes place between air spaces and blood.

Pneumonia

A respiratory condition characterized by inflammation of the lungs, usually caused by infection with bacteria, viruses, or other organisms.

Impaired Skin Integrity

A condition where the skin is broken, damaged, or compromised, making it susceptible to infection and other complications.

Bacterial Infection

An infection caused by bacteria, microorganisms that can invade the body and cause illness, which can range from mild to life-threatening.