Which four TransactSQL statements should you use?

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 CarrierTrackingNumber column. Which four TransactSQL 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.)

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 CarrierTrackingNumber column. Which four TransactSQL 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.)

Answer:

Explanation:
According to these references, this answer looks correct.
Reference:
http://msdn.microsoft.com/en-us/library/ms188783.aspx
http://msdn.microsoft.com/en-us/library/ms189280.aspx



Leave a Reply 0

Your email address will not be published. Required fields are marked *