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
Correct Answer:
CE
对DROP和TRUNCATE分区的异步全局索引维护该特性允许延迟全局索引维护,并将其与DROP和TRUNCATE分区分离,而不会使全局索引不可用。增强包括更快的删除和截断分区操作,以及将索引维护延迟到非高峰时间的能力。
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.