Which Statement About the View Created from the Following Command

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.