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?
A.
It would give an error because the USING INDEX clause is not permitted in the CREATE
TABLE command.
B.
It would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID_PK
would be created.
C.
It would execute successfully and only ORD_ITM_IDX index would be created.
D.
It would give an error because the USING INDEX clause cannot be used on a composite
primary key.