Which Statement About the View Created from the Following Command

question 72

Multiple Choice

Which statement about the view created from the following command is correct,assuming no constraints exist on the underlying table?
CREATE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit
FROM books;

• A) ​The retail price of a book can be changed.
• B) ​The profit generated by a book can be changed.
• C) ​The profit generated by a book can be added.
• D) ​Values for a new book can be added for all five columns displayed by the view.

---

Definitions:

Trumpet

A brass wind instrument with a flared bell and three buttons (valves) that is commonly used in classical and jazz music.

Pyrotechnics

The art, craft, or science of making and using fireworks or related explosive devices for entertainment, military, or industrial purposes.

Fourth of July

A U.S. holiday commemorating the Declaration of Independence of the United States, on July 4, 1776.

Pyrotechnics

The art and science of making fireworks, including the design and manufacture of devices that produce light, sound, and smoke for entertainment purposes.