Free Printable SQL QUIZ

Worksheets

SQL QUIZ

Total questions: 25

Worksheet time: 8mins

Name

Class

Date

What does SQL stand for?

Strong Query Language

Structured Question Language

Structured Query Language

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

EXTRACT

OPEN

SELECT

GET

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

UPDATE

MODIFY

SAVE AS

SAVE

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

COLLAPSE

DELETE

REMOVE

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

ADD NEW

INSERT INTO

ADD RECORD

INSERT NEW

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

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

SELECT [all] FROM Persons

SELECT Persons

SELECT * FROM Persons

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

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

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

SELECT * FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName<>'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"?

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

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

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

True

False

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

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

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

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

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

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

13.

Which SQL statement is used to return only different values?

SELECT DIFFERENT

SELECT UNIQUE

SELECT DISTINCT

14.

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

ORDER

SORT BY

SORT

ORDER BY

15.

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons ORDER FirstName DESC

16.

With SQL, how can you insert a new record into the "Persons" table?

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

17.

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

INSERT INTO Persons ('Olsen') INTO LastName

INSERT INTO Persons (LastName) VALUES ('Olsen')

INSERT ('Olsen') INTO Persons (LastName)

18.

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

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?

DELETE ROW FirstName='Peter' FROM Persons

DELETE FROM Persons WHERE FirstName = 'Peter'

DELETE FirstName='Peter' FROM Persons

20.

With SQL, how can you return the number of records in the "Persons" table?

Next ❯

SELECT NO(*) FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT COUNT(*) FROM Persons

SELECT LEN(*) FROM Persons

21.

What is the most common type of join?

JOINED

JOINED TABLE

INNER JOIN

INSIDE JOIN

22.

Which operator is used to select values within a range?

Next ❯

RANGE

WITHIN

BETWEEN

23.

The NOT NULL constraint enforces a column to not accept empty values.

Next ❯

TRUE

FALSE

24.

Which operator is used to search for a specified pattern in a column?

GET

FROM

25.

Which SQL statement is used to create a table in a database?

CREATE DB

CREATE DATABASE TABLE

CREATE TABLE

CREATE DATABASE TAB

100 %

SQL QUIZ

Total questions: 25

Worksheet time: 8mins

Similar Resources on Wayground