Daily Practice · GCSE Computer Science

August 1953 5-a-day

Every sheet in August 1953

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

  1. 1st August 1953State the value returned by LENGTH(word) if word stores the string 'Computer'.
  2. 2nd August 1953Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
  3. 3rd August 1953A user reads the same email on a phone and a tablet, and deleting it on one deletes it on the other. Which protocol is in use and why?
  4. 4th August 1953Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
  5. 5th August 1953A table called books has fields bookId, title, authorId and copiesAvailable. Write an SQL statement that selects the title of every book with more than 2 copies available.
  6. 6th August 1953Each 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.
  7. 7th August 1953Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
  8. 8th August 1953State the two values a Boolean data type can hold.
  9. 9th August 1953State how many different values can be represented using 5 bits, and explain your reasoning.
  10. 10th August 1953Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
  11. 11th August 1953Name the translator used for assembly language and describe how it differs from a compiler.
  12. 12th August 1953Convert the hexadecimal number 1A to denary.
  13. 13th August 1953Convert the denary number 156 to an 8 bit binary number.
  14. 14th August 1953Which type of malware can replicate itself and spread across a network without attaching to another program or needing a user to run it?
  15. 15th August 1953Explain what happens if a program tries to read index 5 of an array declared with 5 elements.
  16. 16th August 1953An image uses a colour depth of 2 bits per pixel. Calculate the maximum number of different colours it can represent.
  17. 17th August 1953A 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.
  18. 18th August 1953Describe two negative consequences of throwing away old computer hardware instead of recycling it.
  19. 19th August 1953Write a function called isEven that takes one integer parameter, num, and returns True if num is even and False otherwise.
  20. 20th August 1953State the key difference between a procedure and a function.
  21. 21st August 1953A 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.
  22. 22nd August 1953Define the term protocol.
  23. 23rd August 1953Explain why iterative testing, carried out throughout development, tends to make errors cheaper to fix than relying only on final testing.
  24. 24th August 1953Give one advantage of a relational database over a flat-file database.
  25. 25th August 1953Define the term 'interrupt' as used to describe a signal received by a CPU.
  26. 26th August 1953An 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.
  27. 27th August 1953Evaluate X = NOT A AND B when A = 0 and B = 1.
  28. 28th August 1953Convert the hexadecimal number 3F to denary.
  29. 29th August 1953Give one advantage of a star topology compared with a mesh topology.
  30. 30th August 1953Explain the purpose of a breakpoint.
  31. 31st August 1953Add the 8-bit binary numbers 00101101 and 00010011, giving your answer as an 8-bit binary number.