Daily Practice · GCSE Computer Science

November 1954 5-a-day

Every sheet in November 1954

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

  1. 1st November 1954Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
  2. 2nd November 1954State the difference between HTTP and HTTPS, and give one situation where HTTPS is essential.
  3. 3rd November 1954Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
  4. 4th November 1954A 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.
  5. 5th November 1954Each 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 November 1954Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
  7. 7th November 1954State the two values a Boolean data type can hold.
  8. 8th November 1954State how many different values can be represented using 5 bits, and explain your reasoning.
  9. 9th November 1954Calculate 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 November 1954State why a program written in a high level language must be translated.
  11. 11th November 1954Convert the hexadecimal number 1A to denary.
  12. 12th November 1954Convert the denary number 156 to an 8 bit binary number.
  13. 13th November 1954Which 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 November 1954Describe what a nested loop does when it processes a 2D array.
  15. 15th November 1954An image uses a colour depth of 2 bits per pixel. Calculate the maximum number of different colours it can represent.
  16. 16th November 1954A 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 November 1954Describe two negative consequences of throwing away old computer hardware instead of recycling it.
  18. 18th November 1954Write a function called isEven that takes one integer parameter, num, and returns True if num is even and False otherwise.
  19. 19th November 1954State the key difference between a procedure and a function.
  20. 20th November 1954A 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 November 1954Give two reasons why network communication is divided into layers.
  22. 22nd November 1954Explain why iterative testing, carried out throughout development, tends to make errors cheaper to fix than relying only on final testing.
  23. 23rd November 1954Give one advantage of a relational database over a flat-file database.
  24. 24th November 1954Define the term 'interrupt' as used to describe a signal received by a CPU.
  25. 25th November 1954An 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 November 1954Evaluate X = NOT A AND B when A = 0 and B = 1.
  27. 27th November 1954Convert the hexadecimal number 3F to denary.
  28. 28th November 1954Give one advantage of a star topology compared with a mesh topology.
  29. 29th November 1954Explain why an interpreter is often preferred while a program is being written.
  30. 30th November 1954Add the 8-bit binary numbers 00101101 and 00010011, giving your answer as an 8-bit binary number.