SQL Bronze Award Revision

What is the SELECT statement used for?

• It is used to select a database.

• It is used to select a website.

• It is used to select data from a database.

• It is not a SQL statement.

What is the FROM statement used for?

• It is used to select a database.

• It is not a SQL statement.

• It is used to select a website.

• It is used to specify which table to select data from.

What would this SQL query display? SELECT * FROM Pupils

• It would display pupils who have a * in their name.

• It would display all records from the Pupils table.

• It is not a SQL statement.

• It would not display any pupils.

What would this SQL query display? SELECT Forename, Surname FROM Pupils

• It would only display forename and surname from the Pupils table.

• It would display all pupils forenames from Pupils table.

• It would not display any pupils.

• It is not a SQL statement.

Which SQL query would display all surnames and registration class from the pupils table?

• SELECT * FROM Pupils

• SELECT surname, regiClass

• SELECT * FROM Pupils WHERE surname, regiClass

• SELECT surname, regiClass FROM Pupils

Which SQL query would display all pupils details who have the surname Smith?

• SELECT surname FROM Pupils WHERE Smith

• SELECT * FROM Pupils WHERE surname = Smith

• SELECT * FROM Pupils WHERE surname = "Smith"

• SELECT * FROM Pupils

Which SQL query would display all pupils who are older than 12?

• SELECT * FROM Pupils WHERE age > 12

• SELECT * FROM Pupils WHERE age > "12"

• SELECT * FROM Pupils WHERE age < 12

• SELECT * FROM Pupils WHERE age >= 12

Which SQL query would display all pupils who are younger than 12?

• SELECT * FROM Pupils WHERE age < 11

• SELECT * FROM Pupils WHERE age < "12"

• SELECT * FROM Pupils

• SELECT * FROM Pupils WHERE age < 12

Which SQL query would display all pupils who are 12 years old or younger?

• SELECT * FROM Pupils WHERE age < 12 AND age = 12

• SELECT * FROM Pupils

• SELECT * FROM Pupils WHERE Age <= 12

• SELECT Age FROM Pupils

Which SQL query would display all pupils who are 12 years old or older and have the surname Smith?

• SELECT * FROM Pupils WHERE Age >= 12 AND Surname = "Smith"

• SELECT * FROM Pupils WHERE Age > 12 AND Surname = "Smith"

• SELECT everything FROM Pupils WHERE Age >= 12 AND Surname = Smith

• SELECT * FROM Pupils