Question 52 ______________________ has the least number of block accesses to sea

Question

Question 52

______________________ has the least number of block accesses to search and retrieve a record (Assume the number of records is very big).

a.

Primary index

b.

Cluster index

c.

B-tree/B+-Tree

d.

Secondary index

Question 54

_______________ is the non-dense index.

a.

primary index

b.

cluster index

c.

secondary index

d.

both a. and b.

Question 55

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

a.

Clustering index

b.

Primary index                                        

c.

Multi-level index

d.

Secondary index

a.

Primary index

b.

Cluster index

c.

B-tree/B+-Tree

d.

Secondary index

Explanation / Answer

Ans 52: Option C

Ans 54: Option D

Ans 55: Option B

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

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