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…

Question

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.

• A
  78% (14)
• B
  6% (1)
• C
  6% (1)
• D
  11% (2)

No community discussion yet for this question.