You are creating several views for a temp database. You need to ensure that data within the temp database is modified in authorized ways only. When creating the view, you specify the limits to the ways that data can be modified. You want to ensure that all statements that modify data executed against the view follow these criteria.

Which of the following options would you use when creating this view?

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

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response