OCP 11gÊÔÌâ½âÎö£º1Z0-051-047Ìâ

OCP 11gÊÔÌâ½âÎö£º1Z0-051-047Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

47. View the Exhibit and examine the structure of ORD and ORD_ITEMS tables.

The ORD_NO column is PRIMARY KEY in the ORD table and the ORD_NO and ITEM_NO columns are

composite PRIMARY KEY in the ORD_ITEMS table.

Which two CREATE INDEX statements are valid? (Choose two.)

A. CREATE INDEX ord_idx1

ON ord(ord_no);

B. CREATE INDEX ord_idx2

ON ord_items(ord_no);

C. CREATE INDEX ord_idx3

ON ord_items(item_no);

D. CREATE INDEX ord_idx4

ON ord,ord_items(ord_no, ord_date,qty);

Answer: BC