GATE CSE 2025 Session 1 Q21: Effect of inserting 23 into a full B+ tree
- Databases
- 1 mark
- MSQ
- No negative marking
Question
Consider the following tree with 5 nodes, in which a node can store at most 3 key values. The value 23 is now inserted in the tree. Which of the following option(s) is/are CORRECT?

Try it: multiple select: one or more correct options
Show answer and explanation
Answer: B, D (official GATE 2025 final answer key)
Concept used: B+ tree insertion: a full leaf splits and pushes a key up; a full parent splits in turn.
First step: 23 goes into the last leaf (20, 21, 22), which is already full, so it splits and sends a key to the root, which is also full.
Full step-by-step solution
Detailed working, common mistakes and linked mock tests will be available with a free GATEiit account. Log-in is coming soon.
Share this question
Source: official GATE 2025 Session 1 CS question paper and final answer key, organised by IIT Roorkee. Question paper · Answer key
More Databases PYQs
- 2026 Session 1 · Q30Which functional dependency inferences always hold
- 2026 Session 1 · Q31Dependency-preserving decompositions for 1NF, 2NF, 3NF, BCNF
- 2026 Session 1 · Q43Relational algebra equivalent of a tuple calculus join query
- 2026 Session 1 · Q65Number of superkeys with candidate keys {A,B} and {A,C}
- 2026 Session 2 · Q15Match DBMS schema levels with what they describe
- 2026 Session 2 · Q20When two transactions do not conflict on a data item