Microsoft Exam Questions

Which four Transact-SQL statements should you use?

DRAG DROP
You develop a database application for a university. You need to create a view that will be
indexed that meets the following requirements:
Displays the details of only students from Canada.
Allows insertion of details of only students from Canada.
Which four Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the correct order.)

Answer:

Explanation:

Reference:
http://msdn.microsoft.com/en-us/library/ms187956.aspx