Daily Practice · GCSE Computer Science

April 1987 5-a-day

Every sheet in April 1987

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

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