DBS_IND_PARTITIONS.ORPHANED_ENTRIES contains YES for several index partitions. This is due to the use of deferred index maintenance. Which three methods will remove the orphaned keys? (Choose three.)

ALTER INDEX REBUILD PARTITION physically reconstructs a local index partition from the base table data, discarding all orphaned entries that accumulated during deferred partition maintenance operations such as DROP PARTITION or TRUNCATE PARTITION. Each affected local index partition must be rebuilt individually since local indexes are partition-aligned.

DBMS_PART.CLEANUP_GIDX is an Oracle-supplied procedure that scans all global indexes on partitioned tables and removes orphaned keys in a single invocation, making it more efficient than issuing individual DDL statements per partition. It is specifically designed to handle the orphaned entry cleanup that deferred global index maintenance defers.

ALTER INDEX COALESCE PARTITION CLEANUP on a global index partition merges leaf blocks and explicitly purges orphaned row entries left by deferred maintenance, and is the supported DDL method for targeted cleanup of individual global index partitions. It is distinct from a standard COALESCE PARTITION, which does not remove orphaned entries.

DBMS_PART.CLEANUP_CIDX is not a valid Oracle-supplied procedure; the correct package procedure for cleaning orphaned global index entries is DBMS_PART.CLEANUP_GIDX, making this option non-functional.

ALTER INDEX COALESCE PARTITION CLEANUP is intended for global index partitions to remove orphaned keys, not for local index partitions; applying it to local index partitions will not correctly address deferred-maintenance orphaned entries.

While ALTER INDEX REBUILD PARTITION can reconstruct a global index partition, it is not the recommended or efficient mechanism for orphaned key removal in global indexes - COALESCE PARTITION CLEANUP or DBMS_PART.CLEANUP_GIDX are the correct approaches for global index orphan cleanup.