Evaluate the following CREATE TABLE command:CREATE TABLE order_item -(order_id NUMBER(3),item_id NUMBER(2),qty NUMBER(4)
Posted: Wed Jun 07, 2023 6:11 am
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 -(CREATE INDEX ord_itm_idxON order_item(order_id,item_id)));Which statement is true regarding the above SOL statement?
A. It would execute successfully and only ORD_ITM_IDX index would be created.
B. It would give an error because the USING INDEX clause cannot be used on a composite primary key.
C. It would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID_PK would be created.
D. It would give an error because the USING INDEX clause is not permitted in the CREATE TABLE command.
A. It would execute successfully and only ORD_ITM_IDX index would be created.
B. It would give an error because the USING INDEX clause cannot be used on a composite primary key.
C. It would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID_PK would be created.
D. It would give an error because the USING INDEX clause is not permitted in the CREATE TABLE command.