Which of the following best describes the purpose of a foreign key?
A) To ensure that each row in the table is unique
B) To create the relationship between two tables
C) To provide business information
D) To support business processes across the organization

Question

Quizplus · Accepted Answer

A foreign key is used to create a relationship between two tables in a database. It helps maintain referential integrity, which ensures that the data in both tables remains accurate and consistent. By using a foreign key, data can be easily retrieved from both tables using SQL queries.

Which of the Following Best Describes the Purpose of a Foreign