Which Statement About the View Created from the Following SQL

question 11

Multiple Choice

Which statement about the view created from the following SQL command is correct,assuming ISBN from the BOOKS table is the primary key used by the view?
CREATE OR REPLACE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit,name
FROM books NATURAL JOIN publisher;

• A) ​DML operations can only be performed on the columns belonging to the PUBLISHER table.
• B) No DML operations are allowed.​
• C) ​DML operations are allowed on both the BOOKS and PUBLISHER tables.
• D) ​DML operations can only be performed on the columns belonging to the BOOKS table.

---

Definitions:

Binge-Eating Disorder

An eating disorder characterized by frequent episodes of consuming very large amounts of food but without subsequent purging behaviors, associated with feelings of shame or guilt.

Overeating

The consumption of food in quantities significantly larger than what is required for basic nutritional needs, often leading to discomfort, health issues, or obesity.

Bulimia Nervosa

An eating disorder characterized by episodes of binge eating followed by compensatory behaviors such as vomiting.

Overweight

A condition where an individual has more body weight than is considered normal or healthy for their height.