Beginner
Database Management Systems
Q27 / 100
What is the difference between a clustered and non-clustered index?
Correct! Well done.
Incorrect.
The correct answer is B) A clustered index physically orders table rows by the index key; a non-clustered index is a separate structure with pointers to rows
B
Correct Answer
A clustered index physically orders table rows by the index key; a non-clustered index is a separate structure with pointers to rows
Explanation
A table can have only one clustered index (determines physical row order — typically the primary key in MySQL InnoDB). Non-clustered indexes are separate B-trees with row pointers.
Progress
27/100