A non-clustered index maintains a separate index structure that points to the actual data rows in the table, but the physical order of the rows in the table doesn't have to match the order of the index. This means you can have a non-clustered index on a table that already has a clustered index, as the physical order is determined by the clustered index and the non-clustered index simply provides a different way to access the data based on its indexed values.
Which of the following is a characteristic of a non-clustered index?
Review the verified answer and explanation for this SPSC – Sindh Public Service Commission past-paper question on CampusFin.
Question context
This question is part of 💻 Computing within the broader 💾 Computer Science subject and appears in the SPSC – Sindh Public Service Commission preparation collection. Reviewing the answer together with nearby questions helps reinforce the underlying concept and identify how it may appear in competitive exams.