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.

Question

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.

Quizplus · Accepted Answer

The view is a virtual table created based on the SELECT statement. It does not store data itself but displays data from the underlying tables. While you cannot directly modify a calculated column (profit in this case), you can change the data in the underlying table (e.g., the retail price) that affects the view. Adding new books or directly changing the profit column through the view is not possible because views do not support inserting or updating calculated columns directly.

Which Statement About the View Created from the Following Command