【第15題】【063題庫】2019年OCP12c認證1Z0-063考試題庫大全
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢OCP 12c考試考3科，分別是071、062、063，之前071和062都已經做過解析，這里開始063題庫解析，希望對考063的同學有幫助，順利通過063考試。
OCP解析公開課時間：【每周五晚8點】
OCP解析公開課地址：http://ke.qq.com/course/326223
OCP解析群資料分享：1015267481 驗證：ocp
-------------------------------------------------------
15題、Evaluate these statements:
CREATE TABLE purchase_orders
(po_id NUMBER(4),
po_date TIMESTAMP,
supplier_id NUMBER(6),
po_total NUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITION BY RANGE(po_date)
(PARTITION Q1 VALUES LESS THAN (TO_DATE('01-apr-2007','dd-mon-yyyy')),
PARTITION Q2 VALUES LESS THAN (TO_DATE('01-jul-2007','dd-mon-yyyy')),
PARTITION Q3 VALUES LESS THAN (TO_DATE('01-oct-2007','dd-mon-yyyy')),
PARTITION Q4 VALUES LESS THAN (TO_DATE('01-jan-2008','dd-mon-yyyy' )));
CREATE TABLE purchase_order_items
(po_id NUMBER(4)NOT NULL,
product_id NUMBER(6) NOT NULL,
unit_prlce NUMBER(8,2),
quantity NUMBER(8),
CONSTRAINT po_items_fk
FOREIGN KEY(po_id) REFERENCES purchase_orders (po_id))
PARTITION BY REFERENCE(po_items_fk); .
Which two statements are true?
A. Partitions of purchase_order_items are assigned unique names based on a sequence.
B. The purchase_orders and purchase_order_items tables are created with four partition each.
C. purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.
D. The purckase_order_items table inherits the partitioning key by duplicating the key columns from the parent table.
E. Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint.
Answer: B BC
(由于是引用分區，所以子表無法對分區進行維護，只有在父表添加和刪除分區時，子表也會自動的添加和刪除分區，所以對于引用分區表，不能單獨對子表的分區進行操作)
