Introduction to SQL Quiz

What does SQL stand for?

• Simple Query Language

• Structured Query Language

• Structured Query List

• Standard Query Language

Which of the following is a popular Database Management Tool?

• Microsoft Excel

• Adobe Photoshop

• MySQL

• Microsoft Word

What is the purpose of the CREATE DATABASE command?

• To delete a database

• To create a new database

• To retrieve data from a database

• To modify a database

Which SQL command is used to remove an existing table?

• DELETE TABLE

• DROP TABLE

• REMOVE TABLE

• TRUNCATE TABLE

What data type is used for storing exact numeric values?

• varchar

• int

• text

• float

Which operator is used for arithmetic operations in SQL?

• OR

• AND

• +

• LIKE

What does the SELECT command do?

• Deletes data

• Retrieves data

• Updates existing data

• Inserts new data

What is the purpose of the WHERE clause in a SELECT statement?

• To join tables

• To group the results

• To filter the results

• To sort the results

Which SQL command is used to add a new column to an existing table?

• INSERT TABLE

• DROP TABLE

• CREATE TABLE

• ALTER TABLE

What does the NOT NULL constraint ensure?

• A column must have default values

• A column can have NULL values

• A column must have unique values

• A column cannot have NULL values