WorksheetsSQL
Total questions: 10
Worksheet time: 5mins
What does SQL stand for?
SQL
Structured Query Language
Static Query Language
Structure Query Language
What is the purpose of SQL?
To communicate with a game
To communicate with aliens
To communicate with a database
To communicate with a base
What is the select statement used for?
It is used to select a database
It is used to select data from a database
It is used to select a website
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? SQL * FROM Pupils
It would display pupils who have a * in their name.
It is not a SQL statement.
It would display all records from the Pupils table.
It would not display any pupils.
What would this SQL query display? SQL Forename, Surname FROM Pupils
It would only display pupils forename and surname from the Pupils table.
It is not a SQL statement.
It would display all pupils forenames from Pupils table.
It would not display any pupils.
Which SQL query would display all pupils surnames and registration class?
SELECT * FROM Pupils
SELECT * FROM Pupils WHERE surname, regiClass
SELECT 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 12 years old or order and have the surname Smith?
SELECT * FROM Pupils WHERE Age >= 12 AND Surname = "Smith"
SELECT * FROM Pupils WHERE Age >= 12 AND Surname = Smith
SELECT * FROM Pupils WHERE Age > 12 AND Surname = "Smith"
SELECT * FROM Pupils
