Deletion in B-Trees GATE 2024 Fundamental Quiz

Which of the following is primary distinction between B and B⁺ tree indices?

Which of the following statement is true about the B tree and B⁺ tree index? Assume the order of the B tree node same as the order of the B⁺ tree node?

Consider the following statements regarding B-tree:
S1: B-Tree is suitable for the database where 90% of the query needed to access the sequential records.
S2: B-Tree is preferred over AVL trees for making index file due to list cost of accessing.
Which of the following is true?

The Maximum child pointer present at 3^rd level in B Tree , in it each block of size 2048 B and Key size is 16 B , Block Pointer size is 4 B and Record pointer size is 8 B is ______________.

Which of the following statement true about B tree and B⁺ tree index? Assume order of B tree node same as order of B⁺ tree node.

Which of the following statements are correct with respect to the properties of B-Tree of order m.

I. Every node in a B-Tree contains at most m children.

II. All leaf nodes must be at the same level.