Multiple choice technology databases

You are creating an index for an existing table. There is already a nonclustered index on the primary key. You would like to put the data into address sequence, which is made up of several fields. The address is not the primary key. What should you do?

  1. Change the primary key index to clustered and create a nonclustered index on the address

  2. Create a nonclustered index on the address.

  3. Create a clustered index on the address.

  4. Change the primary key to the address and make the index clustered.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A clustered index determines the physical order of data in the table. To put data into address sequence, you need a clustered index on the address fields. Only one clustered index can exist per table (unlike nonclustered indexes), and the primary key's nonclustered index doesn't prevent creating another clustered index on a different set of columns.

Keep practicing — related questions