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.)
