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.
Loading...
Related Quiz
- Triggers in DB2 are activated by ________ events.
- What is the primary purpose of the LOAD utility in DB2?
- DB2 stored procedures can be written in ________.
- In what scenarios would an organization opt for a specific edition of DB2 over others?
- What is the behavior of the STDDEV() function in DB2 when applied to a column with NULL values?