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

Question

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

Quizplus · Accepted Answer

The command creates a simple view because it does not involve any joins, group by clauses, or subqueries. It simply selects columns from one table based on a condition.

Which Type of View Is Created by the Following Command