GCSE Databases and SQL 2

With SQL, how do you select all the columns from a table named "Persons"?

• FROM Persons SELECT*

• SELECT all FROM Persons

• SELECT * LIKE Persons

• SELECT * FROM Persons

Which SQL statement which will display the registration numbers and make of all cars with 5 doors made in 2011 or after?

• SELECT CarRegistration, Make FROM Cars LIKE Doors = 5 OR Year >= 2011

• SELECT CarRegistration, Make FROM Cars WHERE Doors = 5 AND Year <= 2011

• SELECT CarRegistration, Make FROM Cars WHERE Doors = 5 AND Year >= 2011

• FROM CarRegistration, Make SELECT Cars WHERE Doors = 5 AND Year >= 2011

Write he missing code to an SQL query to find all teachers from the 'Teachers' table, whose surname begins with ‘B’ and whose title is ‘Mr’. Show all fields from the table.

SELECT*

FROM Teachers

WHERE

• Surname LIKE 'B*' AND Title = 'Mr'

• Surname LIKE 'B*' AND 'Mr'

• Surname LIKE 'B*' Title = 'Mr'

• Surname LIKE 'B*' OR Title = 'Mr'

In the 'members' table, output the first and last name of everyone from Ipswich. Remember that the answer is case sensitive

NB: use single apostrophes (eg. 'Woodbridge')

NB: Put a space after a comma, but no space before the comma (eg. Gender, Town)

In the 'Dogs' table, write an SQL statement to select all the names and breeds of female dogs.

NB: Use single apostrophes (eg. 'Black') with no spaces

NB: Put a space after a comma, but no space before the comma (eg. Gender, Town)

In the 'Dogs' table, write an SQL statement to select all fields for dogs older than four (including those aged four).

In the 'members' table, output all the fields of everyone from Colchester or Ipswich. Remember that the answer is case sensitive.

​ (a)   * ​ (b)   members ​ (c)   Town = 'Colchester' ​ (d)   Town = 'Ipswich'

• FROM
• WHERE
• OR
• SELECT
• LIKE
• THAT
• AND

Write an SQL query to show all trip descriptions and start dates along with the teacher title and surname that will be taking them. The two tables are: Teachers and Trips.

What is the missing code?

SELECT Teachers.Title, Teachers.Surname, Trips.Description, Trips.StartDate

FROM Trips, Teachers

• WHERE Trips.TeacherInCharge, Teachers.TeacherID

• LIKE TeacherInCharge IS TeacherID

• WHERE Trips.TeacherInCharge = Teachers.TeacherID

• WHERE TeacherInCharge = Teachers

Which SQL statement replaces an item in a database with another value?

Write the SQL statement which will display the registration numbers and make of
all cars with 5 doors made in 2011 or after, using the 'Cars' table.

​ (a)   ​ (b)   ​ (c)   ​

• SELECT CarRegistration, Make
• FROM CarRegistration, Make
• FROM Cars
• FROM Make
• WHERE Doors = 5 AND Year >= 2011
• WHERE Doors = 5 OR Year >= 2011
• WHERE Doors = 5 AND Year <= 2011
• WHERE Doors == 5 AND Year >= 2011
• WHERE Year = 5 AND Doors >= 2011