ITF+ Database Software & Tools Quiz

1. Which of the following best describes a JOIN operation in SQL?

Combines rows from two or more tables based on related columns

Removes duplicate records from a single table

Creates a backup copy of a table

Deletes all records meeting a condition

2. True or False: Indexes in databases slow down SELECT queries but speed up INSERT operations.

True

False

3. Which database software is owned and developed by Microsoft?

SQL Server

MySQL

PostgreSQL

MariaDB

Submit

5. Which of the following is a command-line tool for managing MySQL databases?

Mysql

Sequel Pro

DBeaver

Adminer

Submit

7. True or False: Oracle Database is only available as open-source software.

True

False

8. What does ACID stand for in database transactions?

Atomicity, Consistency, Isolation, Durability

Accuracy, Completeness, Integrity, Data

Authentication, Control, Integration, Deployment

Access, Connectivity, Index, Distribution

Submit

10. MongoDB is an example of which type of database?

Document-based NoSQL

Relational SQL

Graph database

Time-series database

11. What does SQL stand for?

Structured Query Language

Standard Question Logic

Simple Query Library

System Quality Level

12. True or False: PostgreSQL is an open-source relational database system.

True

False

Submit

14. What is the process of organizing database tables to minimize redundancy called?

Normalization

Serialization

Optimization

Partitioning

15. Microsoft SQL Server is primarily used for which operating system environment?

Windows

Linux only

MacOS

Unix

Submit

17. Which tool is commonly used for backing up and restoring MySQL databases?

Mysqldump

PhpMyAdmin

Workbench

Navicat

18. True or False: NoSQL databases use structured schema and ACID transactions like relational databases.

True

False

Submit

20. Which of the following is a relational database management system?

MySQL

MongoDB

Redis

Cassandra

ITF+ Common Database Software and Tools Overview Quiz

1. Which of the following best describes a JOIN operation in SQL?

2.

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

2. True or False: Indexes in databases slow down SELECT queries but speed up INSERT operations.

3. Which database software is owned and developed by Microsoft?

4. In database design, ____ is the relationship where one record in a table relates to many records in another table.

5. Which of the following is a command-line tool for managing MySQL databases?

6. A ____ constraint ensures that all values in a column are unique.

7. True or False: Oracle Database is only available as open-source software.

8. What does ACID stand for in database transactions?

9. In database terminology, a ____ is a single piece of data stored in a field.

10. MongoDB is an example of which type of database?

11. What does SQL stand for?

12. True or False: PostgreSQL is an open-source relational database system.

13. A ____ is a temporary result set derived from a SELECT query in a database.

14. What is the process of organizing database tables to minimize redundancy called?

15. Microsoft SQL Server is primarily used for which operating system environment?

16. In relational databases, a ____ is a set of attributes that uniquely identifies each record.

17. Which tool is commonly used for backing up and restoring MySQL databases?

18. True or False: NoSQL databases use structured schema and ACID transactions like relational databases.

19. A ____ is a collection of organized data stored and accessed electronically.

20. Which of the following is a relational database management system?