Home » Database » Database miscellaneous » Question

Database miscellaneous

  1. Consider a file of 16384 records. Each record is 32 byte long and its key field is of size 6 byte. The file is ordered on a nonkey field, and the file organization is unspanned. The file is stored in a file system with block size 1024 byte, and the size of a block pointer is 10 byte. If the secondary index is built on a 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
    1. 8 and 0
    2. 128 and 6
    3. 256 and 4
    4. 512 and 5
Correct Option: C

No. of records = 16384
Size of record = 32 byte
Block size = 1024 = 210
Here, we need to find the option that satisfies the condition 210.
Option (a), 8 × 0 = 0
Option (b), 128 × 6 = 768
Option (c), 256 × 4 = 1024
Option (d), 512 × 5 = 2560
Since, option (c) satisfies the block size, it is the desired answer.



Your comments will be displayed only after manual approval.