Which type of view is created with the following command?
CREATE VIEW OR REPLACE outstanding
AS SELECT customer#,order#,orderdate,shipdate
FROM orders
WHERE shipdate IS NULL
WITH READ ONLY;
A) simple
B) complex
C) derived
D) inline

Question

Which type of view is created with the following command?
CREATE VIEW OR REPLACE outstanding
AS SELECT customer#,order#,orderdate,shipdate
FROM orders
WHERE shipdate IS NULL
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