> > >

SQL MCQs

Which statement about non-clustered index is true?

A non-clustered index is a special type of index that reorders the way records in the table are physically stored.

In non-clustered index , the logical order of the index always matches the physical stored order of the rows on the disk.

The leaf nodes of a non-clustered index contain the data pages.

The leaf nodes of a non-clustered index contain the index rows.

Answer

Correct Answer: The leaf nodes of a non-clustered index contain the index rows.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

SQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it