1. What is the primary purpose of a foreign key in a relational database?
- To encrypt columns containing sensitive customer information.
- To uniquely identify each row inside its own table.
- To enforce referential integrity by linking rows to another table's primary key.
- To speed up query search performance on text fields.
Hint: Foreign keys establish a relationship between tables, preventing invalid data from being inserted and ensuring linked records exist.