Database Tables Keys Relationships Quiz

1. True or False: A foreign key must always reference a primary key.

True

False

Submit

3. True or False: A foreign key can reference a column that is not a primary key.

True

False

4. What is the primary purpose of a primary key in a table?

To sort records in ascending order

To uniquely identify each record

To encrypt sensitive data

To link to other databases

Submit

6. Which type of relationship requires a junction table to implement in a relational database?

One-to-one

One-to-many

Many-to-many

Self-referencing

7. True or False: Null values can be stored in a primary key column.

True

False

8. In database terminology, redundancy refers to ____.

Extra backup copies of all tables

Repeated storage of the same data in multiple places

Multiple users accessing data simultaneously

Extra columns used for sorting

Submit

10. Which of the following best describes referential integrity?

Ensuring all data is backed up regularly

Ensuring foreign key values match primary key values in referenced tables

Preventing unauthorized access to database tables

Organizing tables in alphabetical order

11. What is a table in a relational database?

A collection of rows and columns storing related data

A visual diagram of database structure

A backup copy of database files

A report generated from database queries

12. What type of relationship exists when each record in Table A relates to exactly one record in Table B, and vice versa?

One-to-many

Many-to-many

One-to-one

Self-referencing

Submit

14. Which normal form eliminates repeating groups and partial dependencies?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

15. True or False: A table can have multiple primary keys.

True

False

Submit

17. What does normalization accomplish in database design?

Increases file size for backup purposes

Reduces data redundancy and improves data integrity

Makes queries run faster automatically

Encrypts sensitive information

Submit

19. A foreign key establishes a relationship between two tables by referencing which key in another table?

The secondary key

The primary key

The unique key

The alternate key

20. Which key uniquely identifies each row in a table?

Foreign key

Primary key

Composite key

Candidate key

General Databases Beginner Tables Keys and Relationships Quiz

1. True or False: A foreign key must always reference a primary key.

2.

What first name or nickname would you like us to use?

2. In a relational database, data is organized into related ____.

3. True or False: A foreign key can reference a column that is not a primary key.

4. What is the primary purpose of a primary key in a table?

5. The process of organizing data to minimize duplication is called ____.

6. Which type of relationship requires a junction table to implement in a relational database?

7. True or False: Null values can be stored in a primary key column.

8. In database terminology, redundancy refers to ____.

9. A composite key consists of ____ or more columns combined.

10. Which of the following best describes referential integrity?

11. What is a table in a relational database?

12. What type of relationship exists when each record in Table A relates to exactly one record in Table B, and vice versa?

13. A column in a database table is also called a ____.

14. Which normal form eliminates repeating groups and partial dependencies?

15. True or False: A table can have multiple primary keys.

16. A table row is also called a ____.

17. What does normalization accomplish in database design?

18. In a one-to-many relationship, the 'many' side contains a ____.

19. A foreign key establishes a relationship between two tables by referencing which key in another table?

20. Which key uniquely identifies each row in a table?