Oracle
1Z0-050 · Question #50
1Z0-050 Question #50: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-050 to reveal the answer and full explanation for question #50. The question stem and answer options stay visible for context.
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
Unlock 1Z0-050 to see the answer
You've previewed enough free 1Z0-050 questions. Unlock 1Z0-050 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.