DRAG DROP
You administer a Microsoft SQL Server 2012 database.
You use an OrderDetail table that has the following definition:
You need to create a non-clustered index on the SalesOrderID column in the OrderDetail table to
include only rows that contain a value in the SpecialOfferID column.
Which four Transact-SQL statements should you use? (To answer, move the appropriate statements
from the list of statements to the answer area and arrange them in the correct order.)
Explanation:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms188783.aspx
http://msdn.microsoft.com/en-us/library/ms189280.aspx
Is this really a 462 question?
It is also in 461.
http://www.aiotestking.com/microsoft/which-four-transact-sql-statements-should-you-use-33/
I think yes, because using and creating indexes is the part of 461 also. This question is used on both exams i think, as few others that is used in 462 and 463.