Test Index

Oracle Database 12c Advance Adminstration1z0-063 Test 1

Question : 35

Total: 40

CREATE TABLE purchase_orders 
 (po_idNUMBER(4), 
 po_dateTIMESTAMP, 
 supplier_idNUM8ER(6), 
 po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id)) 
 PARTITION BY RANGE(po_date) 
 (PARTITIONQ1 VALUES LESS THAN (TO_DATE('01-apr-2007','dd-mm-yyyy')), PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mm-yyyy')), PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-mm-yyyy')), PARTITIONQ4VALUESLESSTHAN(TO_DATE('Ol-jan-2008','dd-mm-yyyy'))); 
 CREATE TABLE purchase_order_items 
  (po_idNUM3ER(4)NOT NULL, 
 product_idNUMBER(6)NOT NULL, 
 unit_price NUMBER(8,2), 
 quantity NUMBER(8), 
 CONSTRAINT po_items_f k 
 FOREIGN KEY(po_id)REFERENCES purchase_orders(po_id)) 
 PARTITION BY REFERENCE(po_items_fk);

Which two statements are true? (Choose two.)

Partitions of purchase_order_items are assigned unique names based on a sequence.
The purchase_orders and purchase_order_items tables are created with four partition each.
purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.
The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.
Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint

Validate

Go to Question:

Prev Question

Next Question