Which four Transact-SQL statements should you use?

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

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:

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 2

Your email address will not be published. Required fields are marked *


David

David

Surely this is a 70-461 question?

God

God

6 – 4 – 1 – 3