O-LevelComputer ScienceDatabases2210/21 · May/June 2025 · Q87 Marks

A bus company has set up a new database table called BUS to store details of the buses leaving the main bus terminal. RouteID Destination Stops Driver Time Return BC01 Town Centre 10 B Smith 9:00 Yes BC02 The Fountain 5 A Patel 9:10 Yes BC03 The Palace 9 B Hayes 9:28 No BC04 City Park 12 W Gao 9:55 Yes BC05 City Mall 9 R Hussein 10:10 No BC06 Swan Lake 14 S Clarke 10:33 No BC07 Guildhall Square 7 J Page 11:34 No BC08 Sunset Quay 6 A Patel 12:01 Yes BC10 Fort Worthington 15 E Carr 12:01 Yes BC12 The Observatory 18 B Smith 13:27 No BC14 East Seaport 11 B Scott 14:07 No BC15 The Football Ground 12 J Page 14:46 Yes BC19 The Cricket Ground 11 B Hayes 15:14 No BC23 Temple Ruins 14 W Gao 16:16 No BC27 The University 9 A Patel 16:45 No

(a)(i)Identify one appropriate data type for the field Return[1]
(a)(ii)State the reason for the data type chosen.[1]
(b)Write the output from the structured query language (SQL) statement: SELECT RouteID, Destination, Time FROM BUS WHERE Driver = "A Patel";[2]
(c)Complete the SQL statement to display only the destination of the buses that have a return. SELECT[3]

Mark scheme

Marking points from the official mark scheme (May/June 2025). The mark or mark type is shown in brackets.

[1] (a)(i) Boolean
[1] (a)(ii) There are only 2 responses / Only Yes and No / True and False
[2] (b) Two marks for all three correct [1] (b) One mark for one/two correct BC02 The Fountain 9:10 BC08 Sunset Quay 12:01 BC27 The University 16:45
[1] (c) SELECT Destination
[1] (c) FROM BUS
[1] (c) WHERE Return = Yes;

On Oracle Prep you can write or photograph your own answer and have it marked by AI against this mark scheme, with feedback on what you missed.