1Z0-050 · Question #50
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…
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 partitions. 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 partitions
- 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
How the community answered
(43 responses)- A14% (6)
- B77% (33)
- D7% (3)
- E2% (1)
Community Discussion
No community discussion yet for this question.