Computer Science · May / June 2025 · Paper 22 · Question 9
0478
As printed in the paper
The question as text
A database table, º©â, stores data about capital cities from around the world. Field Description «®ªÆŦª a unique identifier the name of the city ¦ªâ the name of the country in which the city is located ¦ªªª the name of the continent in which the city is located ³¦º©¦ª the number of people living in the city ¢¦ª®® the year the city was founded »«ªÅ¦ average income of the city’s population, in $, rounded to 2 decimal places ¥åâ whether or not the city has an underground railway system
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
9(a)[2]
Two marks for all four fields correctly identified
One mark for two or three fields correctly identified
Data type
Field
Boolean
Subway
integer
Population // Founded // Identification real
AverageIncome
text
Name // Country // Continent // Identification
9(b)[4]
One mark per mark point
MP1
All correct fields in SELECT
MP2
Correct use of key word FROM
MP3
Correct field in WHERE: Continent
MP4
Correct criterion in WHERE: "Asia" // 'Asia'
Correct code:
SELECT Name, Country, Population
FROM CapitalCity
WHERE Continent = "Asia"; // 'Asia';
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.