Daily Practice · GCSE Computer Science

June 1959 5-a-day

Every sheet in June 1959

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

  1. 1st June 1959A 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?
  2. 2nd June 1959A password field requires between 6 and 12 characters. State two boundary data values that should be used to test this field.
  3. 3rd June 1959A 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.
  4. 4th June 1959State one function carried out by the operating system of a computer.
  5. 5th June 1959In computational thinking, what is meant by the term 'decomposition'?
  6. 6th June 1959Given A = 1 and B = 1, state the value of A AND B.
  7. 7th June 1959State how many different values can be represented using 5 bits, and explain your reasoning.
  8. 8th June 1959Define a peer-to-peer network.
  9. 9th June 1959Name the translator used for assembly language and describe how it differs from a compiler.
  10. 10th June 1959Convert the denary number 5 to a 4-bit binary number.
  11. 11th June 1959A CPU has a clock speed of 4.0 GHz. Calculate how many clock cycles it completes in 2 seconds.
  12. 12th June 1959A simple cipher shifts every letter 2 places forward in the alphabet, wrapping around so Y becomes A and Z becomes B. Encrypt the plaintext CAT using this cipher.
  13. 13th June 1959Explain what happens if a program tries to read index 5 of an array declared with 5 elements.
  14. 14th June 1959A mono sound clip has a sample rate of 4000 Hz and lasts 2 seconds. Calculate the total number of samples taken.
  15. 15th June 1959State the type of program that is typically stored in ROM.
  16. 16th June 1959State one reason a small business might choose to use open source software instead of proprietary (closed source) software.
  17. 17th June 1959A FOR loop runs: total = 0, FOR i = 1 TO 4, total = total + i, NEXT i. State the value of total after the loop finishes.
  18. 18th June 1959State the key difference between a procedure and a function.
  19. 19th June 1959State the typical maximum capacity of a single-layer DVD.
  20. 20th June 1959Define the term protocol.
  21. 21st June 1959State what is meant by a syntax error.
  22. 22nd June 1959Give one advantage of a relational database over a flat-file database.
  23. 23rd June 1959What type of utility software reorganises files on a hard disk so fragmented parts are stored closer together?
  24. 24th June 1959Calculate the maximum number of comparisons required by a binary search on a sorted list of 512 items.
  25. 25th June 1959Given P = 0 and Q = 1, state the value of P OR Q.
  26. 26th June 1959Convert the hexadecimal number 3F to denary.
  27. 27th June 1959A 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.
  28. 28th June 1959Explain the purpose of a breakpoint.
  29. 29th June 1959Convert the 4-bit binary number 1101 to denary.
  30. 30th June 1959Two 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.