SQL Bronze Award Revision
Authored by David Wood
Computers
9th - 10th Grade
Used 7+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
11 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
