A primary key is used to create a unique identifier to a record in a table. With respect to a foreign key, which of the following is the most accurate statement?

A primary key in one table is referred to as the foreign key in another table

A foreign key is never a primary key in any table

A foreign key cannot be utilized to link two tables d$.$

A primary key consists of three or more fields that have been concatenated together to form a unique key