Database Fundamentals — Question 11

Which type of index changes the order in which the data is stored in a table?

Answer options

• A. non-sequential
• B. sequential
• C. non-clustered
• D. clustered

Correct answer: A

Explanation

A clustered index changes the way data is physically stored in a table, affecting its order. In contrast, non-clustered indexes do not alter the storage order of data. The options sequential and non-sequential do not accurately describe index types that influence data arrangement.