Multiple choice technology web technology

When creating an index using the CREATE INDEX statement,the UNIQUE and BITMAP keywords may be used together.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle SQL, the UNIQUE and BITMAP keywords cannot be used together when creating an index. UNIQUE enforces that all index key values must be distinct, while BITMAP creates a bitmap index optimized for low-cardinality columns with few distinct values. These are fundamentally different index types with different use cases, so they're mutually exclusive. You must choose one or the other, not both.