MS SQL Server Views Question:

Download Job Interview Questions and Answers PDF

Explain the functionalities that views support?

SQL Server Views Interview Question
SQL Server Views Interview Question

Answer:

Views can subset data in a table
They can join multiple tables into one virtual table
Views can provide security and decrease complexity
They save space because only their definition is stored.
They can also be used to create abstraction
Materialized views are commonly used in data warehousing. They represent a snapshot of the data from remote sources.

Views can create other calculated fields based on values in the real underlying tables

Download SQL Server Views Interview Questions And Answers PDF

Previous QuestionNext Question
Explain Indexed view?What are views?