Home » Oracle » 1z0-062 v.2 » Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?
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
Explanation/Reference:
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.
Download Printable PDF. VALID exam to help you PASS.
|
|