SQL

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