​Which Statement Is True About the View Created with the Following

question 98

Multiple Choice

​Which statement is true about the view created with the following command?
CREATE OR REPLACE VIEW inventory
AS SELECT isbn,title,retail price
FROM books;

• A) ​The command creates a complex view.
• B) ​DML operations are not allowed on the data displayed by the view.
• C) ​A database object named INVENTORY may already exist.
• D) ​all of the above

---

Definitions:

Ether

Organic compounds that are defined by having an oxygen atom bonded to two alkyl or aryl groups.

Carboxylic Acid

Organic acids characterized by the presence of at least one carboxyl group, which consists of a carbon atom double-bonded to an oxygen atom and single-bonded to a hydroxyl group.

Alcohol

A compound containing one or more hydroxyl (OH) groups attached to a carbon atom.

Ester

Organic compounds formed by the reaction of an acid (usually carboxylic acid) with an alcohol, characterized by the functional group -COO-.