What are the two consequences of the above statements? (Choose two.)

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

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

A.
Partitions of PURCHASE_ORDER_ITEMS have system-generated names.

B.
Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.

C.
Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.

D.
The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.

E.
Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Magwai

Magwai

http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_7002.htm#SQLRF54578
reference_partitioning
Use this clause to partition the table by reference. Partitioning by reference is a method of equipartitioning the table being created (the child table) by a referential constraint to an existing partitioned table (the parent table). When you partition a table by reference, partition maintenance operations subsequently performed on the parent table automatically cascade to the child table. Therefore, you cannot perform partition maintenance operations on a reference-partitioned table directly.