Scenario: You are working on a project where data integrity is crucial. A new table is being designed to store employee information. Which constraint would you use to ensure that the "EmployeeID" column in this table always contains unique values?

  • Check Constraint
  • Foreign Key Constraint
  • Primary Key Constraint
  • Unique Constraint
In this scenario, to ensure that the "EmployeeID" column always contains unique values, you would use a Primary Key Constraint. This constraint uniquely identifies each record in the table, preventing duplicate entries and ensuring data integrity, especially in scenarios where the column is intended to serve as an identifier.
Add your answer
Loading...

Leave a comment

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