SQL Relationship Quiz

What is a one-to-one relationship in SQL?

• A one-to-one relationship in SQL is a relationship between two tables where each record in the first table is related to only one record in the second table, and vice versa.

• A one-to-one relationship in SQL is a relationship between two tables where each record in the first table is related to only one record in the second table, but not vice versa.

• A one-to-one relationship in SQL is a relationship between two tables where each record in the first table is related to multiple records in the second table, but not vice versa.

• A one-to-one relationship in SQL is a relationship between two tables where each record in the first table is related to multiple records in the second table, and vice versa.

What is a one-to-many relationship in SQL?

• A one-to-many relationship in SQL is a type of relationship between two tables where one record in the first table can be associated with multiple records in the second table, and a record in the second table can be associated with multiple records in the first table.

• A one-to-many relationship in SQL is a type of relationship between two tables where one record in the first table can be associated with multiple records in the second table, but a record in the second table can only be associated with one record in the first table.

• A one-to-many relationship in SQL is a type of relationship between two tables where one record in the first table can be associated with multiple records in the second table, and a record in the second table can be associated with multiple records in the first table.

• A one-to-many relationship in SQL is a type of relationship between two tables where one record in the first table can only be associated with one record in the second table, and a record in the second table can only be associated with one record in the first table.

What is a many-to-many relationship in SQL?

• A many-to-many relationship in SQL is a type of relationship between two tables where one record in one table is associated with multiple records in another table.

• A many-to-many relationship in SQL is a type of relationship between two tables where multiple records in one table are associated with only one record in another table.

• A many-to-many relationship in SQL is a type of relationship between two tables where one record in one table is associated with only one record in another table.

• A many-to-many relationship in SQL is a type of relationship between two tables where multiple records in one table are associated with multiple records in another table.

What is a primary key in SQL?

• A primary key in SQL is a column that is used to sort the data in a table.

• A primary key in SQL is a column that stores the primary data in a table.

• A primary key in SQL is a column or a set of columns that uniquely identifies each row in a table.

• A primary key in SQL is a column that is used to join multiple tables together.

What is a foreign key in SQL?

• A foreign key in SQL is a field or a combination of fields in a table that is used to establish a link or relationship between two tables.

• A foreign key in SQL is a field that is used to sort the data in a table.

• A foreign key in SQL is a field that stores the primary key of another table.

• A foreign key in SQL is a primary key in another table.

In a one-to-one relationship, how many records can be associated with each record in the related table?

• 1

• 10

• 2

• 0

In a one-to-many relationship, how many records can be associated with each record in the related table?

• Many

• Few

• One

• None

In a many-to-many relationship, how many records can be associated with each record in the related table?

• One

• None

• Limited

• Multiple

Can a primary key contain duplicate values?

• Sometimes

• Only in certain cases

• Yes

• No

Can a foreign key contain duplicate values?

• No

• Only in certain cases

• Sometimes

• Yes