In DB2, a UNIQUE constraint ensures that ________.

  • Data types are consistent across tables.
  • Each value in a column or set of columns is unique.
  • Null values are allowed in specified columns.
  • The table has a primary key constraint.
The UNIQUE constraint in DB2 ensures that each value in a specified column or set of columns is unique across all the rows in the table. It prevents duplicate values from being entered into the table. 
Add your answer
Loading...

Leave a comment

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