Which type of view is created with the following command?
CREATE VIEW inventory AS SELECT isbn,title,retail price
FROM books
WITH READ ONLY;
A) simple
B) complex
C) derived
D) inline

Question

​Which type of view is created with the following command?
​ CREATE VIEW inventory AS SELECT isbn,title,retail price
FROM books
WITH READ ONLY;
A) ​simple
B) ​complex
C) ​derived
D) ​inline

Quizplus · Accepted Answer

The command creates a simple view because it selects columns directly from a single table without using joins, subqueries, or aggregations.

​Which Type of View Is Created with the Following Command

Which Type of View Is Created with the Following Command