IBM

C2090-320 · Question #101

Given the following table and index definitions, what type of index will be created?

The correct answer is C. Data-partitioned secondary index. See the full explanation below for the reasoning.

Question

Given the following table and index definitions, what type of index will be created?

Exhibit

C2090-320 question #101 exhibit

Options

ANon-partitioned index
BNon-partitioned secondary index
CData-partitioned secondary index
DData-partitioned partitioning index

How the community answered

(48 responses)

A
10% (5)
B
2% (1)
C
81% (39)
D
6% (3)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full C2090-320 Practice