nerdexam
IBM

A2090-614 · Question #93

Which statement about partitioned indexes is FALSE?

The correct answer is D. When attaching new partitions, the SET INTEGRITY statement must be run before data in the. See the full explanation below for the reasoning.

Question

Which statement about partitioned indexes is FALSE?

Options

  • ABoth system-and user-generated indexes can be partitioned.
  • BEach index partition contains references only to data in its corresponding data partition.
  • CA partitioned index is made up of a set of index partitions, each of which contains the index
  • DWhen attaching new partitions, the SET INTEGRITY statement must be run before data in the

How the community answered

(23 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    13% (3)
  • D
    78% (18)

Community Discussion

No community discussion yet for this question.

Full A2090-614 Practice