1Z0-071 Question #90: Real Exam Question with Answer & Explanation

The correct answer is C. ALTER TABLE TRUNCATE PARTITION E. ALTER TABLE DROP PARTITION. 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 opera

Question

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

Options

AALTER TABLE SPLIT PARTITION
BALTER TABLE MERGE PARTITION
CALTER TABLE TRUNCATE PARTITION
DALTER TABLE ADD PARTITION
EALTER TABLE DROP PARTITION
FALTER 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.

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice