Oracle
1Z0-034 · Question #43
1Z0-034 Question #43: Real Exam Question with Answer & Explanation
The correct answer is B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the. See the full explanation below for the reasoning.
Question
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.)
Options
- APartitions of PURCHASE_ORDER_ITEMS have system-generated names.
- BBoth PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four
- CPartitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the
- DThe PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by
- EPartition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are
Community Discussion
No community discussion yet for this question.