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