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:

American Health Information Management Association

The American Health Information Management Association (AHIMA) is a professional organization that promotes the accurate, confidential, and secure management of healthcare data.

Controlled Substances Act

A statute establishing federal U.S. drug policy under which the manufacture, importation, possession, use, and distribution of certain substances are regulated.

Medical School

An educational institution that provides training and education for students to become physicians or other health professionals.

Scientific Medicine

An approach to medicine that is based on the scientific method and evidence-based practices.