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

Question

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

Quizplus · Accepted Answer

This command creates a simple view because it selects columns directly from one table without using joins, subqueries, or aggregations. The "WITH CHECK OPTION" ensures that any modifications through the view adhere to its defining condition, but it doesn't change the view's classification as simple.

Which Type of View Is Created with the Following Command