0
Which statement correctly distinguishes a clustered index from a non-clustered index?
- AA clustered index physically reorders the table's data rows to match the index order (only one allowed per table); a non-clustered index maintains a separate structure with pointers to the data rows (multiple allowed)
- BThey are functionally identical, differing only in name
- CA non-clustered index is always faster than a clustered index
- DA clustered index can only be created on numeric columns
Correct answer: A