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

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…

New Features for Performance

Question

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

How the community answered

(23 responses)

A
9% (2)
B
4% (1)
C
74% (17)
D
13% (3)

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.

Topics

#asynchronous global index maintenance#partition maintenance#DROP PARTITION#TRUNCATE PARTITION

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice