Computer Science · Oct / Nov 2023 · Paper 22 · Question 10
0478
As printed in the paper
The question as text
A database table called Horses stores details about the horses kept at a horse sanctuary. Code Breed BreedOrigin Gender Age Arrived H002 Arabian Saudi Arabia M 5 28/09/2022 H004 Percheron France M 5 30/10/2022 H010 Friesian Netherlands M 6 15/11/2022 H011 Fjord Norway F 4 17/11/2022 H012 Clydesdale Scotland M 10 18/11/2022 H015 Arabian Saudi Arabia F 5 15/12/2022 H016 Arabian Saudi Arabia F 5 15/12/2022 H017 Clydesdale Scotland F 4 16/01/2023 H019 Percheron France M 3 16/01/2023 H025 Percheron France M 7 16/01/2023 H026 Clydesdale Scotland F 9 20/01/2023 H030 Clydesdale Scotland M 12 20/01/2023 H032 Fjord Norway M 3 24/03/2023 H033 Arabian Saudi Arabia F 15 27/04/2023 H034 Clydesdale Scotland F 4 14/06/2023 H035 Fjord Norway M 7 15/06/2023 H036 Friesian Netherlands F 15 20/07/2023 H037 Friesian Netherlands M 12 20/07/2023
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
10(a)[1]
18
10(b)[2]
One mark for the correct field name
One mark for the correct reason
For example:
Code …
…Each entry in this field is a unique identifier
10(c)[2]
Two marks for four correct answers.
One mark for two or three correct answers.
Field
Data type
Breed
text
Gender
Boolean
Age
integer
Arrived
date/time
10(d)[3]
One mark for each correct answer
SELECT
Horses
BreedOrigin
Correct SQL:
SELECT Code, Breed
FROM Horses
WHERE BreedOrigin = "Scotland";
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.