Evaluate the following CREATE TABLE command:
CREATE TABLE order_item
PRIMARY KEY (order_id,item_id)
(CREATE INDEX ord_itm_idx
Which statement is true regarding the above SQL statement?
It would execute successfully and only ORD_ITM_IDX index would be created.
It would give an error because the USING INDEX clause cannot be used on a composite primary key.
It would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID_PK would be created.
It would give an error because the USING INDEX clause is not permitted in the CREATE TABLE command.