Explain the functionalities that views support?
Submitted by: AdministratorViews 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
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
Read Online MS SQL Server Views Job Interview Questions And Answers
Top MS SQL Server Views Questions
| ☺ | Explain Indexed view? |
| ☺ | What are views? |
| ☺ | Explain the functionalities that views support? |
| ☺ | Can you explain What is Indexed view? How to create it? |
| ☺ | Explain What are partitioned views and distributed partitioned views? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
