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?
Submit