492 views
6 votes
6 votes
consider a disk with block size 1024 bytes.A block pointer 6 bytes and record pointer 8 bytes.File has 10000 records.Every record is fixed length of 100 bytes. Its key is SSN which is of 2 bytes. The file is not ordered by the field SSN and want to construct secondary index on SSN.

Find the number of records in the root of multi level index is --------------

What is the root in multi level index tree????

What will be the number of blocks at each level????

If number of blocks at level i is known, then how to calculate number of records at each level and in each block

Please log in or register to answer this question.

Related questions

0 votes
0 votes
0 answers
1
0 votes
0 votes
1 answer
3
vishnu777 asked Nov 8, 2022
411 views
Can anyone explain in detail about the concepts of sencondary indexing in dbms??
0 votes
0 votes
0 answers
4
Purple _ rain asked Sep 3, 2022
138 views
What is fanout ratio