（228）Evaluate the following 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_price 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);

What are the two consequences of the above statements?(Choose two.)

A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.

B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.

C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.

D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.

E. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

ITPub博客

Oracle 11G OCP 1Z0-053 228