Daily Practice · GCSE Computer Science
July 1992 - GCSE Computer Science 5-a-day
Every sheet in July 1992
The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.
- 1st July 1992Explain the role of TCP when a large file is downloaded.
- 2nd July 1992A password field requires between 6 and 12 characters. State two boundary data values that should be used to test this field.
- 3rd July 1992A 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.
- 4th July 1992State one function carried out by the operating system of a computer.
- 5th July 1992In computational thinking, what is meant by the term 'decomposition'?
- 6th July 1992Given A = 1 and B = 1, state the value of A AND B.
- 7th July 1992Convert the denary number 200 to hexadecimal, showing your working.
- 8th July 1992Define a peer-to-peer network.
- 9th July 1992Give one advantage and one disadvantage of using a compiler.
- 10th July 1992Convert the denary number 5 to a 4-bit binary number.
- 11th July 1992A CPU has a clock speed of 4.0 GHz. Calculate how many clock cycles it completes in 2 seconds.
- 12th July 1992A 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.
- 13th July 1992Write a loop in pseudocode that outputs every element of a 1D array named names of length 6.
- 14th July 1992A mono sound clip has a sample rate of 4000 Hz and lasts 2 seconds. Calculate the total number of samples taken.
- 15th July 1992State the type of program that is typically stored in ROM.
- 16th July 1992State one reason a small business might choose to use open source software instead of proprietary (closed source) software.
- 17th July 1992A FOR loop runs: total = 0, FOR i = 1 TO 4, total = total + i, NEXT i. State the value of total after the loop finishes.
- 18th July 1992State the pseudocode operator commonly used to join (concatenate) two strings, then show how it joins 'Rev' and 'ision' to produce 'Revision'.
- 19th July 1992State the typical maximum capacity of a single-layer DVD.
- 20th July 1992A user reads the same email on a phone and a tablet, and deleting it on one deletes it on the other. Which protocol is in use and why?
- 21st July 1992State what is meant by a syntax error.
- 22nd July 1992Define the term 'primary key' as used in a database table.
- 23rd July 1992What type of utility software reorganises files on a hard disk so fragmented parts are stored closer together?
- 24th July 1992Calculate the maximum number of comparisons required by a binary search on a sorted list of 512 items.
- 25th July 1992Given P = 0 and Q = 1, state the value of P OR Q.
- 26th July 1992Convert the 8-bit binary number 10110100 directly to hexadecimal by splitting it into nibbles.
- 27th July 1992A 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.
- 28th July 1992Name the translator used for assembly language and describe how it differs from a compiler.
- 29th July 1992Convert the 4-bit binary number 1101 to denary.
- 30th July 1992Two 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.
- 31st July 1992State why an organisation might employ penetration testers to test its network.