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$ Databases databases + – Shefali asked Nov 8, 2015 Shefali 580 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
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$ Pooja Palod answered Nov 8, 2015 Pooja Palod comment Share Follow See all 2 Comments See all 2 2 Comments reply Shefali commented Nov 8, 2015 reply Follow Share Don't we have to consider one more block for indexing the 4 blocks? 0 votes 0 votes kirti singh commented Nov 9, 2015 reply Follow Share how is answer calsulated? any formula for that? I am not getting it. 0 votes 0 votes Please log in or register to add a comment.
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 souravsaha answered Nov 17, 2015 souravsaha comment Share Follow See 1 comment See all 1 1 comment reply Shefali commented Dec 5, 2015 reply Follow Share Why aren't you considering one more block that holds the pointers for 3 index blocks? 0 votes 0 votes Please log in or register to add a comment.