edited by
38,195 views
71 votes
71 votes

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 a result of these insertions is

  1. $2$
  2. $3$
  3. $4$
  4. $5$
edited by

12 Answers

5 votes
5 votes

using left biasing the ans should be 4 but using right biasing 3. in ques it is not mention to use which biasing only mention isThe maximum number of times leaf nodes would get split up as a result of these insertions is so the correct ans should be only

0 votes
0 votes
If data is given in  either descending order or unsorted order  -  Left biasing will give Maximum leaf spilt...

If data is given in ascending order  -  Right biasing will give Maximum leaf split...

Here it is unsorted order... Therefore maximum leaf split = 4 by left biasing
Answer:

Related questions

29.2k
views
6 answers
62 votes
go_editor asked Apr 23, 2016
29,186 views
Consider the following relational schema:$\text{Suppliers}(\underline{\text{sid:integer}},\text{ sname:string, city:string, street:string})$ ... $\text{3NF}$The schema is not in $\text{2NF}$
39.6k
views
8 answers
68 votes
Kathleen asked Sep 22, 2014
39,598 views
Consider the following relational schema:$\text{Suppliers}(\underline{\text{sid:integer}},\text{ sname:string, city:string, street:string})$ ... part.Find the names of all suppliers who have not supplied only blue parts.
6.9k
views
2 answers
31 votes
Kathleen asked Sep 22, 2014
6,925 views
Consider two transactions $T_1$ and $T_2$, and four schedules $S_1, S_2, S_3, S_4$, of $T_1$ and $T_2$ as given below:$T_1: R_1[x]W_1[x]W_1[y]$T_2 ... conflict-serializable?$S_1 \text{ and } S_2$S_2 \text{ and } S_3$S_3$ only$S_4$ only
25.3k
views
1 answers
92 votes
Kathleen asked Sep 22, 2014
25,264 views
Let $R$ and $S$ be relational schemes such that $R=\{a,b,c\}$ and $S=\{c\}.$ ... $ and $2$1$ and $3$2$ and $4$3$ and $4$