in both cases oracle restricts from inserting duplicate values for the column on which unique constraint/index is created