READ Free Dumps For Oracle- 1z0-050
| Question ID 5981 | Evaluate the following statements: CREATE TABLE purchase_orders (pojd NUMBER(4),
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 | Partitions of PURCHASE_ORDER_ITEMS have system-generated names. | |
| Option B | Both PURCHASEjDRDERS and PURCHASEJDRDERJTEMS tables are created with four partitions each. | |
| Option C | Partitions of the PURCHASEJDRDERJTEMS table exist in the same tablespaces as the partitions of the PURCHASEJDRDERS table. | |
| Option D | The PURCHASEJDRDERJTEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns. | |
| Option E | Partition maintenance operations performed on the PURCHASEJDRDERJTEMS table are automatically reflected in the PURCHASEjDRDERS table. | |
| Correct Answer | B,C |
po_date TIMESTAMP,
supplie_id NUMBER(6),| Question ID 5982 | Which statements are true regarding SecureFile LOBs? (Choose all that apply.) |
| Option A | The amount of undo retained is user controlled. |
| Option B | SecureFile LOBs can be used only for nonpartitioned tables. |
| Option C | Fragmentation is minimized by using variable-sized chunks dynamically. |
| Option D | SecureFile encryption allows for random reads and writes of the encrypted data. |
| Option E | It automatically detects duplicate LOB data and conserves space by storing only one copy. |
| Correct Answer | C,D |