SQL Server 2000
SQL Server automatically creates an index on:

primary keys only
SQL Server never automatically creates an index
both primary and foreign keys
foreign key only

ANSWER DOWNLOAD EXAMIANS APP