SQL fun!

Front

How many records are in this table?

Back

6

Front

How many fields are there?

Back

4

Front

Which field is the key field? Options:

ID

,

Name

,

HighScore

,

Competition

Back

ID

Front

What is the ID of the records that are returned when the SQL statement "SELECT * FROM Gymnasts WHERE Name='Xavier'"?

Back

0005

Front

What is the ID of the records that are returned when the SQL statement "SELECT * FROM Gymnasts WHERE HighScore > 8.4"?

Back

0001

Front

Which SQL statement 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%

Back

SELECT * FROM Gymnasts WHERE Name LIKE %i%

Front

Which of the following is NOT a SQL command?

SELECT

,

FROM

,

LIKE

,

SIMILAR

,

DISTINCT

Back

SIMILAR

Front

How many records are there in this table? Options: 6, 7, 9, 42

Back

7

Front

How many fields are there in this table?

Back

6

Front

How many records would be returned by the following SQL "SELECT * FROM songs WHERE TimesPlayed >=3"? Options: 0, 2, 3, 4

Back

3