Question 1:

What does SQL stand for?

Structured Query Language

Strong Question Language

Structured Question Language

None of the above

Question 2:

Which SQL statement is used to extract data from a database?

GET

OPEN

SELECT

EXTRACT

Question 3:

Which SQL statement is used to update data in a database?

MODIFY

UPDATE

SAVE AS

SAVE

Question 4:

Which SQL statement is used to delete data from a database?

COLLAPSE

REMOVE

DELETE

None

Question 5:

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

ADD RECORD

INSERT INTO

INSERT NEW

ADD NEW

Question 6:

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

SELECT Persons.FirstName

EXTRACT FirstName FROM Persons

SELECT FirstName FROM Persons

None

Question 7:

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

SELECT [all] FROM Persons

SELECT Persons

SELECT *.Persons

SELECT * FROM Persons

Question 8:

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

SELECT [all] FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName<>'Peter'

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

Question 9:

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName='%a%'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

Question 10:

Which SQL keyword is used to sort the result-set?

ORDER BY

SORT BY

ORDER

SORT