Register

Question on dense index

1,275 views
0 votes
0 votes
________ index is dense

A) Primary index
B) clustered index
C) secondary index on candidate key
D) all
User Avatar

1 Answer

Best answer
5 votes
5 votes
AND : C

primary and clustered indexes are sparse.

secondary index is dense
• selected by
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
1
srestha asked Sep 16, 2017
623 views
Sparse and Dense index doubt
Block size 1000 B Search key 12 B Pointer size 8B What is max records of DB 1) For Dense index B+ tree of 2 level 2) For Sparse index B+ tree of 2 level How ans will differ , Plz show
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...
User Avatar
1 votes
1 votes
2 answers
2
Shefali asked Nov 8, 2015
602 views
Dense index
A block can hold either $12$ records or $42$ key pointers .A database contains $96$ records , then how many blocks are required to hold the data file and the dense Index? a). $10$ b). $12$ c). $11$ d). $13$
A block can hold either $12$ records or $42$ key pointers .A database contains $96$ records , then how many blocks are required to hold the data file and the dense Index?...
User Avatar
0 votes
0 votes
1 answer
3
focus _GATE asked Jun 30, 2015
490 views
Is there any condition in which we can say that dense index is sparse index??
Is there any condition in which we can say that dense index is sparse index?
Is there any condition in which we can say that dense index is sparse index?
User Avatar
Link Copied!