Valid 1z0-067 Dumps shared by ExamDiscuss.com for Helping Passing 1z0-067 Exam! ExamDiscuss.com now offer the newest 1z0-067 exam dumps, the ExamDiscuss.com 1z0-067 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1z0-067 dumps with Test Engine here:
Evaluate these statements: CREATE TABLE purchase_orders (po_idNUMBER(4), po_dateTIMESTAMP, supplier_idNUM8ER(6), po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id)) PARTITIONBYRANGE(po_date) (PARTITIONQ1 VALUESLESSTHAN (TO_DATE('01-apr-2007','dd-mon-yyyy')), PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mon-yyyy')), PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-non-yyyy')), PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-non-yyyy' ))); CREATETABLEpurchase_order_items (po_idNUM3ER(4)NOTNULL, product_idNUMBER(6)NOTNULL, unit_prlceNUMBER(8,2), quantity NUMBER(8), CONSTRAINTpo_items_f k FOREIGNKEY(po_id)REFERENCESpurchase_orders(po_id) ) PARTITIONBYREFERENCE(po_items_fk); Which two statements are true?
Correct Answer: B,C
Explanation/Reference: Explanation: The following example creates a parent table orders which is range-partitioned on order_date. The reference-partitioned child table order_items is created with four partitions, Q1_2005, Q2_2005, Q3_2005, and Q4_2005, where each partition contains the order_items rows corresponding to orders in the respective parent partition. Partitions of a reference-partitioned table will collocate with the corresponding partition of the parent table, if no explicit tablespace is specified for the reference-partitioned table's partition. The partitions of a reference-partitioned table can be named. If a partition is not explicitly named, then it will inherit its name from the corresponding partition in the parent table. http://docs.oracle.com/cd/B28359_01/server.111/b32024/part_admin.htm#BAJDDEEC