Multiple choice technology databases

Which of the following are the restrictions of creating bitmap indexes (choose all that apply):

  1. You cannot specify BITMAP for a domain index

  2. You cannot specify both UNIQUE and BITMAP

  3. You cannot specify BITMAP when creating a local index.

  4. You cannot specify BITMAP when creating a global partitioned index
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

Oracle bitmap index restrictions include that you cannot specify BITMAP for a domain index, you cannot combine UNIQUE and BITMAP, and you cannot create a global partitioned bitmap index. Local partitioned bitmap indexes are allowed.

Keep practicing — related questions