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…

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
  82% (45)
• B
  2% (1)
• C
  5% (3)
• D
  11% (6)

No community discussion yet for this question.