Database Tables Keys Relationships Quiz

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

Foreign key

Primary key

Composite key

Candidate key

2. 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

3. 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

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

True

False

5. 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

6. 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)

7. 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

8. 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

9. 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

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

True

False

Submit

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

True

False

14. 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

Submit

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

True

False

Submit

18. 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

Submit

General Databases Beginner Tables Keys and Relationships Quiz

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

2.

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

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

3. In database terminology, redundancy refers to ____.

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

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

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

7. What does normalization accomplish in database design?

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

9. What is a table in a relational database?

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

11. A table row is also called a ____.

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

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

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

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

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

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

18. Which of the following best describes referential integrity?

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

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