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:
Verified answer as correct.
Reference: http://msdn.microsoft.com/en-us/library/ms187956.aspx
why is Check option required?
0
0
to allow insertion of details of only students from Canada.
0
0
Thanks Dan
0
0
The view should be indexed. Shouldnt we use create indexed view ?
0
0