SQL Quiz

What does SQL stand for?

• Structured Question Language

• Simple Query Language

• Standard Query Language

• Structured Query Language

Which of the following is NOT a type of SQL statement?

• INSERT

• COMMIT

• CREATE

• DELETE

What is the purpose of the SELECT statement in SQL?

• To create a new database

• To retrieve data

• To update existing records

• To delete records

Which SQL command is used to create a new table?

• ADD TABLE

• TABLE CREATE

• NEW TABLE

• CREATE TABLE

What does the DML in SQL stand for?

• Data Management Language

• Data Model Language

• Database Manipulation Language

• Data Manipulation Language

Which command would you use to remove a table from a database?

• DELETE TABLE

• DROP TABLE

• REMOVE TABLE

• CLEAR TABLE

What is the purpose of the PRIMARY KEY constraint?

• To limit the data type

• To allow duplicate values

• To uniquely identify each record

• To enforce null values

Which of the following is a valid SQL data type?

• STRING

• TEXT

• CHARACTER

• VARCHAR

What SQL command is used to modify an existing table?

• MODIFY TABLE

• ALTER TABLE

• UPDATE TABLE

• CHANGE TABLE

What does the INSERT INTO statement do?

• Deletes records

• Creates a new table

• Updates existing records

• Inserts new records