What is the function of a foreign key in a relational database table?

IT Exam Items RepositoryCategory: Data Analytics EssentialsWhat is the function of a foreign key in a relational database table?

What is the function of a foreign key in a relational database table?

  • to define a relationship with a primary key in a different table
  • to uniquely identify a row within the table
  • to create a many-to-one relationship within the table
  • to add additional unique columns to the data table

Explanation: A foreign key is a column or a set of columns in one table that links to the primary key in another table.

Related exam: Module 7.5.2 Quiz - Introduction to Structured Queries