Daily Practice · GCSE Computer Science

August 1974 5-a-day

Every sheet in August 1974

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

  1. 1st August 1974State one weakness of a simple shift cipher compared to modern encryption methods used on networks.
  2. 2nd August 1974A 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.
  3. 3rd August 1974Define the term 'pixel'.
  4. 4th August 1974Order these from fastest access speed to slowest: RAM, cache, registers, secondary storage.
  5. 5th August 1974Which piece of UK legislation makes it a criminal offence to gain unauthorised access to a computer system?
  6. 6th August 1974Evaluate the expression 23 DIV 4.
  7. 7th August 1974State the correct order of the three operations used to read data from a text file.
  8. 8th August 1974A 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.
  9. 9th August 1974State the layer that IP operates in, and describe its job.
  10. 10th August 1974A 'quantity' field on a website must only accept whole numbers from 1 to 10. Which validation check identifies that 15 has been entered?
  11. 11th August 1974A 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.
  12. 12th August 1974A row of 8 pixels is WWWBBBWW. Use run-length encoding to encode this row as pairs of (colour, run length).
  13. 13th August 1974An 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.
  14. 14th August 1974Complete: NOT 0 = ?
  15. 15th August 1974Convert the denary number 200 to hexadecimal, showing your working.
  16. 16th August 1974State what LAN stands for.
  17. 17th August 1974Describe what syntax highlighting is and how it helps a programmer.
  18. 18th August 1974An 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.
  19. 19th August 1974Which CPU register holds the address of the next instruction to be fetched?
  20. 20th August 1974Distinguish between the network security threats known as phishing and pharming.
  21. 21st August 1974Trace this algorithm with data = [4, 9, 2, 9, 7] and state the final output. total = 0; count = 0; for i = 0 to 4: if data[i] > 5 then total = total + data[i] and count = count + 1; next i; print(total, count).
  22. 22nd August 1974A row of pixels is encoded using run-length encoding as: 3W 4B 3W. State the original row of pixels it represents.
  23. 23rd August 1974A photo file is 3.5 MB in size. Calculate its size in kilobytes (KB). Use 1 MB = 1000 KB.
  24. 24th August 1974A streaming company records which shows each user watches and uses this to recommend similar shows. Explain one ethical concern this could raise, even if the company only uses the data to improve recommendations.
  25. 25th August 1974State the most appropriate data type for storing a person's shoe size if only whole sizes (e.g. 7, 8, 9) are allowed.
  26. 26th August 1974State the pseudocode operator commonly used to join (concatenate) two strings, then show how it joins 'Rev' and 'ision' to produce 'Revision'.
  27. 27th August 1974Give one example of an optical secondary storage device.
  28. 28th August 1974Explain the role of TCP when a large file is downloaded.
  29. 29th August 1974State the term used for realistic data that a program would be expected to handle during normal use.
  30. 30th August 1974Define the term 'primary key' as used in a database table.
  31. 31st August 1974State the difference between lossy and lossless compression.