Database Management System Quiz

What is the primary purpose of a Database Management System (DBMS)?

• To manage computer hardware

• To create spreadsheets

• To store, retrieve, and manipulate data

• To design web applications

Which SQL command is used to create a table in a database?

• INSERT

• CREATE

• SELECT

• DELETE

Which of the following is not a characteristic of database systems?

• Data independence

• Scalability

• Random access memory

• Concurrent access

What does "DDL" stand for in SQL?

• Data Description Logic

• Data Definition Language

• Database Decision Logic

• Database Definition Language

What kind of data does a relational database primarily store?

• Hierarchical data

• Key-value pairs

• Tabular data in rows and columns

• Unstructured multimedia

Which SQL statement is used to remove all rows from a table while retaining its structure?

• DROP

• DELETE

• TRUNCATE

• REMOVE

Which SQL keyword retrieves data from a database?

• FETCH

• SELECT

• DISPLAY

• RETRIEVE

In SQL, which clause is used to filter rows based on a condition?

• GROUP BY

• ORDER BY

• WHERE

• HAVING

Which statement best describes indexing in a database?

• It compresses data to save space.

• It creates a copy of the database.

• It enhances the speed of data retrieval.

• It encrypts sensitive data for security.

What SQL command would you use to add a new column to an existing table?

• MODIFY TABLE

• ALTER TABLE

• UPDATE TABLE

• APPEND COLUMN