You are mastering the company database, including the SQL Server 2005 database which
include a table called Production. Product. The table has more than 50 columns
The most common queries are listed below Transact-SQL statements. –QUERY 1SELECT
[Name], [ProductLine], [ListPrice], [Class], [Style] FROM [Production]. [Product]WHERE
[ProductLine] = ‘T’ –QUERY 2SELECT * FROM [Production]. [Product] ORDER BY [Name]
When you are minimizing the space required for the indexes.
You should select the best indexes to maintain the most common searched to the
Production. Product tableWhich is the correct answer?
A.
You should develop a clustered index on the Name column.
B.
You should develop a nonclustered index on the Name column.
C.
You should develop a clustered index on the ProductLine, ListPrice, Class and Style
columns.
D.
You should develop a nonclustered index on the ProductLine, ListPrice columns.