1Z0-040 practice - PrepKeys

Q5 Multiple choice

You have a partitioned table called employee in USERS1 tablespace.

You executed the following statement on the partition emp_d3 of the table: ALTER TABLE employee MOVE PARTITION emp_d3 TABLESPACE USERS2; Which two statements regarding the local index partition on the emp_d3 partition are correct? (Choose two.)

Select all that apply.

A
The local index partition cannot be rebuilt.
B
The local index partition remains USABLE .
C
The local index partition becomes UNUSABLE .
D
The local index partition must be dropped and re-created manually.
E
The local index partition gets dropped automatically when you move a partition of the table.
F
The local index partition will be rebuilt automatically if you use the UPDATE INDEX clause in the above command.