What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2005 database that contains a table named CK_Prod. Product, that has over 50 columns. The
normal Transact-SQL statement queries are as follows:

–QUERY 1
SELECT [Name], [ProductLine], [ListPrice], [Class], [Style] FROM [CK_Prod]. [Product]WHERE
[ProductLine] = ‘T’

–QUERY 2
SELECT * FROM [CK_Prod]. [Product] ORDER BY [Name]

You have received instructions to minimize the space for the indexes, however, you should keep
the most common searched to CK_Prod. Product.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2005 database that contains a table named CK_Prod. Product, that has over 50 columns. The
normal Transact-SQL statement queries are as follows:

–QUERY 1
SELECT [Name], [ProductLine], [ListPrice], [Class], [Style] FROM [CK_Prod]. [Product]WHERE
[ProductLine] = ‘T’

–QUERY 2
SELECT * FROM [CK_Prod]. [Product] ORDER BY [Name]

You have received instructions to minimize the space for the indexes, however, you should keep
the most common searched to CK_Prod. Product.

What should you do?

A.
You should consider creating a clustered index on the ProductLine, ListPrice, Class and Style columns.

B.
You should consider creating a clustered index on the Name column.

C.
You should consider creating a nonclustered index on the Name column.

D.
You should consider creating a nonclustered index on the ProductLine, ListPrice columns.



Leave a Reply 0

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