Basic SQL Exam
Name: Date:
1. What does SQL stand for?
a Standard Query Language c Structured Query Language
b Simple Query Language d Server Query Language
2. Which SQL statement is used to extract data from a database?
a OBTAIN
b SELECT
c DISPLAY
d GET
3. Which SQL statement is used to update data in a database?
a SAVE AS
b UPDATE
c MODIFY
d CHANGE
4. Which SQL statement is used to delete data from a database?
a REMOVE
b COLLAPSE
c DELETE
5. Which SQL statement is used to insert new data in a database?
a INSERT NEW c ADD NEW
b ADD RECORD d INSERT INTO
6. With SQL, how do you select a column named "FirstName" from a table named "Persons"?
a SELECT FirstName FROM Persons
b EXTRACT FirstName FROM Persons
c SELECT Persons.FirstName
7. With SQL, how do you select all the columns from a table named "Persons"?
a SELECT [all] FROM Persons
b SELECT Persons
c SELECT * FROM Persons
d SELECT *.Persons
8. 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 [all] FROM Persons WHERE FirstName LIKE 'Peter'
b SELECT [all] FROM Persons WHERE FirstName='Peter'
c SELECT * FROM Persons WHERE FirstName LIKE 'Peter'
d SELECT * FROM Persons WHERE FirstName='Peter'
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"?
a SELECT * FROM Persons WHERE FirstName LIKE 'a%'
b SELECT * FROM Persons WHERE FirstName='%a%'
c SELECT * FROM Persons WHERE FirstName='a'
d SELECT * FROM Persons WHERE FirstName LIKE '%a'
10. The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if
ALL of the conditions listed are true
a TRUE
b FALSE
1/2
11. 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 FirstName='Peter', LastName='Jackson' FROM Persons
b SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
c SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson'
12. With SQL, how do you select all the records from a table named "Persons" where the "LastName" is
alphabetically between (and including) "Hansen" and "Pettersen"?
a SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
b SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons
c SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
13. Which SQL statement is used to return only different values?
a SELECT DISTINCT
b SELECT UNIQUE
c SELECT DIFFERENT
14. Which SQL keyword is used to sort the result-set?
a ORDER
b SORT BY
c ORDER BY
d SORT
15. With SQL, how can you return all the records from a table named "Persons" sorted descending by
"FirstName"?
a SELECT * FROM Persons SORT 'FirstName' DESC
b SELECT * FROM Persons SORT BY 'FirstName' DESC
c SELECT * FROM Persons ORDER BY FirstName DESC
d SELECT * FROM Persons ORDER FirstName DESC
16. With SQL, how can you insert a new record into the "Persons" table?
a INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
b INSERT ('Jimmy', 'Jackson') INTO Persons
c INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
17. With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
a INSERT INTO Persons (LastName) VALUES ('Olsen')
b INSERT ('Olsen') INTO Persons (LastName)
c INSERT INTO Persons ('Olsen') INTO LastName
18. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
a UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
b MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
c MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
d UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
19. With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
a DELETE ROW FirstName='Peter' FROM Persons
b DELETE FROM Persons WHERE FirstName = 'Peter'
c DELETE FirstName='Peter' FROM Persons
20. With SQL, how can you return the number of records in the "Persons" table?
a SELECT COLUMNS(*) FROM Persons
b SELECT COUNT() FROM Persons
c SELECT COLUMNS() FROM Persons
d SELECT COUNT(*) FROM Persons
2/2
