The FOREIGN KEY constraint in DB2 enforces ________.
- Consistency of data types across tables.
- Referential integrity between tables.
- The presence of NULL values in specified columns.
- Unique values within a column.
The FOREIGN KEY constraint in DB2 enforces referential integrity between tables by ensuring that values in a column (or combination of columns) in one table exist as values in another table's referenced column (typically the primary key).
Loading...
Related Quiz
- Which normal form requires all determinants to be candidate keys?
- Which encryption algorithm is commonly used to secure data in transit in DB2?
- Which aggregation function in DB2 is used to calculate the average value of a numeric column?
- Control Center is primarily used for ________ of DB2 databases.
- How does Visual Explain aid in query optimization in DB2?