Which statement is true about the view created with the following command?
CREATE OR REPLACE VIEW inventory
AS SELECT isbn,title,retail price
FROM books;
A) The command creates a complex view.
B) DML operations are not allowed on the data displayed by the view.
C) A database object named INVENTORY may already exist.
D) all of the above

Question

​Which statement is true about the view created with the following command?
CREATE OR REPLACE VIEW inventory
AS SELECT isbn,title,retail price
FROM books;
A) ​The command creates a complex view.
B) ​DML operations are not allowed on the data displayed by the view.
C) ​A database object named INVENTORY may already exist.
D) ​all of the above

Quizplus · Accepted Answer

The command uses "CREATE OR REPLACE," which means if an object named INVENTORY already exists, it will be replaced. This does not necessarily create a complex view (which typically involves joins, subqueries, or both), and DML operations (like INSERT, UPDATE, DELETE) can be performed on simple views like this, assuming the underlying base tables support it.

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

Which Statement Is True About the View Created with the Following