Examine this statement:CREATE TABTE orders(sarial_no NUMBER UNIQUE,order_id NUMBER PRIMARY KEY ,order_date DATE NOT NULL,status VARCHAR2...

An index is created automatically on columns that are defined with a UNIQUE constraint and a PRIMARY KEY constraint.

A. True. Since the serial_no column is defined with a UNIQUE constraint, Oracle will automatically create an index for this column.

E. True. The order_id column is defined with a PRIMARY KEY constraint, and Oracle automatically creates a unique index on the primary key column.