Daily Practice · GCSE Computer Science
June 1955 5-a-day
Every sheet in June 1955
The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.
- 1st June 1955A table called members has fields memberId, firstName, lastName and joinYear. Write an SQL statement that adds a new record with memberId 12, firstName 'Priya', lastName 'Shah' and joinYear 2026.
- 2nd June 1955What type of utility software reorganises files on a hard disk so fragmented parts are stored closer together?
- 3rd June 1955Calculate the maximum number of comparisons required by a binary search on a sorted list of 512 items.
- 4th June 1955Given P = 0 and Q = 1, state the value of P OR Q.
- 5th June 1955Convert the hexadecimal number FF to an 8-bit binary number.
- 6th June 1955A network administrator is connecting 10 computers in a server room. Calculate the number of cables needed for a full mesh topology, and state the number needed for a star topology with one central switch.
- 7th June 1955Name the translator used for assembly language and describe how it differs from a compiler.
- 8th June 1955Convert the 4-bit binary number 1101 to denary.
- 9th June 1955Two CPUs are compared for a task optimised for multiple cores: CPU A has 2 cores at 4.2 GHz; CPU B has 6 cores at 3.0 GHz. Explain which CPU is likely to perform better for this task.
- 10th June 1955State why an organisation might employ penetration testers to test its network.
- 11th June 1955Explain what happens if a program tries to read index 5 of an array declared with 5 elements.
- 12th June 1955State one example of a file format that commonly uses lossy compression.
- 13th June 1955State how many bits are in one byte, and how many bytes are in one kibibyte (KiB).
- 14th June 1955State whether the source code of proprietary (closed source) software is normally available for the public to view.
- 15th June 1955Write one line of pseudocode that converts the string stored in heightInput into a real number and stores it in a variable called height.
- 16th June 1955State the correct order of the three operations used to read data from a text file.
- 17th June 1955Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
- 18th June 1955Define the term protocol.
- 19th June 1955Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
- 20th June 1955A table called products has fields productId, name, price and stock. Write an SQL statement that changes the price of the product with productId 7 to 15.99.
- 21st June 1955Each pair from the previous question is stored using 2 bytes. Calculate the compression ratio achieved, given the uncompressed row (1 byte per pixel) uses 8 bytes.
- 22nd June 1955Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
- 23rd June 1955State the two values a Boolean data type can hold.
- 24th June 1955Convert the denary number 200 to hexadecimal, showing your working.
- 25th June 1955Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
- 26th June 1955Explain the purpose of a breakpoint.
- 27th June 1955Convert the hexadecimal number 1A to denary.
- 28th June 1955Convert the denary number 156 to an 8 bit binary number.
- 29th June 1955Which type of malware can replicate itself and spread across a network without attaching to another program or needing a user to run it?
- 30th June 1955Explain why a running maximum should be initialised to the first element of the array rather than to 0.