Question

Which of the following closely resembles Create view?

(a) Create table . . .like

(b) Create table . . . as

(c) With data

(d) Create view as

The question was posed to me in an interview for job.

This is a very interesting question from SQL Data Types and Schemas topic in division SQL : Queries, Constraints and Triggers of Database Management

Answer 1

The correct choice is (b) Create table . . . as

Easy explanation - The ‘create table . . . as’ statement closely resembles the create view statement and both are defined by using queries. The main difference is that the contents of the table are set when the table is created, whereas the contents of a view always reflect the current query result.