Which type of constraint ensures that a foreign key in one table references a primary key in another table?
- Foreign key constraint
- Primary key constraint
- Referential integrity constraint
- Unique constraint
Referential integrity constraint ensures that a foreign key in one table references a primary key in another table. It maintains the consistency and integrity of the data by enforcing relationships between tables. This constraint prevents actions that would violate these relationships, such as deleting a record with a referenced foreign key.
Loading...
Related Quiz
- To optimize database performance, it's important to use monitoring and profiling tools to identify ____________.
- Database testing tools may provide ____________ reporting to track test execution and results.
- In role-based access control (RBAC), permissions are assigned to ____________ rather than individual users.
- What is the significance of testing database tables during the development phase?
- What does "ETL" stand for in the context of data processing?