SQL Bronze Award Revision
Quiz
•
Computers
•
9th - 10th Grade
•
Practice Problem
•
Medium
David Wood
Used 7+ times
FREE Resource
Enhance your content in a minute
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?
Similar Resources on Wayground
10 questions
𝐂𝐡𝐚𝐩𝐭𝐞𝐫 𝟓—𝐓𝐡𝐞 𝐅𝐮𝐭𝐮𝐫𝐞 𝐨𝐟 𝐂𝐨𝐦𝐩𝐮𝐭𝐢𝐧𝐠
Quiz
•
10th Grade
13 questions
Software and Computer Care Quiz
Quiz
•
9th Grade
10 questions
Computer System
Quiz
•
8th - 9th Grade
10 questions
Lesson 2 - CPU
Quiz
•
9th Grade
13 questions
ICT and Retail Industry
Quiz
•
8th - 12th Grade
11 questions
Microsoft Word
Quiz
•
2nd - 10th Grade
13 questions
Netiquette
Quiz
•
7th - 9th Grade
10 questions
Fun with Paint and Storage
Quiz
•
1st Grade - University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
