Database Concepts Quiz

Which of the following best describes a database?

• A software program used solely for numerical calculations.

• A collection of related data stored in an organized manner.

• A tool for designing web pages.

• A network protocol for data transmission.

Why are databases important in modern applications?

• They provide a graphical interface for user interaction.

• They enable secure storage and efficient retrieval of data.

• They are used to develop mobile applications only.

• They manage operating system functions.

MySQL is best classified as which type of system?

• A NoSQL database

• A relational database management system (RDBMS)

• A programming language

• A file management system

Which of the following is a Data Definition Language (DDL) command?

• SELECT

• INSERT

• CREATE

• UPDATE

Which DDL command is used to modify the structure of an existing table?

• ALTER

• DROP

• DELETE

• INSERT

What is the purpose of the DROP command in DDL?

• To retrieve records from a table

• To modify table data

• To remove an entire table or database object

• To add new records to a table

Which of the following is a Data Manipulation Language (DML) command?

• CREATE

• DELETE

• DROP

• ALTER

What is the primary purpose of the SELECT statement in DML?

• To insert new records

• To update existing records

• To retrieve data from the database

• To remove data from a table

Which DML command is used to add new records to a table?

• UPDATE

• SELECT

• INSERT

• DELETE

What does the UPDATE command do in a database?

• Inserts new rows into a table

• Retrieves data from the table

• Modifies existing records in a table

• Removes rows from a table