IBM

C2090-312 · Question #109

When is changing an index from non-clustering to clustering NOT allowed?

The correct answer is C. If the new clustering index is for a table that uses hash organization. See the full explanation below for the reasoning.

Question

When is changing an index from non-clustering to clustering NOT allowed?

Options

AIf the table space is defined as member cluster.
BIf the data is not ordered by the new clustering index.
CIf the new clustering index is for a table that uses hash organization.
DIf the new clustering index OBID is greater than the old clustering index OBID.

How the community answered

(32 responses)

A
6% (2)
B
13% (4)
C
78% (25)
D
3% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full C2090-312 Practice