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:

IPods

A line of portable media players designed and marketed by Apple Inc., notable for transforming the music and electronics industries.

ITunes

A media player, media library, Internet radio broadcaster, and mobile device management application developed by Apple Inc.

Inferior Goods

Products for which demand decreases as consumers' income increases, opposite of normal goods.

Quantity Demanded

The level of demand for a good or service that individuals can and are ready to buy at an established price.