Which statement is true about the view created with the following command?
CREATE VIEW inventory AS SELECT isbn,title,retail price
FROM books
WITH READ ONLY;
A) The command creates a simple view.
B) DML operations are NOT allowed on the data displayed by the view.
C) A view named INVENTORY did not previously exist.
D) all of the above

Question

Which statement is true about the view created with the following command?
CREATE VIEW inventory AS SELECT isbn,title,retail price
FROM books
WITH READ ONLY;
A) ​The command creates a simple view.
B) ​DML operations are NOT allowed on the data displayed by the view.
C) ​A view named INVENTORY did not previously exist.
D) ​all of the above

Quizplus · Accepted Answer

The command creates a simple view named INVENTORY that selects the columns isbn, title, and retail price from the table books. The WITH READ ONLY clause ensures that DML operations such as INSERT, UPDATE, or DELETE are not allowed on the data displayed by the view. This view is also created for the first time, so a view named INVENTORY did not previously exist. Therefore, all of the above statements are true.

Which Statement Is True About the View Created with the Following