Database Developer Question:

Tell us what is a View?

Tweet Share WhatsApp

Answer:

A view is like a subset of a table which is stored logically in a database. A view is a virtual table. It contains rows and columns similar to a real table. The fields in the view are fields from one or more real tables. Views do not contain data of their own. They are used to restrict access to the database or to hide data complexity.

CREATE VIEW view_name AS SELECT column_name1, column_name2 FROM table_name WHERE CONDITION;

Download Database Developer PDF Read All 70 Database Developer Questions
Previous QuestionNext Question
Tell us what is RDBMS?Tell us what are the different types of joins?