Question: what is the difference between unique index and non-unique index in oracle?
Answer: A unique index ensures that no two rows of a table have duplicate values in the indexed column (or columns). A non-unique index does not impose this restriction on the indexed column's values.