Exam 1z0-062 topic 1 question 103 discussion

Actual exam question from Oracle's 1z0-062

Question #: 103
Topic #: 1

[All 1z0-062 Questions]

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

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

Show Suggested Answer

Suggested Answer: 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.

by [deleted] at April 4, 2025, 9:30 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!