Daily Practice · GCSE Computer Science
August 1954 5-a-day
Every sheet in August 1954
The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.
- 1st August 1954A 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.
- 2nd August 1954Define the term 'interrupt' as used to describe a signal received by a CPU.
- 3rd August 1954An 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.
- 4th August 1954Evaluate X = NOT A AND B when A = 0 and B = 1.
- 5th August 1954Convert the hexadecimal number FF to an 8-bit binary number.
- 6th August 1954Give one advantage of a star topology compared with a mesh topology.
- 7th August 1954Describe what syntax highlighting is and how it helps a programmer.
- 8th August 1954Add the 8-bit binary numbers 00101101 and 00010011, giving your answer as an 8-bit binary number.
- 9th August 1954State the three stages of the fetch-decode-execute cycle in the order they occur.
- 10th August 1954State one weakness of a simple shift cipher compared to modern encryption methods used on networks.
- 11th August 1954Trace 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).
- 12th August 1954Define the term 'pixel'.
- 13th August 1954Order these from fastest access speed to slowest: RAM, cache, registers, secondary storage.
- 14th August 1954Which piece of UK legislation makes it a criminal offence to gain unauthorised access to a computer system?
- 15th August 1954Evaluate the expression 23 DIV 4.
- 16th August 1954State the correct order of the three operations used to read data from a text file.
- 17th August 1954A 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.
- 18th August 1954Explain the role of TCP when a large file is downloaded.
- 19th August 1954A 'quantity' field on a website must only accept whole numbers from 1 to 10. Which validation check identifies that 15 has been entered?
- 20th August 1954A 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.
- 21st August 1954A row of 8 pixels is WWWBBBWW. Use run-length encoding to encode this row as pairs of (colour, run length).
- 22nd August 1954An 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.
- 23rd August 1954Complete: NOT 0 = ?
- 24th August 1954Convert the denary number 200 to hexadecimal, showing your working.
- 25th August 1954State what LAN stands for.
- 26th August 1954Give one advantage and one disadvantage of using a compiler.
- 27th August 1954An 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.
- 28th August 1954Which CPU register holds the address of the next instruction to be fetched?
- 29th August 1954Distinguish between the network security threats known as phishing and pharming.
- 30th August 1954Write a loop in pseudocode that outputs every element of a 1D array named names of length 6.
- 31st August 1954A row of pixels is encoded using run-length encoding as: 3W 4B 3W. State the original row of pixels it represents.