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?
A.
Partitions of purchase_order_items are assigned unique names based on a sequence.
B.
The purchase_orders and purchase_order_items tables are created with four
partitioneach.
C.
purchase_order_items table partitions exist in the same tablespaces as the
purchase_orders table partitions.
D.
The purckase_order_:teks table inherits the partitioning key by duplicating the key
columns from the parent table.
E.
Partition maintenance operations on the purchase_order_items table require disabling the
foreign key constraint.
Correct answer is B and C (TESTED)
C for sure. B i feel confused and not sure. Thanks Vonpire however.
B, C
CE
http://docs.oracle.com/cd/B28359_01/server.111/b32024/part_admin.htm#BAJDDEEC
I meant BC:
http://docs.oracle.com/cd/B28359_01/server.111/b32024/part_admin.htm#BAJDDEEC
BC
http://docs.oracle.com/cd/B28359_01/server.111/b32024/part_admin.htm#BAJDDEEC
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. =====> B
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. ===> C
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 ===> NOT A
BC
https://docs.oracle.com/cd/E16338_01/server.112/b56316/part_admin001.htm#BAJDDEEC
BC