580 views
1 votes
1 votes

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$

2 Answers

2 votes
2 votes
No of blocks for record=$96/12=8$

No of block for index=$96/24=4$

So total no of blocks= $12$
0 votes
0 votes

No of blocks for record = 96/12 = 8

For indexing = ceil(96/42 ) = 3

Hence, 

So total no of blocks = 8+3 = 11  

Related questions

0 votes
0 votes
1 answer
1
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
2
shikharV asked Dec 8, 2015
1,259 views
________ index is denseA) Primary indexB) clustered indexC) secondary index on candidate keyD) all
0 votes
0 votes
1 answer
3
focus _GATE asked Jun 30, 2015
463 views
Is there any condition in which we can say that dense index is sparse index?