Oracle
1Z0-063 · Question #168
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))…
The correct answer is C. purchase_order_items table partitions exist in the same tablespaces as the purchase_orders E. Partition maintenance operations on the purchase_order_items table require disabling the foreign. See the full explanation below for the reasoning.
Question
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?
Options
- APartitions of purchase_order_items are assigned unique names based on a sequence.
- BThe purchase_orders and purchase_order_items tables are created with four partition each.
- Cpurchase_order_items table partitions exist in the same tablespaces as the purchase_orders
- DThe purckase_order_:teks table inherits the partitioning key by duplicating the key columns from
- EPartition maintenance operations on the purchase_order_items table require disabling the foreign
How the community answered
(48 responses)- A17% (8)
- B2% (1)
- C75% (36)
- D6% (3)
Community Discussion
No community discussion yet for this question.