AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-050





Question ID 1829

Evaluate the following statements:
CREATE TABLE purchase_orders (pojd NUMBER(4),
po_date TIMESTAMP,
 
supplie_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.)
 

Option A

A.    Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
 

Option B

B.    Both PURCHASEjDRDERS and PURCHASEJDRDERJTEMS tables are created with four partitions each.

 

Option C

C.    Partitions of the PURCHASEJDRDERJTEMS table exist in the same tablespaces as the partitions of the
PURCHASEJDRDERS table.
 

Option D

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

Option E

E.    Partition maintenance operations performed on the PURCHASEJDRDERJTEMS table are automatically reflected in the PURCHASEjDRDERS table.

Correct Answer B,C
Explanation


Question ID 1830

Which statements are true regarding SecureFile LOBs? (Choose all that apply.)

Option A

A.    The amount of undo retained is user controlled.
 

Option B

B.    SecureFile LOBs can be used only for nonpartitioned tables.

 

Option C

C.    Fragmentation is minimized by using variable-sized chunks dynamically.
 

Option D

D.    SecureFile encryption allows for random reads and writes of the encrypted data.
 

Option E

E.    It automatically detects duplicate LOB data and conserves space by storing only one copy.

Correct Answer C,D
Explanation

Send email to admin@getfreedumps for new dumps request!!!