What is the difference between a primary key and a foreign key?

Question

Accepted Answer

Primary key uniquely identifies a record in a table, while foreign key refers to a field in another table.

Primary key is used to enforce data integrity and ensure uniqueness of records.
Foreign key is used to establish a relationship between two tables.
A table can have only one primary key, but multiple foreign keys.
Example: CustomerID in Orders table is a foreign key that references the Customer table's primary key.
Primary key is denoted by a key symbol, while foreign key is denoted by a relationship symbol.

Accepted Answer

A primary key is a unique identifier  for each record in a table a foreign key establishes relationship between table by referencing the primary key of another table ensures uniqueness and data integrity within a single table

Accepted Answer

A primary key is used to ensure data in the specific column is unique. A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It uniquely identifies a record in the relational database table. .Only one primary key is allowed in a table

What is the difference between a primary key and a foreign key?

Top Cognizant GenC interview questions & answers

Top HR questions asked in Cognizant GenC