What is the difference between a clustered index and a non-clustered index?
A. Non-clustered index determines physical order; clustered does not
B. Clustered index is faster for inserts
C. Clustered index determines the physical order of data; non-clustered does not
D. They are the same
Answer: Option C
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.
Explanation:
The BETWEEN operator selects values within a specific inclusive range. It is shorthand for a combination of greater-than-or-equal-to and less-than-or-equal-to conditions.
No comments yet. Be the first to start the discussion!