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.
Loading...
Related Quiz
- Control Center is primarily used for ________ of DB2 databases.
- In addition to IBM Data Studio, which other IDEs are commonly used for DB2 development and administration?
- What is data integrity in DB2?
- The FOREIGN KEY constraint in DB2 enforces ________.
- The primary purpose of an Integrated Development Environment (IDE) like IBM Data Studio is to enhance ________ productivity.