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

Quizplus · Accepted Answer

DML (Data Manipulation Language) operations such as INSERT, UPDATE, and DELETE are not always prohibited on views, but in this case the view is created with a simple SELECT statement and does not include any criteria that allow for modification of the underlying data. Therefore, option B is not true. Options A and C are both true statements about the view.

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