You are creating an important view that a web application will use to extract data from a SQL Server 2012 database. You want to ensure that the underlying table structure referenced by the view cannot be altered in a way that would affect the view definition without someone first dropping the view.

Which of the following options would you use with the CREATE VIEW statement?

 Posted by Rajkatie on 6/30/2013 | Category: Sql Server Interview questions | Views: 3536 | Points: 40
Select from following answers:
  1. SCHEMABINDING
  2. ENCRYPTION
  3. CHECK OPTION
  4. All Above

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response