engineering computer science MCQ #778

engineering computer science MCQ #778

1. Question 1

   Q1. What is the difference between a clustered index and a non-clustered index?

   • A) Clustered index reorders data, non-clustered index does not
   • B) Clustered index does not reorder data, non-clustered index does
   • C) Clustered index is used for data security, non-clustered index is used for query performance
   • D) Clustered index is used for query performance, non-clustered index is used for data security

   Answer: Clustered index reorders data, non-clustered index does not

   Explanation: A clustered index reorders the physical data, while a non-clustered index creates a separate data structure to store index keys.