Multiple choice technology databases

How many clusterd index you can create on a table

  1. 3

  2. Depends on senario

  3. 2

  4. 1
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A table can have only one clustered index because clustered indexes physically reorder the data storage order. The entire table's rows are stored in the order of the clustered index key. Multiple clustered indexes would require storing the same data in different physical orders simultaneously, which is impossible. Non-clustered indexes can be many.

Keep practicing — related questions