Scenario: An application requires that a certain column in a DB2 table always contains a valid date value. Which constraint should be applied to enforce this rule?
- Check Constraint
- Foreign Key Constraint
- Primary Key Constraint
- Unique Constraint
A Check Constraint allows the specification of a condition that each row in the table must satisfy. In this scenario, a Check Constraint can be used to ensure that the column always contains valid date values by defining a condition to validate dates.
Loading...
Related Quiz
- How can denormalization lead to potential data inconsistency issues?
- Which utility is commonly used for database backup and recovery tasks in DB2?
- Having too many indexes on a table in DB2 can lead to increased ________ overhead.
- Range partitioning in DB2 divides data based on ________.
- The VARIANCE() function in DB2 returns the ________ of the values in a column.