What is a view? What is the purpose of it?

 Posted by Rajnilari2015 on 10/23/2016 | Category: Sql Server Interview questions | Views: 2057 | Points: 40
Answer:

A view is a logical snapshot based on a table or another view. It is mainly used for -

a) Restricting access to data
b) Ensuring data in dependency
c) Making complex queries simple
d) Data integrity and security
e) Faster performance by materializing
f) Providing different views of same data


| Alert Moderator 

Comments or Responses

Login to post response