Explanation:
Index exist for UNIQUE and PRIMARY KEY constraints Incorrect answer :
2: ORDER_ID is neither UNIQUE nor PRIMARY KEY
3: STATUS is neither UNIQUE nor PRIMARY KEY
4: PROD_ID is neither UNIQUE nor PRIMARY KEY
5: ORD_TOTAL is neither UNIQUE nor PRIMARY KEY
Reference:
Introduction to Oracle9i : SQL, Oracle University Study Guide, 10-15

---