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))…

Question

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 purchase_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

• A
  11% (3)
• B
  70% (19)
• D
  4% (1)
• E
  15% (4)

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.

No community discussion yet for this question.