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.