Home » Database » Database miscellaneous » Question

Database miscellaneous

  1. The following key values are inserted into a B+ tree in which order of the internal nodes is 3, and that of the leaf nodes is 2, in the sequence given below. The order of internal nodes is the maximum number of tree pointers in each node, and the order of leaf nodes is the maximum number of data items that can be stored in it. The B+ tree is initially empty.
    10, 3, 6, 8, 4, 2, 1
    The maximum number of times leaf nodes would get split up as result of these insertions is
    1. 32
    2. 3
    3. 4
    4. 5
Correct Option: A

No. of splits would be three. This can be further displayed in the figure below
Insert 10 : 10
Insert 3 : 3, 10
Insert 6


Therefore, the total number of splits is 2.



Your comments will be displayed only after manual approval.