1Z0-040 practice - PrepKeys

Q1 Multiple choice

You executed the following command on a partitioned table sales_test : ALTER TABLE sales_test MOVE PARTITION s_q3 TABLESPACE users2 UPDATE INDEXES (sales_test_ix (PARTITION s_q3

TABLESPACE example)); Which two statements regarding the above command are correct? (Choose
two.)

Select all that apply.

A
The sales_test_ix index will be rebuilt automatically.
B
The UPDATE INDEXES clause is optional in the above command.
C
The UPDATE INDEXES clause is used only with the MOVE operation on a partition.
D
The UPDATE INDEXES clause without storage attributes will rebuild the index in the SYSTEM tablespace.