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: