SQL Silver Quiz
Authored by STACS HQ
Computers
7th - 9th Grade
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
9 questions
Show all answers
1.
OPEN ENDED QUESTION
2 mins • 1 pt
What would the following SQL statement do? SELECT * FROM Pupils
Evaluate responses using AI:
OFF
Answer explanation
It would display all records from the Pupils table.
2.
OPEN ENDED QUESTION
2 mins • Ungraded
What would the following SQL statement do? SELECT Age FROM Pupils
Evaluate responses using AI:
OFF
Answer explanation
It would display the age of all records in the Pupils table.
3.
OPEN ENDED QUESTION
2 mins • Ungraded
What would the following SQL statement do? SELECT forename, surname, age FROM Pupils
Evaluate responses using AI:
OFF
Answer explanation
It would display the forename, surname and age of all the records in the Pupils table.
4.
OPEN ENDED QUESTION
3 mins • Ungraded
What would the following SQL statement do? SELECT * FROM Pupils WHERE gender = "Female"
Evaluate responses using AI:
OFF
Answer explanation
It would display all the records from the Pupils table who are female.
5.
OPEN ENDED QUESTION
3 mins • Ungraded
What would the following SQL statement do? SELECT forename, surname FROM Pupils WHERE age <= 12
Evaluate responses using AI:
OFF
Answer explanation
It would display the forename and surname from all the records in the Pupils table who are age 12 or younger.
6.
OPEN ENDED QUESTION
3 mins • Ungraded
What would the following SQL statement do? SELECT forename, surname FROM Pupils WHERE age = 12 AND gender = "Male"
Evaluate responses using AI:
OFF
Answer explanation
It would display the forename and surname from all the records in the Pupils table who are 12 years old and male.
7.
OPEN ENDED QUESTION
3 mins • Ungraded
What would the following SQL statement do? SELECT * FROM Pupils WHERE age = 12 OR gender = "Female"
Evaluate responses using AI:
OFF
Answer explanation
It would display all the records from the Pupils table who are 12 years old and display all the records that are females.
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?
