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.
Evaluate the following CREATE TABLE command:CREATE TABLE order_item -(order_id NUMBER(3),item_id NUMBER(2),qty NUMBER(4)
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am