Oracle
1Z0-047 · Question #39
1Z0-047 Question #39: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #39. The question stem and answer options stay visible for context.
Question
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 jtem_id) USING INDEX (CREATE INDEX ord_itm_idx ON order_item(order_id item_id))); Which statement is true regarding the above SOL statement?
Options
- AIt would execute successfully and only ORD_ITM_IDX index would be created.
- BIt would give an error because the USING INDEX clause cannot be used on a composite primary key.
- CIt would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID_PK would be created.
- DIt would give an error because the USING INDEX clause is not permitted in the CREATE TABLE command.
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.