MYSQL

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

What does DML stand for?

• Data Manipulation Language

• Data Modeling Language

• Data Markup Language

• Data Migration Language

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

Which SQL statement is used to return only different values?

• SELECT DISTINCT

• SELECT UNIQUE

• SELECT DIFF

• SELECT DIFFERENT

With SQL, how do you select all the columns from a table named "Persons"?

• SELECT * FROM Persons

• SELECT Persons

• SELECT [all] FROM Persons

• SELECT *.Persons

In a LIKE clause, you can ask for any 6 letter value by writing

• LIKE ______ (that's six underscore characters)

• LIKE ...... (that's six dots)

• LIKE .{6}

• LIKE ??????