Question 72

Computer Awareness Trees Medium

In a B+ tree, If the search-key value is 8 bytes long, the block size is 512 bytes and the block pointer size is 2 bytes, then maximum order of the B+ tree is

(A) 50
(B) 51
(C) 52
(D) 54
View Dynamic Solution & Explanation
Correct Solution: Option C

Step-by-step Solution:

B⁺ Tree: Internal Node Calculation
Given Data:
Disk Block Size (D) = 512 bytes
Block Pointer (B) = 2 bytes
Key Field (K) = 8 bytes
Order (p) = ?
Formula: \[ p \times 2 + (p - 1) \times 8 \leq 512 \] Calculation: \[ p \times 2 + (p - 1) \times 8 \leq 512 \] \[ 2p + 8p - 8 \leq 512 \] \[ 10p - 8 \leq 512 \] \[ 10p \leq 520 \] \[ p \leq 52 \] Thus, the order (p) of the B⁺ Tree is 52.