Is a search key a) a primary key, b) any candidate key, or c) any attribute or c

Question

Is a search key a) a primary key, b) any candidate key, or c) any attribute or collection of attributes? _________

In Figure 10.10, the records are stored in order of their primary key (the ID attribute), but there are also pointers from one field to the next. Why are there pointers when the records are already stored in the right order? Is it because a) when records are added or deleted it may be difficult to keep records in the right order, b) pointers allow for faster search, b) the pointers provide a cross-check in the case of an error? _________

True or false: in a dense index, there must be pointer from the index to every record in the file. ____________.

This is Fig. 11.3 of our text:

Is the index in the figure a) a clustering index, or b) a nonclustering index? __________

Explanation / Answer

a) A primry key

b) pointers allow for faster search

True, in a dense index, there must be a pointer from the index to every record in the file.

(I am not able to answer last question because not able seeing any figure which you have mentioned.

I am not sure about my 2nd answer also because no figure is showing there too.)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.