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
5-3-7-2
0
0
CREATE VIEW dbo.CanadianStudents
WITH schemabinding
AS
SELECT a.LastName, a.firstName, s.JobTitle, a.Country, e.LastQualification
FROM Students AS s
INNER JOIN NativeAddress AS a ON a.AddressID=s.AddressID
INNER JOIN EducationHistory AS e ON s.StudentID=e.StudentID
WHERE a.Country=’Canada’
WITH CHECK option
0
0