SQL fun!

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