MySQL and RA

1.

What does SQL stand for?

• Structured Query Language

• Structured Question Language

• Strong Question Language

• None of the above

2.

SQL is not case sensitive. Is this statement TRUE or FALSE?

• TRUE

• FALSE

3.

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

• USE

• SELECT

• READ

• QUERY

4.

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.

9.

With SQL, how do you select a column named "FirstName" from a table named "Person"?

• SELECT FirstName FROM Person

• SELECT Person.FirstName

• EXTRACT FirstName FROM Person

• SELECT FROM Person.FirstName

10.

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

• SELECT [all] FROM Persons

• SELECT Persons

• SELECT * FROM Persons

• SELECT * all.Persons

What does DML stand for?

• Data Manipulation Language

• Data Modeling Language

• Data Markup Language

• Data Migration Language

Which of the following is not a keyword of MySQL?

• Select

• Top

• Group

• Insert

Which one of the following sorts rows in SQL?

• SORT BY

• ALIGN BY

• GROUP BY

• ORDER BY

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.