Scenario: A DBA wants to ensure that no duplicate values are allowed in a specific column of a DB2 table. Which type of constraint should they apply?

  • Check Constraint
  • Foreign Key Constraint
  • Primary Key Constraint
  • Unique Constraint
A Unique Constraint ensures that all values in a column are unique and does not allow duplicate entries. This constraint is suitable for enforcing the uniqueness of values in a column without establishing a relationship with another table. 
Add your answer
Loading...

Leave a comment

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