SQL quiz

What does SQL stand for?

• a) Structured Question Language

• b) Strong Question Language

• c) Structured Query Language

• d) Structured Query Layout

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

• a) OPEN

• b) SELECT

• c) EXTRACT

• d) GET

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

• a) SAVE

• b) MODIFY

• c) UPDATE

• d) SAVE AS

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

• a) REMOVE

• b) COLLAPSE

• c) DELETE

• d) DROP

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

• a) INSERT NEW

• b) ADD RECORD

• c) INSERT INTO

• d) ADD NEW

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

• a) SELECT Persons.FirstName

• b) EXTRACT FirstName FROM Persons

• c) SELECT FirstName FROM Persons

• d) SELECT ONLY FirstName FROM Persons

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

• a) SELECT Persons

• b) SELECT [all] FROM Persons

• c) SELECT * FROM Persons

• d) SELECT *.Persons

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

• a) SELECT * FROM Persons WHERE FirstName<>'Peter''

• b) SELECT * FROM Persons WHERE FirstName='Peter'

• c) SELECT [all] FROM Persons WHERE FirstName='Peter'

• d) SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter

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"?

• a) SELECT * FROM Persons WHERE FirstName LIKE 'a%'

• b) SELECT * FROM Persons WHERE FirstName='a'

• c) SELECT * FROM Persons WHERE FirstName LIKE '%a'

• d) SELECT * FROM Persons WHERE FirstName='%a%'

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

• a) SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

• b) SELECT FirstName='Peter', LastName='Jackson' FROM Persons

• c) SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

• d) SELECT FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'