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(‘1-apr-2007′,’d-mon-yyyy’),
PARTITION Q2 VALUES LESS THAN (TO_DATE(‘1-jul-2007′,’d-mon-yyyy’),
PARTITION Q3 VALUES LESS THAN (TO_DATE(‘1-oct-2007′,’d-mon-yyyy’),
PARTITION Q4 VALUES LESS THAN (TO_DATE(‘1-jan-2008′,’d-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.