Multiple choice technology mainframe

How many clustering indexes can be defined for a table..?

  1. one

  2. two

  3. six

  4. four

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A table can have only one clustering index, which determines the physical order of data storage. This is by design because data can only be physically sorted one way. Additional indexes are non-clustering (secondary) and don't affect storage order.