Question

Which of the following statements about implementing indexes in SQL Server is FALSE?

Select one:

a. It is possible to implement an index in SQL Server which involves more than one column in a given table

b. By default, SQL Server will create an index on the primary key column of each table

c. SQL Server does not allow the database designer to select the type of index (e.g., B-tree index, bitmap index, etc.) that will be implemented

d. All of the above statements are true

Answer 1

Answer:-  d. All of the above statements are true