Introduction to SQL Quiz

What does SQL stand for?

• Structured Query Language

• Structured Question Language

• Standard Query Language

• Simple Query Language

Which of the following is a popular Database Management Tool?

• Microsoft Word

• MySQL

• Adobe Photoshop

• Microsoft Excel

What is the purpose of the CREATE DATABASE command?

• To query data from a database

• To modify an existing database

• To create a new database

• To delete an existing database

Which SQL command is used to delete an existing table?

• TRUNCATE TABLE

• DROP TABLE

• DELETE TABLE

• REMOVE TABLE

What does the NOT NULL constraint ensure?

• A column can have NULL values

• A column cannot have NULL values

• A column must have unique values

• A column can have duplicate values

Which of the following is an example of an exact numeric data type in SQL?

• text

• float

• int

• varchar

What is the purpose of the ALTER TABLE command?

• To query data from a table

• To create a new table

• To delete a table

• To modify an existing table

Which SQL command would you use to ensure all values in a column are different?

• NOT NULL

• UNIQUE

• PRIMARY KEY

• FOREIGN KEY

What does the CHECK constraint do?

• Ensures all values in a column are unique

• Ensures all values in a column satisfy a specific condition

• Ensures a column cannot have NULL values

• Ensures a column has a default value

Which SQL command is used to set a default value for a column?

• SET DEFAULT

• DEFAULT VALUE

• CREATE TABLE

• ALTER TABLE