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.)
Answer: 
Explanation:
1) create nonclustered index findx_specialOfferID
2) on dbo.OrderDetails(SalesOrderID)
3) where
4) special offer id is not null
0
0
Whitespaces should be removed from ‘special offer id’, as the column name is [SpecialOfferID]
0
0