The CHECK constraint in DB2 allows for ________.
- Creating indexes on specified columns.
- Enforcing a condition on column values.
- Ensuring referential integrity between tables.
- Specifying default values for columns.
The CHECK constraint in DB2 allows you to enforce a condition on the values entered into a column or set of columns. It ensures that only values meeting the specified condition are allowed to be inserted or updated.
Loading...
Related Quiz
- Scenario: A DBA is optimizing a query in DB2 that involves multiple joins and subqueries. The query performance is slow. What strategies can the DBA employ to improve the query performance?
- DB2 manages deadlock situations by employing ________.
- The choice of DB2 edition depends on the organization's ________.
- Scenario: A DB2 developer needs to extract specific information from an XML document stored in the database. Which feature of DB2 can they use for this purpose?
- Database Services in DB2's architecture are responsible for ________.