Multiple choice technology databases

The Default indexing system in oracle

  1. BALANCED TREE

  2. BITMAP

  3. FUNCTIONAL

  4. BINARY TREE
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Oracle's default and most common indexing system is B-Tree (Balanced Tree) indexing. Bitmap indexing is an optional feature in Oracle used for low-cardinality columns, not the default. Functional indexing exists but is not a separate indexing system - it's just indexing on function results. Binary tree is not a standard Oracle indexing term.

Keep practicing — related questions