Daily Practice · GCSE Computer Science

October 2004 - GCSE Computer Science 5-a-day

Every GCSE Computer Science sheet published in October 2004, with answers. Systems, data representation, networks, algorithms and programming.

Every sheet in October 2004

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

  1. 1st October 2004Two 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.
  2. 2nd October 2004State why an organisation might employ penetration testers to test its network.
  3. 3rd October 2004Describe what a nested loop does when it processes a 2D array.
  4. 4th October 2004State one example of a file format that commonly uses lossy compression.
  5. 5th October 2004State how many bits are in one byte, and how many bytes are in one kibibyte (KiB).
  6. 6th October 2004State whether the source code of proprietary (closed source) software is normally available for the public to view.
  7. 7th October 2004Write one line of pseudocode that converts the string stored in heightInput into a real number and stores it in a variable called height.
  8. 8th October 2004State the value returned by LENGTH(word) if word stores the string 'Computer'.
  9. 9th October 2004Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
  10. 10th October 2004Give two reasons why network communication is divided into layers.
  11. 11th October 2004Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
  12. 12th October 2004A 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.
  13. 13th October 2004Each 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.
  14. 14th October 2004Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
  15. 15th October 2004State the two values a Boolean data type can hold.
  16. 16th October 2004State how many different values can be represented using 5 bits, and explain your reasoning.
  17. 17th October 2004Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
  18. 18th October 2004Explain why an interpreter is often preferred while a program is being written.
  19. 19th October 2004Convert the hexadecimal number 1A to denary.
  20. 20th October 2004Convert the denary number 156 to an 8 bit binary number.
  21. 21st October 2004Which type of malware can replicate itself and spread across a network without attaching to another program or needing a user to run it?
  22. 22nd October 2004A 2D array grid is declared as grid[4][6]. State how many rows and columns it has and how many elements it holds in total.
  23. 23rd October 2004An image uses a colour depth of 2 bits per pixel. Calculate the maximum number of different colours it can represent.
  24. 24th October 2004A 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.
  25. 25th October 2004Describe two negative consequences of throwing away old computer hardware instead of recycling it.
  26. 26th October 2004Write a function called isEven that takes one integer parameter, num, and returns True if num is even and False otherwise.
  27. 27th October 2004State the key difference between a procedure and a function.
  28. 28th October 2004A 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.
  29. 29th October 2004State the layer that IP operates in, and describe its job.
  30. 30th October 2004Explain why iterative testing, carried out throughout development, tends to make errors cheaper to fix than relying only on final testing.
  31. 31st October 2004Give one advantage of a relational database over a flat-file database.