What is the difference between a clustered index and a non-clustered index?
A. Clustered index determines the physical order of data; non-clustered does not
B. Non-clustered index determines physical order; clustered does not
C. They are the same
D. Clustered index is faster for inserts
Answer: Option A
Solution (By JKSSB Mock Tests)
A clustered index sorts and stores the data rows in the table based on key values, while a non-clustered index is a separate structure that points to the data rows.
No comments yet. Be the first to start the discussion!