Relational Database Concepts Quiz

Which of the following is NOT a relational database concept covered in the video?

• Fields

• Indexes

• Tables

• Records

What is a field in the context of a relational database?

• A link between two tables

• A complete set of related records

• A single type of data from a database table

• A unique identifier for a record

In a database table, what does a record represent?

• A set of related fields on a single entity

• A single type of data

• A unique identifier for a table

• A link between two tables

What is the primary key used for in a database table?

• To uniquely identify any record within the table

• To link two tables together

• To store data

• To create a new table

How does a foreign key function in a relational database?

• It stores data

• It uniquely identifies a record

• It links tables together

• It creates a new table

What type of relationship exists when one entry in a table corresponds to a single entry in another table?

• Primary key relationship

• Many-to-many relationship

• One-to-many relationship

• One-to-one relationship

In a one-to-many relationship, what does a single row in one table relate to?

• A single entry in another table

• All entries in another table

• Many entries in another table

• No entries in another table

What is an entity relationship diagram used for?

• To illustrate relationships between tables

• To uniquely identify records

• To store data

• To create new tables

Why is a many-to-many relationship not allowed in a relational database?

• It is too complex to manage

• It is not supported by database software

• It requires too much storage

• It needs to be broken down using normalization

What process is used to handle many-to-many relationships in a relational database?

• Data storage

• Database normalization

• Primary key assignment

• Foreign key linking