IBM
C2090-312 · Question #68
Why does the following DDL command fail? CREATE INDEX X1 ON T1 (COL1, COL2, COL3, BUSINESS_TIME WITHOUT_OVERLAPS);
The correct answer is C. The index must be defined as UNIQUE. See the full explanation below for the reasoning.
Question
Why does the following DDL command fail? CREATE INDEX X1 ON T1 (COL1, COL2, COL3, BUSINESS_TIME WITHOUT_OVERLAPS);
Options
- AThe index must be partitioned.
- BThe index must use page size > 4K.
- CThe index must be defined as UNIQUE.
- DThe index must be defined as CLUSTER.
How the community answered
(43 responses)- A5% (2)
- B7% (3)
- C86% (37)
- D2% (1)
Community Discussion
No community discussion yet for this question.