Q: Which of the following statements correctly describes primary and foreign keys? Select all that apply.
or
Q: Which of the following summaries of main and foreign keys is accurate? Choose every option that pertains.
- A foreign key references a column or a group of columns in which each row uniquely identifies each record in the table.
- A primary key forms connections because it is a field within a database table that’s a primary key in another table.
- A primary key references a column or a group of columns in which each row uniquely identifies each record in the table.
- A foreign key forms connections because it is a field within a database table that is a primary key in another table.
Explanation: A primary key is a column or a group of columns in a table that uniquely identifies each record in that table. No two rows can have the same primary key value, ensuring that each record is distinct. The statement “A primary key references a column or a group of columns in which each row uniquely identifies each record in the table” correctly describes the role of a primary key. A foreign key is a column or group of columns in one table that references the primary key of another table. It creates a link between two tables, enforcing referential integrity. The statement “A foreign key forms connections because it is a field within a database table that is a primary key in another table” correctly describes the role of a foreign key.
