The GATE Grind

GATE 2008 CS – Question 70

Databases · File Organization and Indexing (B and B+ Trees) · 2 marks · Multiple choice

A file has16384 records, 32 bytes each; key field6 bytes. File is ordered by a nonkey field and unspanned. Blocks1024 bytes, block pointers10 bytes. A secondary key index uses multiple levels. What are first- and second-level index-block counts?

  1. 8 and0
  2. 128 and6
  3. 256 and4
  4. 512 and5

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: (C) 256 and4

Explanation

We are sorry we couldn't write detailed soluition for this, we are working on it!, please consider asking your own AI, its just 2-3 clicks with very minimum effort

More File Organization and Indexing (B and B+ Trees) questions

All File Organization and Indexing (B and B+ Trees) questions →