N5 Computing Database Revision Part 2
Presentation
•
Computers
•
9th - 12th Grade
•
Practice Problem
•
Hard
Tracy Mutter
FREE Resource
5 Slides • 16 Questions
1
2
3
Multiple Choice
What is the primary / foreign key join between these tables?
4
5
Multiple Choice
What is missing in part (b)?
6
Multiple Choice
What is missing in part (a)?
7
Multiple Choice
What is missing in part (c)?
8
Multiple Choice
What is missing in part (d)?
9
Multiple Choice
What is missing in part (a)?
10
Multiple Choice
What is missing in part (b)?
11
Multiple Choice
What is missing in part (c)?
12
Multiple Choice
What is missing in part (d)?
13
Multiple Choice
What is missing in part (e)?
14
15
Draw
16
Dropdown
Write the code that will produce the output shown - Select
FROM
ORDER BY
,
FROM
ORDER BY
;
17
Dropdown
Write the code that will produce the output shown -
Select
FROM
ORDER BY ;
Select
,
FROM
ORDER BY ;
18
Dropdown
Write the code to produce to produce an alphabetical list of all cities names,
their countries and their population for all countries with
FROM City , Country
WHERE
their countries and their population for all countries with
,
,
FROM City , Country
WHERE
19
20
Dropdown
Write the code to produce a list of all cities names and populations for cities
with a population greater than 2,152,423
(the population of Paris)
Select
FROM
WHERE
with a population greater than 2,152,423
(the population of Paris)
Select
,
FROM
WHERE
21
Dropdown
Write the code to find the names of all cities, and the
country they are in for all cities further north than Amsterdam
Select
FROM
WHERE
country they are in for all cities further north than Amsterdam
Select
FROM
WHERE
Show answer
Auto Play
Slide 1 / 21
SLIDE
