- A The order of columns in an index is not important.
- B A primary index should have the “Allow Duplicates” property set to “Yes.”
- C A non-clustered index organizes data in a table according to the order of the index.
- D An index is used to improve the speed of data retrieval.
- Share this MCQ
Answer:
D
Share this MCQ
- A. Incorrect: The order of columns in an index is important and should be organized from most to least granular.
- B. Incorrect: A primary index should have the “Allow Duplicates” property set to “No” because it is a unique key.
- C. Incorrect: A clustered index, not a non-clustered index, organizes data in a table according to the order of the index.
- D. Correct: The main purpose of an index is to increase the speed of retrieving data.
Share this MCQ