Daily Practice · GCSE Computer Science

November 1988 5-a-day

Every sheet in November 1988

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 1988State why an organisation might employ penetration testers to test its network.
  2. 2nd November 1988Trace 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).
  3. 3rd November 1988State one example of a file format that commonly uses lossy compression.
  4. 4th November 1988State how many bits are in one byte, and how many bytes are in one kibibyte (KiB).
  5. 5th November 1988State whether the source code of proprietary (closed source) software is normally available for the public to view.
  6. 6th November 1988Write one line of pseudocode that converts the string stored in heightInput into a real number and stores it in a variable called height.
  7. 7th November 1988A function is defined as: FUNCTION addTax(price) RETURN price x 1.2 ENDFUNCTION. Another line of code runs: total <- addTax(20) + addTax(30). Trace both function calls and state the final value of total.
  8. 8th November 1988Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
  9. 9th November 1988Explain the role of TCP when a large file is downloaded.
  10. 10th November 1988Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
  11. 11th November 1988A 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;
  12. 12th November 1988Each 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.
  13. 13th November 1988Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
  14. 14th November 1988State the two values a Boolean data type can hold.
  15. 15th November 1988Convert the 8-bit binary number 01011010 to denary.
  16. 16th November 1988Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
  17. 17th November 1988Give one advantage and one disadvantage of using a compiler.
  18. 18th November 1988Convert the hexadecimal number 1A to denary.
  19. 19th November 1988Convert the denary number 156 to an 8 bit binary number.
  20. 20th November 1988Which type of malware can replicate itself and spread across a network without attaching to another program or needing a user to run it?
  21. 21st November 1988Write a loop in pseudocode that outputs every element of a 1D array named names of length 6.
  22. 22nd November 1988An image uses a colour depth of 2 bits per pixel. Calculate the maximum number of different colours it can represent.
  23. 23rd November 1988A 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.
  24. 24th November 1988Describe two negative consequences of throwing away old computer hardware instead of recycling it.
  25. 25th November 1988Write a function called isEven that takes one integer parameter, num, and returns True if num is even and False otherwise.
  26. 26th November 1988Write 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.
  27. 27th November 1988A 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.
  28. 28th November 1988A 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?
  29. 29th November 1988Explain why iterative testing, carried out throughout development, tends to make errors cheaper to fix than relying only on final testing.
  30. 30th November 1988State what a foreign key is used for.