Question

Which type of view is created from the following SQL statement? CREATE VIEW balancedue AS SELECT customer#, order#, SUM(quantity*retail) amtdue FROM customers NATURAL JOIN orders NATURAL JOIN orderitems NATURAL JOIN books GROUP BY customer#, order#;

Answer 1

Answer:

The correct answer to the following statement is a complex view.

Explanation:

Because complex view is the part of the view in which view can be created by one or more tables and in the following statement they are using the CREATE VIEW command for creating view and next to it they are using SELECT and Join command for the multiple views.

So, that's why the following statement is the complex view.