|
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.