Daily Practice · GCSE Computer Science

July 1974 5-a-day

Every sheet in July 1974

The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.

  1. 1st July 1974Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
  2. 2nd July 1974State the difference between HTTP and HTTPS, and give one situation where HTTPS is essential.
  3. 3rd July 1974Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
  4. 4th July 1974A table called bookings has fields bookingId, customerName and eventDate. Write an SQL statement that deletes the booking with bookingId 45.
  5. 5th July 1974Each 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.
  6. 6th July 1974Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
  7. 7th July 1974State the two values a Boolean data type can hold.
  8. 8th July 1974Convert the denary number 39 to an 8-bit binary number, showing your working.
  9. 9th July 1974Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
  10. 10th July 1974State why a program written in a high level language must be translated.
  11. 11th July 1974Convert the hexadecimal number 1A to denary.
  12. 12th July 1974Convert the denary number 156 to an 8 bit binary number.
  13. 13th July 1974Which type of malware can replicate itself and spread across a network without attaching to another program or needing a user to run it?
  14. 14th July 1974Describe what a nested loop does when it processes a 2D array.
  15. 15th July 1974An image uses a colour depth of 2 bits per pixel. Calculate the maximum number of different colours it can represent.
  16. 16th July 1974A CPU's cache has a hit rate of 80%. During a task the CPU makes 4000 requests for data. Calculate the number of cache hits and cache misses.
  17. 17th July 1974Describe two negative consequences of throwing away old computer hardware instead of recycling it.
  18. 18th July 1974Write a function called isEven that takes one integer parameter, num, and returns True if num is even and False otherwise.
  19. 19th July 1974Give one specific way this code could be refined without changing what it does: a = 5, b = 3, c = a + b, PRINT c
  20. 20th July 1974A 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.
  21. 21st July 1974Give two reasons why network communication is divided into layers.
  22. 22nd July 1974Explain why iterative testing, carried out throughout development, tends to make errors cheaper to fix than relying only on final testing.
  23. 23rd July 1974A 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.
  24. 24th July 1974Define the term 'interrupt' as used to describe a signal received by a CPU.
  25. 25th July 1974An array called items contains [12, 45, 7, 30, 19] at indices 0 to 4. Describe how a linear search would locate the value 30, stating the number of comparisons needed.
  26. 26th July 1974Evaluate X = NOT A AND B when A = 0 and B = 1.
  27. 27th July 1974Convert the hexadecimal number FF to an 8-bit binary number.
  28. 28th July 1974Give one advantage of a star topology compared with a mesh topology.
  29. 29th July 1974Explain why an interpreter is often preferred while a program is being written.
  30. 30th July 1974Add the 8-bit binary numbers 00101101 and 00010011, giving your answer as an 8-bit binary number.
  31. 31st July 1974State the three stages of the fetch-decode-execute cycle in the order they occur.