ExamVeda
Login
Home
This question belongs to SQL Sql Miscellaneous
Sql Miscellaneous
?

What is a view?

Answer & Solution
Correct Answer: Option B

A VIEW is a virtual table, through which a selective portion of the data from one or more tables can be seen. A view do not contain data of their own. They are used to restrict access to the database or to hide data complexity. A view is stored as a SELECT statement in the database. DML operations on a view like INSERT, UPDATE, DELETE affects the data in the original table upon which the view is based.

The Syntax to create a sql view is:
CREATE VIEW view_name
AS
SELECT column_list
FROM table_name [WHERE condition];

  • view_name is the name of the VIEW.
  • The SELECT statement is used to define the columns and rows that you want to display in the view.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.