Tech+ Database Quiz: Can You Master Records, Fields & Queries?

Submit

2. True or False: A transactional database prioritizes consistency and reliability over query speed.

True

False

3. Which database model organizes data into tables with predefined relationships?

Hierarchical

Network

Relational

Document

Submit

5. Which SQL clause is used to filter records based on specified conditions?

ORDER BY

WHERE

GROUP BY

HAVING

6. True or False: A candidate key is a minimal set of attributes that can uniquely identify a record.

True

False

Submit

8. What does the JOIN operation do in SQL?

Combines rows from two or more tables based on a related column

Deletes duplicate records from a table

Sorts data in ascending order

Calculates the sum of numeric values

9. True or False: ACID properties ensure that database transactions are reliable and consistent.

True

False

10. Which of the following is an example of a NoSQL database?

MySQL

PostgreSQL

MongoDB

Oracle

11. In a relational database, what is the smallest unit of data storage called?

Record

Field

Table

Query

12. What is the process of organizing data to minimize redundancy called?

Denormalization

Normalization

Serialization

Indexing

13. Which SQL command is used to retrieve data from a database?

SELECT

INSERT

UPDATE

DELETE

14. True or False: A foreign key in one table must match the primary key in another table.

True

False

Submit

16. What type of relationship exists when one record in Table A is linked to many records in Table B?

One-to-one

One-to-many

Many-to-many

Zero-to-many

17. Which normal form eliminates partial dependencies from a database design?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

Submit

19. What does SQL stand for?

Structured Query Language

Standard Query Listing

Simple Question Logic

Sequential Query Library

20. Which of the following best describes a primary key?

A field that links two tables together

A unique identifier for each record in a table

A field that stores duplicate values

A query used to retrieve data

Tech+ Database Quiz: Can You Master Records, Fields & Queries?

1. A ______ is a structured set of data stored and accessed electronically.

2.

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

2. True or False: A transactional database prioritizes consistency and reliability over query speed.

3. Which database model organizes data into tables with predefined relationships?

4. A ______ is a field that contains a reference to the primary key of another table.

5. Which SQL clause is used to filter records based on specified conditions?

6. True or False: A candidate key is a minimal set of attributes that can uniquely identify a record.

7. An ______ is an ordered arrangement of data that speeds up query performance.

8. What does the JOIN operation do in SQL?

9. True or False: ACID properties ensure that database transactions are reliable and consistent.

10. Which of the following is an example of a NoSQL database?

11. In a relational database, what is the smallest unit of data storage called?

12. What is the process of organizing data to minimize redundancy called?

13. Which SQL command is used to retrieve data from a database?

14. True or False: A foreign key in one table must match the primary key in another table.

15. A ______ is a request to retrieve, insert, update, or delete data from a database.

16. What type of relationship exists when one record in Table A is linked to many records in Table B?

17. Which normal form eliminates partial dependencies from a database design?

18. A ______ is a set of related records organized in rows and columns.

19. What does SQL stand for?

20. Which of the following best describes a primary key?