Database Basics Quiz: Can You Master Tables, Queries & Keys?

1. What is the purpose of an index in a database?

Store backup copies of data

Speed up data retrieval queries

Encrypt database contents

Validate user permissions

Submit

3. Which concept describes the relationship between entities in a database?

Schema

Cardinality

Transaction

Backup

4. True or False: A NULL value in a database represents the number zero.

True

False

5. Which SQL function counts the number of rows in a result set?

SUM()

COUNT()

AVG()

MAX()

Submit

7. What does denormalization involve in database design?

Adding redundant data to improve query performance

Removing all duplicate records

Creating more tables for better organization

Enforcing stricter data validation rules

8. Which SQL statement is used to modify existing records?

INSERT

UPDATE

ALTER

MODIFY

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

True

False

Submit

11. Which database concept ensures each table has a unique identifier for every row?

Primary Key

Foreign Key

Index

Constraint

12. Which type of join returns only matching records from both tables?

LEFT JOIN

RIGHT JOIN

INNER JOIN

FULL OUTER JOIN

13. True or False: A database can have multiple primary keys in a single table.

True

False

Submit

15. Which SQL clause filters rows based on aggregate functions?

WHERE

GROUP BY

HAVING

ORDER BY

16. What does ACID stand for in database transactions?

Atomicity, Consistency, Isolation, Durability

Accuracy, Conformity, Integrity, Delivery

Authentication, Confidentiality, Identification, Discretion

Availability, Compliance, Integration, Distribution

17. Which normal form eliminates partial dependencies?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

Submit

19. Which SQL keyword is used to retrieve data from a database table?

INSERT

SELECT

UPDATE

DELETE

20. What is the primary purpose of database normalization?

Increase query speed

Reduce data redundancy and improve integrity

Encrypt sensitive data

Backup database files

Database Basics Quiz: Can You Master Tables, Queries & Keys?

1. What is the purpose of an index in a database?

2.

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

2. A _____ is a set of SQL statements that must complete together or not at all.

3. Which concept describes the relationship between entities in a database?

4. True or False: A NULL value in a database represents the number zero.

5. Which SQL function counts the number of rows in a result set?

6. A _____ is a temporary result set created by a SELECT query.

7. What does denormalization involve in database design?

8. Which SQL statement is used to modify existing records?

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

10. A _____ ensures that a column contains only unique values across all rows.

11. Which database concept ensures each table has a unique identifier for every row?

12. Which type of join returns only matching records from both tables?

13. True or False: A database can have multiple primary keys in a single table.

14. A _____ is a structured set of related data organized in rows and columns.

15. Which SQL clause filters rows based on aggregate functions?

16. What does ACID stand for in database transactions?

17. Which normal form eliminates partial dependencies?

18. A _____ is a column that references a primary key in another table.

19. Which SQL keyword is used to retrieve data from a database table?

20. What is the primary purpose of database normalization?