0478.1.0.09 — between, IPv4 and IPv6: past paper questions
Real questions on 0478.1.0.09 — between, ipv4 and ipv6
The newest 20 of 77 written questions. Open one to see it on the real paper.
- 0478/22 · May/June 2026 · Q9a[4]
A database table CAR_PARTS stores details of car parts that a business has in stock. Complete the table by giving the most appropriate data types for each field. Only the data types: text, character, Boolean, integer, real and date/time are available in this database. field data type description PartID unique code to i...
See it on the paper → - 0478/22 · May/June 2026 · Q9b[4]
Complete the structured query language (SQL) statement to list only the part ID, type of car and the quantity in stock of all the car parts that are brake pads. SELECT FROM
See it on the paper → - 0478/22 · May/June 2026 · Q9c[2]
Describe one reason why the InStock field is not needed in the table. Turn over
See it on the paper → - 0478/23 · May/June 2026 · Q8c[5]
Complete the structured query language (SQL) statement to list only the subject code, subject name and level for the minimum class size of less than 10. The results should be listed in order of subject code, from the lowest to the highest. SELECT FROM WHERE
See it on the paper → - 0478/11 · October/November 2025 · Q2c[3]
The IP address has an IPv6 format. Give three characteristics of the IPv6 format.
See it on the paper → - 0478/22 · October/November 2025 · Q7a[1]
State the purpose of a primary key in a database table.
See it on the paper → - 0478/22 · October/November 2025 · Q7b[2]
Complete the table for each of the given data types, to identify one field from the table WATERFOWL that is most likely to use it. Each field must be different. Data type Field Boolean Integer Text Real
See it on the paper → - 0478/22 · October/November 2025 · Q7c[3]
Give the output that would be produced by the structured query language (SQL) statement: SELECT Species, Length, Wingspan FROM WATERFOWL WHERE Family = "Swan" ORDER BY Lifespan;
See it on the paper → - 0478/22 · October/November 2025 · Q7d[4]
Complete the SQL statement to list only the species, family and lifespan of all waterfowl whose typical lifespan is at least 10 years, sorted in order of species. SELECT
See it on the paper → - 0478/21 · May/June 2025 · Q8b[2]
Write the output from the structured query language (SQL) statement: SELECT RouteID, Destination, Time FROM BUS WHERE Driver = "A Patel";
See it on the paper → - 0478/21 · May/June 2025 · Q8c[3]
Complete the SQL statement to display only the destination of the buses that have a return. SELECT
See it on the paper → - 0478/22 · May/June 2025 · Q9a[2]
Complete the table by writing one appropriate field from CapitalCity for each data type. Each field must be different. Field Data type Boolean integer real text
See it on the paper → - 0478/22 · May/June 2025 · Q9b[4]
SELECT CapitalCity (b) Complete the structured query language (SQL) statement to list only the name, country and population of all the cities in CapitalCity from the continent of Asia.
See it on the paper → - 0478/23 · May/June 2025 · Q5a[4]
A computer store uses a database table COMPONENT to store the stock details of a range of components needed to build computer systems. Complete the table by giving appropriate data types for each field. Only the data types: text, character, Boolean, integer, real, date/time are available in this database. Field Data ty...
See it on the paper → - 0478/23 · May/June 2025 · Q5b[4]
Complete the structured query language (SQL) statement to list only the unique identifier, component name and reorder date of all the components that have been reordered. SELECT FROM
See it on the paper → - 0478/12 · February/March 2025 · Q5b(i)[1]
A 110:255:2:1 B 1.30.2FF.A9 C 3.162.74.3 Tick (✓) one box to identify a valid IPv4 address. (i)
See it on the paper → - 0478/22 · October/November 2024 · Q11a[2]
A database table called Booking28 stores details of hotel rooms and bookings for the week beginning Monday 7 July 2025. State the number of fields and records in this database table.
See it on the paper → - 0478/22 · October/November 2024 · Q11b[1]
State the reason why the Type field would not be suitable as a primary key.
See it on the paper → - 0478/22 · October/November 2024 · Q11c[2]
The database uses only the data types: alphanumeric, character, Boolean, integer, real, date/time. Complete the table to show the fields that could have the given data types. Only one field name is required in each box and each field name must be different.
See it on the paper → - 0478/22 · October/November 2024 · Q11d[3]
Give the output that would be produced by the structured query language (SQL) statement: SELECT RoomNo, Type, Guests, Rate$ FROM Booking28 WHERE Mon <> T;
See it on the paper →
What examiners said
Most candidates achieved at least one of the marks for the SQL output. Punctuation marks should not be in the output from an SQL statement.
— Examiner report, May/June 2025, 0478/21 Q8(b) (Cambridge)
Most candidates achieved all the marks for the SQL statement
— Examiner report, May/June 2025, 0478/21 Q8(c) (Cambridge)
This question was generally answered well, with most candidates able to correctly identify at least two fields to match the given data types.
— Examiner report, May/June 2025, 0478/22 Q9(a) (Cambridge)
Past papers, syllabus and examiner reports © UCLES (Cambridge University Press & Assessment). Questions are matched to topics from the official syllabus. AssessPro is independent and not endorsed by Cambridge.