Daily Practice · GCSE Computer Science

October 2020 - GCSE Computer Science 5-a-day

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

Every sheet in October 2020

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

  1. 1st October 2020A 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.
  2. 2nd October 2020Define the term 'interrupt' as used to describe a signal received by a CPU.
  3. 3rd October 2020An array called items contains [12, 45, 7, 30, 19] at indices 0 to 4. Describe how a linear search would locate the value 30, stating the number of comparisons needed.
  4. 4th October 2020Evaluate X = NOT A AND B when A = 0 and B = 1.
  5. 5th October 2020Convert the hexadecimal number FF to an 8-bit binary number.
  6. 6th October 2020Give one advantage of a star topology compared with a mesh topology.
  7. 7th October 2020State why a program written in a high level language must be translated.
  8. 8th October 2020Add the 8-bit binary numbers 00101101 and 00010011, giving your answer as an 8-bit binary number.
  9. 9th October 2020State the three stages of the fetch-decode-execute cycle in the order they occur.
  10. 10th October 2020State one weakness of a simple shift cipher compared to modern encryption methods used on networks.
  11. 11th October 2020Describe what a nested loop does when it processes a 2D array.
  12. 12th October 2020Define the term 'pixel'.
  13. 13th October 2020Order these from fastest access speed to slowest: RAM, cache, registers, secondary storage.
  14. 14th October 2020Which piece of UK legislation makes it a criminal offence to gain unauthorised access to a computer system?
  15. 15th October 2020Evaluate the expression 23 DIV 4.
  16. 16th October 2020State the correct order of the three operations used to read data from a text file.
  17. 17th October 2020A 1 TB hard disk drive costs 40 pounds. A 500 GB solid-state drive costs 60 pounds. Calculate the cost per gigabyte of each device, and state which is cheaper per GB. Use 1 TB = 1000 GB.
  18. 18th October 2020Give two reasons why network communication is divided into layers.
  19. 19th October 2020A 'quantity' field on a website must only accept whole numbers from 1 to 10. Which validation check identifies that 15 has been entered?
  20. 20th October 2020A 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.
  21. 21st October 2020A row of 8 pixels is WWWBBBWW. Use run-length encoding to encode this row as pairs of (colour, run length).
  22. 22nd October 2020An array contains [9, 2, 6], to be sorted using insertion sort. Show the state of the array after each new element has been inserted into its correct position.
  23. 23rd October 2020Complete: NOT 0 = ?
  24. 24th October 2020Convert the denary number 200 to hexadecimal, showing your working.
  25. 25th October 2020State what LAN stands for.
  26. 26th October 2020Explain why an interpreter is often preferred while a program is being written.
  27. 27th October 2020An 8-bit register stores the value 01100000 (denary 96). State the resulting 8-bit binary value after a left shift by 1 place, and state whether an overflow occurs.
  28. 28th October 2020Which CPU register holds the address of the next instruction to be fetched?
  29. 29th October 2020Distinguish between the network security threats known as phishing and pharming.
  30. 30th October 2020A 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.
  31. 31st October 2020A row of pixels is encoded using run-length encoding as: 3W 4B 3W. State the original row of pixels it represents.