Evaluate the following statements:CREATE TABLE purchase_orders -(pojd NUMBER(4),po_date TIMESTAMP,supplie_id NUMBER(6),p
Posted: Wed Jun 07, 2023 6:11 am
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.
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.