PrepAway - Latest Free Exam Questions & Answers

Which four Transact- SQL statements should you use?

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:

PrepAway - Latest Free Exam Questions & Answers

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


Leave a Reply