Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

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
Full explanation