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_d3partition are correct? (Choose two)
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 of you use the UPDATE INDEX clause in the above command.