IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 11

Which of the following is TRUE about indexes on column organized tables?

Answer options

• A. No indexes are allowed
• B. Indexes are only allowed on numeric columns
• C. Indexes are automatically created to enforce unique constraints
• D. An index is only allowed on the synopsis table supporting a column organized table

Correct answer: A

Explanation

The correct answer is A because column-organized tables do not support indexes. Options B, C, and D are incorrect as they suggest conditions or allowances for indexes that do not exist in column-organized tables.