Daily Practice · GCSE Computer Science
August 1976 5-a-day
Every sheet in August 1976
The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.
- 1st August 1976A password field requires between 6 and 12 characters. State two boundary data values that should be used to test this field.
- 2nd August 1976A table called bookings has fields bookingId, customerName and eventDate. Write an SQL statement that deletes the booking with bookingId 45.
- 3rd August 1976State one function carried out by the operating system of a computer.
- 4th August 1976In computational thinking, what is meant by the term 'decomposition'?
- 5th August 1976Given A = 1 and B = 1, state the value of A AND B.
- 6th August 1976Convert the denary number 39 to an 8-bit binary number, showing your working.
- 7th August 1976Define a peer-to-peer network.
- 8th August 1976Explain the purpose of a breakpoint.
- 9th August 1976Convert the denary number 5 to a 4-bit binary number.
- 10th August 1976A CPU has a clock speed of 4.0 GHz. Calculate how many clock cycles it completes in 2 seconds.
- 11th August 1976A 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.
- 12th August 1976Explain why a running maximum should be initialised to the first element of the array rather than to 0.
- 13th August 1976A mono sound clip has a sample rate of 4000 Hz and lasts 2 seconds. Calculate the total number of samples taken.
- 14th August 1976State the type of program that is typically stored in ROM.
- 15th August 1976State one reason a small business might choose to use open source software instead of proprietary (closed source) software.
- 16th August 1976A FOR loop runs: total = 0, FOR i = 1 TO 4, total = total + i, NEXT i. State the value of total after the loop finishes.
- 17th August 1976Give one specific way this code could be refined without changing what it does: a = 5, b = 3, c = a + b, PRINT c
- 18th August 1976State the typical maximum capacity of a single-layer DVD.
- 19th August 1976Name the four layers of the TCP/IP model in order from the one closest to the user.
- 20th August 1976State what is meant by a syntax error.
- 21st August 1976A 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.
- 22nd August 1976What type of utility software reorganises files on a hard disk so fragmented parts are stored closer together?
- 23rd August 1976Calculate the maximum number of comparisons required by a binary search on a sorted list of 512 items.
- 24th August 1976Given P = 0 and Q = 1, state the value of P OR Q.
- 25th August 1976Convert the hexadecimal number FF to an 8-bit binary number.
- 26th August 1976A 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.
- 27th August 1976A program compiles and runs but always outputs an average that is too small. State the type of error and explain why the translator did not report it.
- 28th August 1976Convert the 4-bit binary number 1101 to denary.
- 29th August 1976Two 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.
- 30th August 1976State why an organisation might employ penetration testers to test its network.
- 31st August 1976An array named temps holds 12 values. State the index of the first item and the index of the last item.