February/March 2026 Paper 22

2026 · 9 questions · 21 parts · 75 marks

0/75 marks
0Correct0Partial0Wrong21Unattempted
Filters0 active

Questions

Select a part to jump to its question

Finish set
Q1
1
–/1 mk
Q2
2(a)2(a)(i)2(a)(ii)2(b)2(c)
–/11 mks
Q3
3
–/6 mks
Q4
4
–/1 mk
Q5
5(a)5(b)5(c)
–/11 mks
Q6
6(a)6(b)6(c)
–/11 mks
Q7
7(a)7(b)
–/8 mks
Q8
8(a)8(b)8(c)8(d)
–/11 mks
Q9
9
–/15 mks
Context for question 8
A database table NATIONAL_TREES stores details of the national trees of some countries from around the world.
IDCodeCountryContinentCommonNameScientificName
EU121AlbaniaEuropeOliveOlea europaea
OC235AustraliaOceaniaGolden wattleAcacia pycnantha
NO126The BahamasNorth AmericaLignum vitaeGuaiacum sanctum
AS534BangladeshAsiaMango treeMangifera indica
SO326BrazilSouth AmericaBrazilwoodCaesalpinia echinata
NO124CanadaNorth AmericaMapleAcer
EU321CyprusEuropeGolden oakQuercus alnifolia
NA456Dominican RepublicNorth AmericaWest Indian mahoganySwietenia mahagoni
EU652FinlandEuropeSilver birchBetula pendula
AS222IndiaAsiaIndian banyanFicus benghalensis
NO232JamaicaNorth AmericaBlue mahoeTalipariti elatum
AF875MadagascarAfricaBaobabAdansonia
OC123New ZealandOceaniaSilver fernCyathea dealbata
AS498PhilippinesAsiaNarraPterocarpus indicus
AF501South AfricaAfricaReal yellowwoodPodocarpus Iatifolius
SO522VenezuelaSouth AmericaAraguaneyTabebuia chrysantha
8(a)Relational Databases Data ModellingEasy2 marks
State the number of fields and records in this database table.
Fields
Records
8(b)Relational Databases Data ModellingEasy1 mark
The data in both IDCode and Country fields are unique in the database table. State one reason why IDCode would make a better primary key than Country
8(c)Sql QueriesMedium3 marks
Give the output that would be produced by the structured query language (SQL) statement:
SQL
SELECT IDCode, Country, CommonNameFROM NATIONAL_TREESWHERE Continent = "Europe";

Answer

0 words
8(d)Sql QueriesHard5 marks
Complete the SQL statement to list only the country, common name and scientific name of the national trees listed for North America, in alphabetical order of their common names.
0 words