1.______________________ uses(use) the less number of blocks to hold necessary i

Question

1.______________________ uses(use) the less number of blocks to hold necessary index entries (Assume the number of records is very big).

a.   primary index

b.   cluster index

c.   secondary index

d.   either a. or b.

e.   all of a., b., and c.

f.   none of a., b., and c.

2. In __________________, the number of (first-level) index entries is equal to the number of records in data file.

a.   primary index

b.   cluster index

c.   secondary index

d. multi-level index

3. ____________ is an index specified on the non-key ordering field of an ordered file of records.

a.   Primary index

b.   Secondary index

c.   Multi-level index

d.   Clustering index

Explanation / Answer

1)

Primary or clustering Index

uses(use) the less number of blocks to hold necessary index entries (Assume the number of records is very big).

2)

. In Primary Index the number of (first-level) index entries is equal to the number of records in data file.

3)

Clustering Index is an index specified on the non-key ordering field of an ordered file of records

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

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