Question

How non clustered index point to the data?

(a) It never points to anything

(b) It points to a data row

(c) It is used for pointing data rows containing key values

(d) None of the mentioned

The question was asked in my homework.

I'd like to ask this question from Index Definition in SQL topic in section Indexing and Hashing of Database Management

Answer 1

Right choice is (c) It is used for pointing data rows containing key values

Best explanation: Nonclustered indexes have a structure separate from the data rows. A nonclustered index contains the nonclustered index key values and each key value entry has a pointer to the data row that contains the key value.