SQL Queries

Which would show all fields from the Pupils table?

• SELECT * FROM Pupils

• SELECT Name, Form FROM Pupils

• SELECT * FROM *

• SELECT * FROM Forms

Which Symbol means "All"

• *

• &

• %

• !

What word lets you find a matching keyword?

• WHERE

• WHAT

• WHEN

• HOW

Which would find pupils with "er" anywhere in their name?

• SELECT * FROM Pupils Where Name = "%er"

• SELECT * FROM Pupils Where Name = "$er$"

• SELECT * FROM Pupils Where Name = "%er%"

• SELECT * FROM Pupils Where Name = "er%"

Which query would return the fields Name and Form?

• SELECT Name, Set FROM Pupils

• SELECT Name, Group FROM Pupils

• SELECT Name, Form FROM Pupils

• SELECT Name, Gender FROM Pupils

Which would find Pupils whose name begins in C from Haddon forms?

• SELECT * FROM Pupils Where Name LIKE "C%" AND House = Haddon

• SELECT * FROM Pupils Where Name = "C%" AND House = Haddon

• SELECT * FROM Pupils Where Name = "C" AND House = Haddon

• SELECT * FROM Pupils Where Name LIKE "C" AND House = Haddon

What is it called when SQL is used in an attempt to harm a database?

• SQL Injection

• SQL Interception

• SQL Attack

• SQL Misuse

Allowing the typing of SQL into a data entry box (EG Username box) on a website could cause problems because it could allow:

• Deleting data

• Editing data

• Adding data

• All of these