Which three operations can be performed as multipartition operations in Oracle Database 12c? (Choose three.) 

Answer options:

A. Merge partitions of a list partitioned table.
B. Drop partitions of a list partitioned table.
C. Coalesce partitions of a hash-partitioned global index.
D. Move partitions of a range-partitioned table.
E. Rename partitions of a range partitioned table.
F. Merge partitions of a reference partitioned index.

ABF

Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple partitions. A: Merge Multiple Partitions: The new "ALTER TABLE … MERGE PARTITIONS " help merge multiple partitions or subpartitions with a single statement. When merging multiple partitions, local and global index operations and semantics for inheritance of unspecified physical attributes are the same for merging two partitions. B: Drop Multiple Partitions: The new "ALTER TABLE … DROP PARTITIONS " help drop multiple partitions or subpartitions with a single statement. Example: view plaincopy to clipboardprint? SQL> ALTER TABLE Tab_tst1 DROP PARTITIONS Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7; Table altered - SQL> Restrictions : ✑ You cant drop all partitions of the table. ✑ If the table has a single partition, you will get the error: ORA-14083: cannot drop the only partition of a partitioned.