Question

All of the following statements about non-clustered indexes are FALSE, except _______.

Select one:

a. Non-clustered indexes are usually faster than clustered indexes

b. Non-clustered indexes use row locators which point to the locations of the actual data rows

c. The leaf nodes of a non-clustered index can only contain values from indexed columns

d. A table can have only one non-clustered index

Answer 1

Correct Answer: c

Explanation:

To retrieve data from the table, the clustered index would be faster but for data updates, it will decrease the performance of the system because every time we need to update the index as well.

The row locator maybe points to the data row or it maybe points to the clustered index key because it will depend upon the data structure used.

The leaf node of non-clustered indexes contains a pointer to the actual data but it does not contain any actual data.

There may be more than one non-clustered index on a single table.

So, option c is the correct.