Daily Practice · GCSE Computer Science

July 1969 5-a-day

Every sheet in July 1969

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 1969Write one line of pseudocode that converts the string stored in heightInput into a real number and stores it in a variable called height.
  2. 2nd July 1969A programmer wants any syntax error in their program to be reported before the program starts running at all. State whether a compiler or an interpreter behaves this way, and explain why.
  3. 3rd July 1969Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
  4. 4th July 1969State the layer that IP operates in, and describe its job.
  5. 5th July 1969Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
  6. 6th July 1969A table called bookings has fields bookingId, customerName and eventDate. Write an SQL statement that deletes the booking with bookingId 45.
  7. 7th July 1969Each 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.
  8. 8th July 1969Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
  9. 9th July 1969State the two values a Boolean data type can hold.
  10. 10th July 1969Convert the denary number 39 to an 8-bit binary number, showing your working.
  11. 11th July 1969Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
  12. 12th July 1969Describe what syntax highlighting is and how it helps a programmer.
  13. 13th July 1969Convert the hexadecimal number 1A to denary.
  14. 14th July 1969Convert the denary number 156 to an 8 bit binary number.
  15. 15th July 1969Which type of malware can replicate itself and spread across a network without attaching to another program or needing a user to run it?
  16. 16th July 1969Trace this algorithm with data = [4, 9, 2, 9, 7] and state the final output. total = 0; count = 0; for i = 0 to 4: if data[i] > 5 then total = total + data[i] and count = count + 1; next i; print(total, count).
  17. 17th July 1969An image uses a colour depth of 2 bits per pixel. Calculate the maximum number of different colours it can represent.
  18. 18th July 1969A 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.
  19. 19th July 1969Describe two negative consequences of throwing away old computer hardware instead of recycling it.
  20. 20th July 1969Write a function called isEven that takes one integer parameter, num, and returns True if num is even and False otherwise.
  21. 21st July 1969Give one specific way this code could be refined without changing what it does: a = 5, b = 3, c = a + b, PRINT c
  22. 22nd July 1969A 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.
  23. 23rd July 1969Explain the role of TCP when a large file is downloaded.
  24. 24th July 1969Explain why iterative testing, carried out throughout development, tends to make errors cheaper to fix than relying only on final testing.
  25. 25th July 1969A 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.
  26. 26th July 1969Define the term 'interrupt' as used to describe a signal received by a CPU.
  27. 27th July 1969An 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.
  28. 28th July 1969Evaluate X = NOT A AND B when A = 0 and B = 1.
  29. 29th July 1969Convert the hexadecimal number FF to an 8-bit binary number.
  30. 30th July 1969Give one advantage of a star topology compared with a mesh topology.
  31. 31st July 1969Give one advantage and one disadvantage of using a compiler.