第103題-OCP認證062考試題庫2019最新考題解析
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢2018年的時候，OCP 11g考試題庫大更新，052 053出現了很多新題，
2019年，11g即將停考的前期，Oracle又出現了一次大變動，12c出現了很多新題，比如062 063題庫大更新
OCP解析公開課時間：【每周五晚8點】
OCP解析公開課地址：http://ke.qq.com/course/326223
OCP解析群資料分享：1015267481 驗證：ocp
-------------------------------------------------------
QUESTION 103
Which three operations can be performed as multipartition operations in Oracle?
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
Correct 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 can't drop all partitions of t he table.
- If t he table has a single partition, you will get the error: ORA-14083: cannot drop the only partition of a partitioned.
F：合并引用分區索引的分區)
