Daily Practice · GCSE Computer Science

August 1967 5-a-day

Every sheet in August 1967

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 1967State the difference between HTTP and HTTPS, and give one situation where HTTPS is essential.
  2. 2nd August 1967State what is meant by a syntax error.
  3. 3rd August 1967Define the term 'primary key' as used in a database table.
  4. 4th August 1967What type of utility software reorganises files on a hard disk so fragmented parts are stored closer together?
  5. 5th August 1967Calculate the maximum number of comparisons required by a binary search on a sorted list of 512 items.
  6. 6th August 1967Given P = 0 and Q = 1, state the value of P OR Q.
  7. 7th August 1967Convert the 8-bit binary number 10110100 directly to hexadecimal by splitting it into nibbles.
  8. 8th August 1967A network administrator is connecting 10 computers in a server room. Calculate the number of cables needed for a full mesh topology, and state the number needed for a star topology with one central switch.
  9. 9th August 1967State why a program written in a high level language must be translated.
  10. 10th August 1967Convert the 4-bit binary number 1101 to denary.
  11. 11th August 1967Two 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.
  12. 12th August 1967State why an organisation might employ penetration testers to test its network.
  13. 13th August 1967Describe what a nested loop does when it processes a 2D array.
  14. 14th August 1967State one example of a file format that commonly uses lossy compression.
  15. 15th August 1967State how many bits are in one byte, and how many bytes are in one kibibyte (KiB).
  16. 16th August 1967State whether the source code of proprietary (closed source) software is normally available for the public to view.
  17. 17th August 1967Write one line of pseudocode that converts the string stored in heightInput into a real number and stores it in a variable called height.
  18. 18th August 1967A 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.
  19. 19th August 1967Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
  20. 20th August 1967Give two reasons why network communication is divided into layers.
  21. 21st August 1967Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
  22. 22nd August 1967A 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;
  23. 23rd August 1967Each 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.
  24. 24th August 1967Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
  25. 25th August 1967State the two values a Boolean data type can hold.
  26. 26th August 1967Convert the 8-bit binary number 01011010 to denary.
  27. 27th August 1967Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
  28. 28th August 1967Explain why an interpreter is often preferred while a program is being written.
  29. 29th August 1967Convert the hexadecimal number 1A to denary.
  30. 30th August 1967Convert the denary number 156 to an 8 bit binary number.
  31. 31st August 1967Which type of malware can replicate itself and spread across a network without attaching to another program or needing a user to run it?