NEW
Font size
WorksheetsSQL fun!
Total questions: 11
Worksheet time: 22mins
How many records are in this table?
7
6
5
4
How many fields are there?
4
5
6
7
Which field is the key field?
ID
Name
HighScore
Competition
What is the ID of the records that are returned when the SQL statement "SELECT * FROM Gymnasts WHERE Name='Xavier'"?
0001
0002
0003
0004
0005
What is the ID of the records that are returned when the SQL statement "SELECT * FROM Gymnasts WHERE HighScore > 8.4"?
0001
0002
0003
0004
0005
Which of the following statements will return the most records?
SELECT * FROM Gymnasts WHERE HighScore > 8.0
SELECT * FROM Gymnasts WHERE Competition LIKE R%
SELECT * FROM Gymnasts WHERE Competition LIKE %o%
SELECT * FROM Gymnasts WHERE Name LIKE %i%
Which of the following is NOT a SQL command?
SELECT
FROM
LIKE
SIMILAR
DISTINCT
How many records are there in this table?
6
7
9
42
How many fields are there in this table?
6
7
9
42
How many records would be returned by the following SQL "SELECT * FROM songs WHERE TimesPlayed >=3
0
2
3
4
How many records would be returned by the following SQL "SELECT * FROM songs WHERE Length < 3 AND Protected = True"?
0
2
3
4
