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

a & b 
refer to avi silberschatz database and concepts book
for more