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 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.)
Select and Place:

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.)
Select and Place:

Answer:

Show Hint

← Previous question

Next question →