Which type of constraint ensures that each value in a column is unique?

  • Check constraint
  • Default constraint
  • Foreign key constraint
  • Unique constraint
The unique constraint in DB2 ensures that each value in a column is unique and does not allow duplicate values. This constraint is often used to enforce entity integrity by ensuring that no two rows in a table have the same value for a specified column or combination of columns. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *