SQL Bronze Quiz

What is an example of a piece of data?

• 5
• Door number: 7
• Job Title: Baker
• Title: Miss

What is an example of information?

• 7
• Miss
• Baker
• Shoe Size: 5

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.<br />

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.

What is the FROM statement used for?

• It is used to select a database.
• It is used to specify which table to select data from.
• It is not a SQL statement.
• It is used to select a website.

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.

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 is not a SQL statement.

• It would not display any pupils.

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

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