edited by
677 views
4 votes
4 votes
Consider a relation company with $3000$ records are of fixed length, with record size $50$ bytes are stored in block of size $512$ bytes $\text{(unspanned).}$ If a secondary index is built on the key field of size $10$ bytes and a block pointer of size $5$ bytes, the number of first level index blocks are_____$?$
edited by

1 Answer

Best answer
7 votes
7 votes

index block factor we have 5120 /(10+5)= 34
so first level index blocks will be ( as secondary index is built so for each reord there will be index entry ) 

ceil [3000/34 =88.23 ]

                        =89

selected by

Related questions

2 votes
2 votes
1 answer
1
0 votes
0 votes
0 answers
3
nag.swarna asked Dec 9, 2018
351 views
Can anyone explain this in detail???
0 votes
0 votes
0 answers
4