Question

Syntax for creating views is __________

(a) CREATE VIEW AS SELECT

(b) CREATE VIEW AS UPDATE

(c) DROP VIEW AS SELECT

(d) CREATE VIEW AS UPDATE

I got this question in an interview.

My doubt is from Views in section Laying the Foundation of SQL Server

Answer 1

The correct option is (a) CREATE VIEW AS SELECT

Explanation: SQL CREATE VIEW Syntax:CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition.