Daily Practice · GCSE Computer Science

Daily Practice - GCSE Computer Science

Systems, data representation, networks, algorithms and programming.

27th December 2022

5 questions · GCSE · 123 questions in this band

1
SQL and Data Handling
A table called staff has fields staffId, name, department and salary, storing these records: staffId | name | department | salary, 1 | Ben | Sales | 24000, 2 | Chloe | IT | 31000, 3 | Dan | Sales | 27000. State which staffId(s) would be returned by: SELECT staffId FROM staff WHERE department = 'Sales' AND salary > 25000;
2
Trace Tables and Binary/Hex Conversions
Convert the hexadecimal number 3F to denary.
3
Systems Architecture
A CPU has a clock speed of 4.0 GHz. Calculate how many clock cycles it completes in 2 seconds.
4
Memory and Primary Storage
State how many bits are in one byte, and how many bytes are in one kibibyte (KiB).
5
Secondary Storage
A company backs up its files onto magnetic tape cartridges, each with a capacity of 3 TB. The company needs to back up 20 TB of data. Calculate the minimum number of cartridges needed.

You are looking at an earlier sheet. Today's sheet is the one that adds a day.

Your run is kept in this browser only, and there is no account.

Every sheet is deterministic: the same date always regenerates the same five questions. All of December 2022, including the monthly compilation PDF.