Multiple choice technology mainframe

. How many clustering indexes are allowed for a table?

  1. Two

  2. Three

  3. Four

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

A table can have only one clustering index (also called clustered index). The clustering index determines the physical order of data in the table - the table itself is sorted according to the clustering index key. Since data can only be physically stored in one order, only one clustering index is allowed per table. Non-clustering indexes can be created on additional columns.

Keep practicing — related questions