Oracle

1Z0-034 · Question #92

In which two situations would you rebuild an index using the ALTER INDEX----- REBUILD command?

The correct answer is B. to change index storage options D. to move the index to another tablespace. See the full explanation below for the reasoning.

Question

In which two situations would you rebuild an index using the ALTER INDEX----- REBUILD command?

Options

Ato change a unique index into a non-unique index
Bto change index storage options
Cto enable index monitoring
Dto move the index to another tablespace
Eto improve performance of an INDEX CLUSTER

How the community answered

(40 responses)

A
13% (5)
B
78% (31)
C
3% (1)
E
8% (3)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-034 Practice