Hi,
I am trying to prepare OCE certification, i searched some examples of exams in the internet, i found this example which i didn't understand:
create table order_item
(order_id number(3),
item_id number(2),
qty number(4),
constraint ord_item_pk primary key(order_id,item_id)
using index (create index ord_itm_idx on order_item(order_id,item_id)));
in the correction, it is mentionned that the correct option is:
it would execute successfully and only ord_itm_idx would be created but when i excuted the instruction on sql developer i found that both the table and the index where created ( and not only the index as it was mentionned).