Home » MCQs » SQLite MCQs

What is the syntax of CREATE VIEW statement?

86. What is the syntax of CREATE VIEW statement?

1. CREATE VIEW database_name.view_name AT SELECT statement...;
2. CREATE VIEW database_name.view_name ON SELECT statement...;
3. CREATE VIEW database_name.view_name AS SELECT statement...;
4. CREATE VIEW database_name.view_name FOR SELECT statement...;

Answer: C) CREATE VIEW database_name.view_name AS SELECT statement...;

Explanation:

The syntax of CREATE VIEW statement is:

CREATE VIEW database_name.view_name  AS SELECT statement ...;