Q. 42 Consider a file of 1684 records. Each record is 32 bytes long and its key field is
of size 6 bytes. The file is ordered on a non-key field, and the file organization
is unspanned. The file is stored in a file system with block size 1024 bytes, and
the size of a block pointer is 10 bytes. If the secondary index is built on the key
field of the file, and a multi-level index scheme is used to store the secondary
index, the number of first-level and second-level blocks in the multi-level index
are respectively
(A) 8 and 0
(B) 128 and 6
(C) 256 and 4
(D) 512 and 5
Answer: (C)
Explanation:
