MS SQL Server Views Interview Question:

Explain the functionalities that views support?

Submitted by: Administrator

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
Submitted by: Administrator