Evaluate the following CREATE TABLE command:
Which statement is true regarding the above SQL 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,
C. It would execute successfully and two indexes ORD_ITM_IDXand ORD_ITM_IDX PK would be created
D. It would give an error because the USING INDEX is not permitted in the CRETAE TABLE command.
SQL> 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_idx
on order_item(order_id, item_id))); 2 3 4 5 6 7 8 9
Table created.
SQL> SELECT INDEX_NAME, TABLE_NAME FROM DBA_INDEXES WHERE TABLE_NAME = ‘ORDER_ITEM’ AND OWNER = ‘SYS’
2 ;
INDEX_NAME TABLE_NAME
————————- ————————
ORD_ITM_IDX ORDER_ITEM
C
A, you wrongthinker