Evaluate the following statements:
CREATE TABLE purchase_orders
(pojd NUMBER(4),
po_date TIMESTAMP,
supplie_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 PURCHASEjDRDERS and PURCHASEJDRDERJTEMS tables are created with four
partitions each.
C.
Partitions of the PURCHASEJDRDERJTEMS table exist in the same tablespaces as the
partitions of the
PURCHASEJDRDERS table.
D.
The PURCHASEJDRDERJTEMS table inherits the partitioning key from the parent table by
automatically duplicating the key columns.
E.
Partition maintenance operations performed on the PURCHASEJDRDERJTEMS table are
automatically reflected in the PURCHASEjDRDERS table.