Multiple choice technology databases

Which is correct about index?

  1. B-tree index used for table having completely unique colum

  2. REVERSE key index used for oracle parallel serve

  3. BIT MAP index is used for low cardinality

  4. None of these

Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

B-tree indexes are ideal for unique columns, reverse key indexes are designed to avoid contention in Oracle Parallel Server (RAC) environments, and bitmap indexes are highly efficient for columns with low cardinality.