What is a view and what are its advantages?

The subset of a table which is basically stored logically in a database is called as a view. A view is a virtual table which is containing the rows and columns. The fields located in views are similar to tables and they do not contain the date of their own. Its advantages are:

• It occupies no space
• It is used to restrict the access given to the database.
• It also hides the complexity associated with data.
• It simply describes the complicated results.