Discussion Forum : Data Types
Question - Which of the following closely resembles Create view ?
Options:
A .  Create table . . .like
B .  Create table . . . as
C .  With data
D .  Create view as
Answer: Option B


Create table . . . asThe '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.



Was this answer helpful ?
Next Question
Submit Your Solution hear:

Your email address will not be published. Required fields are marked *