Which two partitioned table maintenance operations support asynchronous Global Index
Maintenance in Oracle database 12c?
A.
ALTER TABLE SPLIT PARTITION
B.
ALTER TABLE MERGE PARTITION
C.
ALTER TABLE TRUNCATE PARTITION
D.
ALTER TABLE ADD PARTITION
E.
ALTER TABLE DROP PARTITION
F.
ALTER TABLE MOVE PARTITION
Explanation:
Asynchronous Global Index Maintenance for DROP and TRUNCATE PARTITION
This feature enables global index maintenance to be delayed and decoupled from a DROP and
TRUNCATE partition without making a global index unusable. Enhancements include faster
DROP and TRUNCATE partition operations and the ability to delay index maintenance to off-peak
time.
Reference: Oracle Database VLDB and Partitioning Guide 12c
C,E
http://docs.oracle.com/cd/E16655_01/server.121/e17613/part_admin002.htm#VLDBG14107
C,E – TRUE
j/w
CE
C and E.
http://docs.oracle.com/database/121/VLDBG/part_admin002.htm
CE
global indexes can now be asynchronously maintained in Oracle 12c when a table partition is dropped or truncated. Basically, when a table partition is dropped/truncated with the UPDATE GLOBAL INDEXES clause, Oracle simply keeps track of the object numbers of those table partitions and ignores any corresponding rowids within the index during subsequent index scans. As such, these table partition operations are very fast and efficient as the global indexes are not actually maintained during the partition operation, but importantly, continue to remain in a usable state.
C,E are correct answers.