IBM
C2090-610 · Question #33
Which is NOT a valid reason for creating an index?
The correct answer is C. To order the columns of a table in ascending or descending sequence according to values in a. See the full explanation below for the reasoning.
Question
Which is NOT a valid reason for creating an index?
Options
- ATo allow queries to run more efficiently.
- BTo enforce constraints such as uniqueness on index keys.
- CTo order the columns of a table in ascending or descending sequence according to values in a
- DTo order the rows of a table in ascending or descending sequence according to the values in a
How the community answered
(49 responses)- A16% (8)
- B4% (2)
- C71% (35)
- D8% (4)
Community Discussion
No community discussion yet for this question.