Which three operations can be performed as multipartition operations in Oracle?

The correct answer is A. Merge partitions of a list partitioned table B. Drop partitions of a list partitioned table F. Merge partitions of a reference partitioned index. Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple A:Merge Multiple Partitions: The new "ALTER TABLE ... MERGE PARTITIONS " help merge multiple partitions or subpartitions with a single statement. When merging multiple partitions…

New Features for Manageability

Question

Options

AMerge partitions of a list partitioned table
BDrop partitions of a list partitioned table
CCoalesce partitions of a hash-partitioned global index.
DMove partitions of a range-partitioned table
ERename partitions of a range partitioned table
FMerge partitions of a reference partitioned index

How the community answered

(30 responses)

A
77% (23)
C
3% (1)
D
7% (2)
E
13% (4)

Explanation

Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple 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. view plaincopy to clipboardprint? SQL> ALTER TABLE Tab_tst1 DROP PARTITIONS Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7; - You can't 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.

Topics

#multipartition operations#partition management#list partitioned table#reference partitioned index

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice