Daily Practice · GCSE Computer Science

February 2009 - GCSE Computer Science 5-a-day

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

Every sheet in February 2009

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

  1. 1st February 2009Give one specific way this code could be refined without changing what it does: a = 5, b = 3, c = a + b, PRINT c
  2. 2nd February 2009State the typical maximum capacity of a single-layer DVD.
  3. 3rd February 2009State the difference between HTTP and HTTPS, and give one situation where HTTPS is essential.
  4. 4th February 2009State what is meant by a syntax error.
  5. 5th February 2009A table called members has fields memberId, firstName, lastName and joinYear. Write an SQL statement that adds a new record with memberId 12, firstName 'Priya', lastName 'Shah' and joinYear 2026.
  6. 6th February 2009What type of utility software reorganises files on a hard disk so fragmented parts are stored closer together?
  7. 7th February 2009Calculate the maximum number of comparisons required by a binary search on a sorted list of 512 items.
  8. 8th February 2009Given P = 0 and Q = 1, state the value of P OR Q.
  9. 9th February 2009Convert the hexadecimal number FF to an 8-bit binary number.
  10. 10th February 2009A 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.
  11. 11th February 2009State why a program written in a high level language must be translated.
  12. 12th February 2009Convert the 4-bit binary number 1101 to denary.
  13. 13th February 2009Two 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.
  14. 14th February 2009State why an organisation might employ penetration testers to test its network.
  15. 15th February 2009Describe what a nested loop does when it processes a 2D array.
  16. 16th February 2009State one example of a file format that commonly uses lossy compression.
  17. 17th February 2009State how many bits are in one byte, and how many bytes are in one kibibyte (KiB).
  18. 18th February 2009State whether the source code of proprietary (closed source) software is normally available for the public to view.
  19. 19th February 2009Write one line of pseudocode that converts the string stored in heightInput into a real number and stores it in a variable called height.
  20. 20th February 2009State the correct order of the three operations used to read data from a text file.
  21. 21st February 2009Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
  22. 22nd February 2009Give two reasons why network communication is divided into layers.
  23. 23rd February 2009Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
  24. 24th February 2009A table called products has fields productId, name, price and stock. Write an SQL statement that changes the price of the product with productId 7 to 15.99.
  25. 25th February 2009Each 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.
  26. 26th February 2009Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
  27. 27th February 2009State the two values a Boolean data type can hold.
  28. 28th February 2009Convert the denary number 200 to hexadecimal, showing your working.