Scenario: A developer needs to create a relationship between two tables in DB2, ensuring referential integrity. Which constraint should they implement?
- Check Constraint
- Foreign Key Constraint
- Primary Key Constraint
- Unique Constraint
A Foreign Key Constraint establishes a relationship between two tables, ensuring referential integrity by enforcing that values in one table must exist in another table's specified column. This constraint maintains the integrity of the relationship between tables.
Loading...
Related Quiz
- Which type of constraint in DB2 ensures data integrity by enforcing uniqueness?
- How does DB2 handle concurrent transactions?
- In DB2, what does the FOREIGN KEY constraint enforce?
- The primary purpose of an Integrated Development Environment (IDE) like IBM Data Studio is to enhance ________ productivity.
- How does DB2 integrate with other technologies?