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 CarrierTrackingNumber 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.)
Build List and Reorder:
Answer:
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
