Quiz 4: MySQL Database

1.

What does SQL stands 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.

5.

The SQL statement that is used to modify data in a table.

• UPDATE

• SELECT

• READ

• QUERY

6.

The SQL statement that updates existing data within a table is ________ .

• UPDATE

• DELETE

• INSERT

• CALL

7.

Full form of DML is ______ .

• Data Modification language

• Data Manipulation Language

• Database Manipulation Language

• Database Modification Language

8.

Which SQL statement is used to insert new data in a database?

• Insert New

• Insert Into

• Add Record

• Add Data

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