SQL Server 2000 - Technical MCQs

Q1:

SQL Server automatically creates an index on:

A primary keys only.

B foreign key only.

C both primary and foreign keys.

D SQL Server never automatically creates an index.

ANS:C - both primary and foreign keys.

Automatically generate an index on primary & unique key only.