Daily Practice · GCSE Computer Science
October 1953 5-a-day
Every sheet in October 1953
The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.
- 1st October 1953A 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 October 1953State the difference between lossy and lossless compression.
- 3rd October 1953State the condition that must be met before a binary search can be used on an array.
- 4th October 1953A logic circuit has inputs C and D. C feeds into a NOT gate; the output of the NOT gate and D feed into an OR gate, giving output Y. Write the Boolean expression for Y and state its value when C = 1 and D = 0.
- 5th October 1953Convert the hexadecimal number FF to an 8-bit binary number.
- 6th October 1953Which piece of network hardware connects a LAN to another network such as the internet, directing data packets based on IP address?
- 7th October 1953State why a program written in a high level language must be translated.
- 8th October 1953Convert the denary number 45 to hexadecimal.
- 9th October 1953What does the acronym CPU stand for?
- 10th October 1953State what the term malware means.
- 11th October 1953Describe what a nested loop does when it processes a 2D array.
- 12th October 1953An uncompressed file is 6000 KB. After lossless compression it is 1500 KB. Calculate the compression ratio in the form n:1 (original size : compressed size).
- 13th October 1953Which of RAM and ROM is volatile, meaning its contents are lost when the power is removed?
- 14th October 1953Which piece of UK legislation controls how organisations must store and use people's personal data?
- 15th October 1953Given x = 5 and y = 8, state whether x < y AND x > 0 evaluates to True or False.
- 16th October 1953State the correct order of the three operations used to read data from a text file.
- 17th October 1953Give one reason why RAM on its own is not enough, and a computer also needs secondary storage.
- 18th October 1953Give two reasons why network communication is divided into layers.
- 19th October 1953A password field requires between 6 and 12 characters. State two boundary data values that should be used to test this field.
- 20th October 1953A 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 October 1953State one function carried out by the operating system of a computer.
- 22nd October 1953In computational thinking, what is meant by the term 'decomposition'?
- 23rd October 1953Given A = 1 and B = 1, state the value of A AND B.
- 24th October 1953Convert the denary number 200 to hexadecimal, showing your working.
- 25th October 1953Define a peer-to-peer network.
- 26th October 1953Explain why an interpreter is often preferred while a program is being written.
- 27th October 1953Convert the denary number 5 to a 4-bit binary number.
- 28th October 1953A CPU has a clock speed of 4.0 GHz. Calculate how many clock cycles it completes in 2 seconds.
- 29th October 1953A 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.
- 30th October 1953A 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.
- 31st October 1953A mono sound clip has a sample rate of 4000 Hz and lasts 2 seconds. Calculate the total number of samples taken.