MySQL Quiz

What does SQL stand for?

• Structured Query Language

• Structured Question Language

• Strong Question Language

• None of the above

Which of the following can add a row to a table?

• Add

• Insert

• Update

• Alter

Which of the following is not a keyword of MYSQL?

• Select

• Top

• Group

• Insert

SQL is not case sensitive. SELECT is the same as select.

• TRUE

• FALSE

The _________ statement is used to delete a table.

• DROP TABLE

• DELETE TABLE

• DEL TABLE

• REMOVE TABLE

Which one of the following sorts rows in SQL?

• SORT BY

• ALIGN BY

• GROUP BY

• ORDER BY

The SQL statement that queries or reads data from a table is __________ .

• USE

• SELECT

• READ

• QUERY

SQL can be used to:

• Create database structures only.

• Query database data only.

• Modify database data only.

• All of the above can be done by SQL.

Which statement is used to delete an existing row from the table?

• DELETE

• WHERE

• MODIFY

• None of these

Which clause is used to “Filters out unwanted data”?

• FROM

• SELECT

• ORDER BY

• WHERE