Which statement is not true about the view created with the following command?
CREATE VIEW inventory
AS SELECT isbn,title,retail price
FROM books;
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 not true about the view created with the following command?
CREATE VIEW inventory
AS SELECT isbn,title,retail price
FROM books;
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 statement that DML operations are not allowed on the data displayed by the view is not true. Depending on the underlying tables and view definition, it is possible to perform certain DML operations on the data displayed by the view, such as updates or inserts.

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