Marty, a database administrator, has added a foreign key to a table in a database. Which of the following describes the purpose of a foreign key?

Question

answer

For one database to reference another database.

To allow the storage of unstructured data.

For one table to reference records in another table.

To provide a way to distinguish records within a table.

Answer 1

The correct answer is:

For one table to reference records in another table.

A foreign key is a field or collection of fields in one table that uniquely identifies a row of another table. It creates a relationship between the two tables and helps maintain referential integrity in the database.