Which type of data integrity constraint ensures that a foreign key in one table corresponds to a primary key in another table?
- Data consistency constraint
- Data validation constraint
- Entity integrity constraint
- Referential integrity constraint
Referential integrity constraint ensures that values in one column (or a group of columns) in one table correspond to values in another table's column(s) with a primary key constraint.
Loading...
Related Quiz
- Which step of query optimization involves choosing the most efficient execution plan for a SQL query?
- Which security aspect ensures that only authorized users can access specific data within a database?
- What is the significance of test environment setup and configuration in database testing?
- Which keyword is used to specify the action to be taken when an error occurs in a SQL query?
- Which metric is commonly used to measure the effectiveness of test execution?