which columns would an index be automatically created when you execute the above SQL statement?

Examine the SQL statement that creates ORDERS table: CREATE TABLE orders
(SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL,
STATUS VARCHAR2(10) CHECK (status IN (‘CREDIT’, ‘CASH’)), PROD_ID NUMBER
REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY
(order_id, order_date)); For which columns would an index be automatically created when
you execute the above SQL statement? (Choose two.)

A.
SER_NO

B.
ORDER_ID

C.
STATUS

D.
PROD_ID

E.
ORD_TOTAL

F.
composite index on ORDER_ID and ORDER_DATE