Database Concepts and Terminology Quiz

1. Which SQL clause is used to filter rows based on specified conditions?

WHERE

SELECT

FROM

ORDER BY

Submit

3. Which type of database is best suited for storing hierarchical data like documents?

Document database

Relational database

Time-series database

Graph database

4. True or False: A NULL value in a database is the same as a zero or empty string.

True

False

5. What does CRUD stand for in database operations?

Create, Read, Update, Delete

Copy, Restore, Update, Drop

Check, Retrieve, Upload, Download

Compile, Run, Use, Deploy

Submit

7. Which of the following operations joins two tables based on a common column?

JOIN

MERGE

COMBINE

LINK

8. True or False: A database schema defines the structure of data stored in a database.

True

False

Submit

10. What is ACID in the context of database transactions?

A set of properties ensuring reliable transactions

A type of database software

A backup protocol

A security encryption method

11. What is a primary key in a relational database?

A unique identifier for each row in a table

A column that stores passwords

The first column in any table

A field used only for sorting data

12. True or False: NoSQL databases use the same schema structure as relational databases.

True

False

Submit

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

To speed up data retrieval operations

To encrypt sensitive data

To delete rows automatically

To create backup copies

15. Which of the following is NOT a normal form in database normalization?

Fourth Normal Form

Optimal Normal Form

Third Normal Form

Boyce-Codd Normal Form

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

True

False

Submit

19. What does SQL stand for?

Structured Query Language

Standard Question Logic

Sequential Query List

Simple Query Language

20. Which of the following best describes a relational database?

A database that stores data in interconnected tables with rows and columns

A database that only stores text files

A database designed exclusively for graphs

A database that cannot be queried

Tech+ Basic Database Concepts and Terminology Quiz

1. Which SQL clause is used to filter rows based on specified conditions?

2.

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

2. Database ______ refers to the process of copying data to protect against loss.

3. Which type of database is best suited for storing hierarchical data like documents?

4. True or False: A NULL value in a database is the same as a zero or empty string.

5. What does CRUD stand for in database operations?

6. Data ______ is the process of cleaning and organizing raw data for analysis.

7. Which of the following operations joins two tables based on a common column?

8. True or False: A database schema defines the structure of data stored in a database.

9. A ______ constraint ensures that all values in a column are unique.

10. What is ACID in the context of database transactions?

11. What is a primary key in a relational database?

12. True or False: NoSQL databases use the same schema structure as relational databases.

13. A ______ is a set of related records grouped together in a database.

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

15. Which of the following is NOT a normal form in database normalization?

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

17. Database normalization reduces data ______ and improves data integrity.

18. A foreign key is used to ______ relationships between tables.

19. What does SQL stand for?

20. Which of the following best describes a relational database?