READ Free Dumps For Oracle- 1z0-047
| Question ID 6437 | Evaluate the following CREATE TABLE command: CREATE TABLE order_item (order_id NUMBER(3), item_id NUMBER(2), qty NUMBER(4), CONSTRAINT ord_itm_id_pk PRIMARY KEY (order_id,item_id) USING INDEX (CREATE INDEX ord_itm_idx ON order_item(order_id,item_id))); Which statement is true regarding the above SQL statement? |
| Option A | It would execute successfully and only ORD_ITM_IDX index would be created |
| Option B | . It would give an error because the USING INDEX clause cannot be used on a composite primary key. |
| Option C | . It would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID_PK would be created |
| Option D | . It would give an error because the USING INDEX clause is not permitted in the CREATE TABLE command. |
| Correct Answer | A |
| Question ID 6439 | Which two statements are true about sequences created in a single instance database? (Choose two.) |
| Option A | . The numbers generated by a sequence can be used only for one table. |
| Option B | . DELETE would remove a sequence from the database. |
| Option C | . CURRVAL is used to refer to the last sequence number that has been generated |
| Option D | When the MAXVALUE limit for a sequence is reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement |
| Option E | When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted. |
| Correct Answer | CD |