View the Exhibit and examine the structure of ORD and ORD_ITEMS tables. In the ORD
table, the PRIMARY KEY is ORD_NO and in the ORD_ITEMS tables the composite
PRIMARY KEY is (ORD_NO, ITEM_NO). Which two CREATE INDEX statements are valid?
(Choose two.)
A.
CREATE INDEX ord_idx ON ord,ord_items(ord_no, ord_date,qty);
B.
CREATE INDEX ord_idx ON ord(ord_no);
C.
CREATE INDEX ord_idx ON ord_items(ord_no);
D.
CREATE INDEX ord_idx ON ord_items(item_no);