In a relational database, what is used to ensure data integrity across multiple tables?
- Primary Key
- Foreign Key
- Index
- Trigger
A Foreign Key is used in a relational database to ensure data integrity by creating a link between tables. It enforces referential integrity, ensuring that values in one table match values in another. Primary Keys are used to uniquely identify records in a table, not to maintain integrity across tables. Indexes and Triggers serve different purposes.
Loading...
Related Quiz
- Regularization techniques add a _______ to the loss function to constrain the magnitude of the model parameters.
- What is the primary purpose of using activation functions in neural networks?
- When normalizing a database in SQL, separating data into two tables and creating a new primary and foreign key relationship is part of the _______ normal form.
- Which curve plots the true positive rate against the false positive rate for different threshold values of a classification problem?
- Apache Spark's core data structure, used for distributed data processing, is called what?