Open In App

GATE | GATE IT 2006 | Question 61

Like Article
Like
Save
Share
Report

In a database file structure, the search key field is 9 bytes long, the block size is 512 bytes, a record pointer is 7 bytes and a block pointer is 6 bytes. The largest possible order of a non-leaf node in a B+ tree implementing this file structure is
(A) 23
(B) 24
(C) 34
(D) 44


Answer: (C)

Explanation: For B+ tree with order n, index pointer p, and block size = B
For a non leaf node it can be given that
n*p + (n-1)*(k) <= B
n*6 + (n-1)*9 <= 512
n <= 34.77

Quiz of this Question
Please comment below if you find anything wrong in the above post


Last Updated : 28 Jun, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads