1,657 views
0 votes
0 votes
which statement is true?

1)for any data file it is possible to construct two separate sparse first level index on different keys.

2)for any data file it is possible to construct two separate dense first level index on different keys.

3)for any data file it is possible to construct  a sparse first level index and a dense second level indexboth should be useful

4) none.

1 Answer

2 votes
2 votes
sparse index is possible when key is sorted or ordered therefore only one sparse index is possible however dense index is on unsorted and unordered key therefore two dense index is possible here

Related questions

0 votes
0 votes
1 answer
2
AnilGoudar asked Jun 10, 2017
516 views
Is it possible to have an Index file which is both dense index and sparse Index?
0 votes
0 votes
1 answer
3
srestha asked Sep 16, 2017
598 views
Block size 1000 BSearch key 12 BPointer size 8BWhat is max records of DB1) For Dense index B+ tree of 2 level2) For Sparse index B+ tree of 2 levelHow ans will differ , P...
0 votes
0 votes
1 answer
4
sourabh asked Dec 31, 2015
438 views