Relational Database Concepts Quiz

1. What is the primary purpose of a relational database?

Store unstructured data only

Organize data into related tables with defined relationships

Eliminate the need for data validation

Increase storage capacity indefinitely

2. What is the main advantage of using indexes in a relational database?

Increase storage capacity

Improve query performance

Eliminate the need for primary keys

Automatically normalize data

3. True or False: A candidate key can be null.

True

False

4. What is a composite key?

A key composed of multiple attributes

A key that references another table

A key that can be null

A temporary key used during queries

Submit

6. Which data type is best suited for storing a fixed-length character string?

VARCHAR

CHAR

TEXT

BLOB

7. True or False: Normalization always improves database query performance.

True

False

8. In SQL, which keyword is used to combine rows from multiple tables based on a common column?

UNION

JOIN

MERGE

COMBINE

9. What is the process of breaking down a table into smaller tables to eliminate data anomalies?

Denormalization

Normalization

Fragmentation

Partitioning

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

Foreign key of the related table

Candidate key of the related table

Primary key of the related table

Composite key of the related table

11. What does ACID stand for in database transactions?

Atomicity, Consistency, Isolation, Durability

Accuracy, Clarity, Integration, Data

Availability, Concurrency, Indexing, Distribution

Authentication, Certification, Identity, Delegation

12. Which normal form eliminates partial dependencies?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

Submit

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

True

False

15. What does the term 'referential integrity' mean?

All primary keys must reference foreign keys

Foreign key values must either match a primary key value or be null

All tables must have the same structure

Data must be stored in chronological order

Submit

17. Which SQL clause is used to filter groups of rows based on aggregate functions?

WHERE

GROUP BY

HAVING

ORDER BY

Submit

Data+ Database Relational Database Concepts Quiz

1. What is the primary purpose of a relational database?

2.

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

2. What is the main advantage of using indexes in a relational database?

3. True or False: A candidate key can be null.

4. What is a composite key?

5. In the context of databases, a ____ is a stored procedure or rule that automatically executes when specified events occur.

6. Which data type is best suited for storing a fixed-length character string?

7. True or False: Normalization always improves database query performance.

8. In SQL, which keyword is used to combine rows from multiple tables based on a common column?

9. What is the process of breaking down a table into smaller tables to eliminate data anomalies?

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

11. What does ACID stand for in database transactions?

12. Which normal form eliminates partial dependencies?

13. A ____ is a set of one or more columns that uniquely identifies a row in a table.

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

15. What does the term 'referential integrity' mean?

16. A primary key must be and .

17. Which SQL clause is used to filter groups of rows based on aggregate functions?

18. Data ____ refers to the accuracy, completeness, and consistency of data in a database.

19. In a relational database, a ____ is a named collection of related attributes that describe an entity.

20. In relational database terminology, a row is also called a ____.

Data+ Database Relational Database Concepts Quiz

1. What is the primary purpose of a relational database?

2.

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

2. What is the main advantage of using indexes in a relational database?

3. True or False: A candidate key can be null.

4. What is a composite key?

5. In the context of databases, a ____ is a stored procedure or rule that automatically executes when specified events occur.

6. Which data type is best suited for storing a fixed-length character string?

7. True or False: Normalization always improves database query performance.

8. In SQL, which keyword is used to combine rows from multiple tables based on a common column?

9. What is the process of breaking down a table into smaller tables to eliminate data anomalies?

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

11. What does ACID stand for in database transactions?

12. Which normal form eliminates partial dependencies?

13. A ____ is a set of one or more columns that uniquely identifies a row in a table.

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

15. What does the term 'referential integrity' mean?

16. A primary key must be ____ and ____.

17. Which SQL clause is used to filter groups of rows based on aggregate functions?

18. Data ____ refers to the accuracy, completeness, and consistency of data in a database.

19. In a relational database, a ____ is a named collection of related attributes that describe an entity.

20. In relational database terminology, a row is also called a ____.

16. A primary key must be and .