Which two partitioned table maintenance operations support asynchronous Global Index
Maintenance in Oracle database 12c?
A.
ALTER TABLE DROP PARTITION
B.
ALTER TABLE ADD PARTITION
C.
ALTER TABLE MOVE PARTITION
D.
ALTER TABLE MERGE PARTITION
E.
ALTER TABLE SPLIT PARTITION
F.
ALTER TABLE TRUNCATE PARTITION
AF
Rather than just follow Patty’s usual lead in confirming the answers given by the site, a link from Oracle to confirm the answer:
https://docs.oracle.com/database/121/VLDBG/GUID-087B87A6-959A-40C6-82AF-36E401FD089B.htm#VLDBG14107
“The partition maintenance operations DROP PARTITION and TRUNCATE PARTITION are optimized by making the index maintenance for metadata only.
Asynchronous global index maintenance for DROP and TRUNCATE is performed by default; however, the UPDATE INDEXES clause is still required for backward compatibility.”
Thus, the answer given is correct.