Revision Library
/Subjects/Computer Science/Daily Practice
Daily Practice · GCSE Computer Science

August 2012 - GCSE Computer Science 5-a-day

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

← Today's GCSE Computer Science sheet

August 2012

31 sheets · 155 questions · GCSE

August 2012 compilationAll answers

Every sheet in August 2012

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 2012A table called staff has fields staffId, name, department and salary, storing these records: staffId | name | department | salary, 1 | Ben | Sales | 24000, 2 | Chloe | IT | 31000, 3 | Dan | Sales | 27000. State which staffId(s) would be returned by: SELECT staffId FROM staff WHERE department = 'Sales' AND salary > 25000;
  2. 2nd August 2012Each 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.
  3. 3rd August 2012Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
  4. 4th August 2012State the two values a Boolean data type can hold.
  5. 5th August 2012Convert the 8-bit binary number 01011010 to denary.
  6. 6th August 2012Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
  7. 7th August 2012Name the translator used for assembly language and describe how it differs from a compiler.
  8. 8th August 2012Convert the hexadecimal number 1A to denary.
  9. 9th August 2012Convert the denary number 156 to an 8 bit binary number.
  10. 10th August 2012Which type of malware can replicate itself and spread across a network without attaching to another program or needing a user to run it?
  11. 11th August 2012Explain what happens if a program tries to read index 5 of an array declared with 5 elements.
  12. 12th August 2012An image uses a colour depth of 2 bits per pixel. Calculate the maximum number of different colours it can represent.
  13. 13th August 2012A 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.
  14. 14th August 2012Describe two negative consequences of throwing away old computer hardware instead of recycling it.
  15. 15th August 2012Write a function called isEven that takes one integer parameter, num, and returns True if num is even and False otherwise.
  16. 16th August 2012Write the pseudocode header and body for a function called isAdult that takes one integer parameter called age and returns True if age is 18 or over.
  17. 17th August 2012A 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.
  18. 18th August 2012Define the term protocol.
  19. 19th August 2012Explain why iterative testing, carried out throughout development, tends to make errors cheaper to fix than relying only on final testing.
  20. 20th August 2012State what a foreign key is used for.
  21. 21st August 2012Define the term 'interrupt' as used to describe a signal received by a CPU.
  22. 22nd August 2012An 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.
  23. 23rd August 2012Evaluate X = NOT A AND B when A = 0 and B = 1.
  24. 24th August 2012A pseudocode algorithm is: count <- 0, x <- 10, WHILE x > 0, count <- count + 1, x <- x - 3, ENDWHILE, OUTPUT count. Complete a trace table for x and count, laid out as x | count, then state the value output.
  25. 25th August 2012Give one advantage of a star topology compared with a mesh topology.
  26. 26th August 2012Explain the purpose of a breakpoint.
  27. 27th August 2012Add the 8-bit binary numbers 00101101 and 00010011, giving your answer as an 8-bit binary number.
  28. 28th August 2012State the three stages of the fetch-decode-execute cycle in the order they occur.
  29. 29th August 2012State one weakness of a simple shift cipher compared to modern encryption methods used on networks.
  30. 30th August 2012Explain why a running maximum should be initialised to the first element of the array rather than to 0.
  31. 31st August 2012Define the term 'pixel'.