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:

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