Multiple choice technology databases

Which one is the level of index in the below list

  1. Intermediate level

  2. Header level

  3. Data level

  4. Binary level
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQL Server indexes use a B-tree structure with multiple levels: the root level at the top, intermediate levels that branch between root and leaves, and the leaf level containing actual data or data pointers. 'Intermediate level' is the correct structural term for non-leaf levels between root and leaf.

Keep practicing — related questions