Which of the below is the correct syntax for a VIEW?

Options
- CREATE VIEW ViewName AS INSERT ...
- CREATE VIEW ViewName AS UPDATE ...
- CREATE VIEW ViewName AS SELECT ...
- Both b and c

CORRECT ANSWER : CREATE VIEW ViewName AS SELECT ...

Discussion Board
View

A view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.
Syntax:
CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

Prajakta Pandit 03-7-2017 06:27 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲