SQL Multiple Choice Quiz

What does SQL stand for?

• Sequential Query Logic

• Structured Query Language

• Simple Query Line

• Standard Question Language

What command creates a new table?

• ALTER

• CREATE

• INSERT

• DROP

What is a primary key used for?

• Storing data

• Uniquely identifying records

• Sorting data

• Deleting records

Which SQL command adds a new column to an existing table?

• INSERT

• DROP

• ALTER

• UPDATE

What does the DROP command do?

• Deletes a database or table

• Updates a record

• Views table structure

• Inserts new data

Which of the following is an SQL constraint?

• Foreign Key

• Integer

• Text

• Table

How do you view the structure of a table?

• SELECT TABLE

• PRAGMA TABLE_INFO

• SHOW STRUCTURE

• DESCRIBE TABLE

What data type would you use for storing names?

• INTEGER

• BOOLEAN

• TEXT

• PRIMARY KEY

What is a schema in SQL?

• A set of SQL commands

• The structure of a database

• A type of database

• A constraint

Which command allows you to add data to a table?

• CREATE

• ALTER

• INSERT

• DROP