SQL (Structured Query Language) Question:

Download Job Interview Questions and Answers PDF

What are the advantages of VIEW?

SQL Interview Question
SQL Interview Question

Answer:

- To protect some of the columns of a table from other users.
- To hide complexity of a query.
- To hide complexity of calculations.

Download SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What is a database link?If a view on a single base table is manipulated will the changes be reflected on the base table?