Question

Question 6 If the index entries are inserted in sorted order into a B+ tree, choose the incorrect option/s about the leaf nodes. a) The new entries get directed to last leaf node if the index entries are inserted in ascending order. b) When last leaf node gets filled, it is split into two. c) If the leaf node splits when inserting in ascending order, the right node is left untouched and the insertions takes place on the left node. d) Except for the first and last leaf, the occupancy of nodes is about 50 percent if inserted in ascending or descending order.
help me with the answer and solutions in dbms

Answer 1

I dont Know It is the answer

Answer 2

  In this question there are two incorrect entries. Incorrect entries are c) If the leaf node splits when inserting in ascending order, the right node is left untouched and the insertions takes place on the left node. d) Except for the first and last leaf, the occupancy of nodes is about 50 per cent if inserted in ascending or descending order.

  Because while inserting in ascending order, insertions takes place in right node and the occupancy of nodes is about 50 percent if inserted in ascending or descending order except for the last leaf.