Oracle Exam 1Z0-071 Topic 16 Question 63 Discussion

Examine this statement:

CREATE TABTE orders

(sarial_no NUMBER UNIQUE,

order_id NUMBER PRIMARY KEY ,

order_date DATE NOT NULL,

status VARCHAR2 (10) CHECK (status IN ('CREDIT', 'CASH')),

product_id NUMBER REFERENCES products (product_id),

order_ total NUMBER);

On which two columns of the table will an index be created automatically?