8,023 views
6 votes
6 votes
Consider the following statement
(i) Primary index is always sparse
(ii) Secondary index may or may not be dense
Which of the above statement is/are false?

A)Only (i)

B)Only (ii)

C)Both (i) and (ii)

D)None of these

3 Answers

Best answer
10 votes
10 votes
Ans is D

Primary is always sparse. Secondary may be dense if done on a key field and sparse if done on a non-key field.
selected by
1 votes
1 votes
i think option C is correct.

primary index may or may not be sparse.

but Secondary index is always dense.
0 votes
0 votes
D

Secondary  index cant be sparse they have to be dense coz values are scattered among the db file and file is not ordered on search key and primary index can be dense/sparse.
edited by

Related questions

1 votes
1 votes
0 answers
2
iamHarin asked Jul 22, 2017
215 views
why Multi- level Indexes uses fan out as base of log function
0 votes
0 votes
1 answer
4
syedasafoora asked Nov 8, 2023
221 views
Consider the following algorithm for Build-Max-heap and the given array A=[ 47,96, 35, 54, 77, 65, 83]. Run this algorithm on the given array and redraw the heap and the ...