IBM
C2090-610 · Question #83
What is the primary purpose for using the INCLUDE clause with a CREATE UNIQUE INDEX statement?
The correct answer is D. To improve performance of some queries by allowing index-only access. See the full explanation below for the reasoning.
Question
What is the primary purpose for using the INCLUDE clause with a CREATE UNIQUE INDEX statement?
Options
- ATo override the limit on index key columns.
- BTo further enforce the uniqueness of index values.
- CTo combine two or more indexes to create a single unique index.
- DTo improve performance of some queries by allowing index-only access.
How the community answered
(34 responses)- A12% (4)
- B6% (2)
- C3% (1)
- D79% (27)
Community Discussion
No community discussion yet for this question.