Revision Library
/Subjects/Computer Science/Daily Practice
Daily Practice · GCSE Computer Science

September 1960 5-a-day

← Today's GCSE Computer Science sheet

September 1960

30 sheets · 150 questions · GCSE

September 1960 compilationAll answers

Every sheet in September 1960

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

  1. 1st September 1960A 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.
  2. 2nd September 1960State one function carried out by the operating system of a computer.
  3. 3rd September 1960In computational thinking, what is meant by the term 'decomposition'?
  4. 4th September 1960Given A = 1 and B = 1, state the value of A AND B.
  5. 5th September 1960State how many different values can be represented using 5 bits, and explain your reasoning.
  6. 6th September 1960Define a peer-to-peer network.
  7. 7th September 1960State why a program written in a high level language must be translated.
  8. 8th September 1960Convert the denary number 5 to a 4-bit binary number.
  9. 9th September 1960A CPU has a clock speed of 4.0 GHz. Calculate how many clock cycles it completes in 2 seconds.
  10. 10th September 1960A 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.
  11. 11th September 1960Describe what a nested loop does when it processes a 2D array.
  12. 12th September 1960A mono sound clip has a sample rate of 4000 Hz and lasts 2 seconds. Calculate the total number of samples taken.
  13. 13th September 1960State the type of program that is typically stored in ROM.
  14. 14th September 1960State one reason a small business might choose to use open source software instead of proprietary (closed source) software.
  15. 15th September 1960A FOR loop runs: total = 0, FOR i = 1 TO 4, total = total + i, NEXT i. State the value of total after the loop finishes.
  16. 16th September 1960State the key difference between a procedure and a function.
  17. 17th September 1960State the typical maximum capacity of a single-layer DVD.
  18. 18th September 1960Give two reasons why network communication is divided into layers.
  19. 19th September 1960State what is meant by a syntax error.
  20. 20th September 1960Give one advantage of a relational database over a flat-file database.
  21. 21st September 1960What type of utility software reorganises files on a hard disk so fragmented parts are stored closer together?
  22. 22nd September 1960Calculate the maximum number of comparisons required by a binary search on a sorted list of 512 items.
  23. 23rd September 1960Given P = 0 and Q = 1, state the value of P OR Q.
  24. 24th September 1960Convert the hexadecimal number 3F to denary.
  25. 25th September 1960A 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.
  26. 26th September 1960Explain why an interpreter is often preferred while a program is being written.
  27. 27th September 1960Convert the 4-bit binary number 1101 to denary.
  28. 28th September 1960Two 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.
  29. 29th September 1960State why an organisation might employ penetration testers to test its network.
  30. 30th September 1960A 2D array grid is declared as grid[4][6]. State how many rows and columns it has and how many elements it holds in total.