Daily Practice · GCSE Computer Science
February 2005 - GCSE Computer Science 5-a-day
Every GCSE Computer Science sheet published in February 2005, with answers. Systems, data representation, networks, algorithms and programming.
Every sheet in February 2005
The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.
- 1st February 2005State the difference between HTTP and HTTPS, and give one situation where HTTPS is essential.
- 2nd February 2005Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
- 3rd February 2005A table called staff has fields staffId, name, department and salary, storing these records: staffId | name | department | salary, 1 | Ben | Sales | 24000, 2 | Chloe | IT | 31000, 3 | Dan | Sales | 27000. State which staffId(s) would be returned by: SELECT staffId FROM staff WHERE department = 'Sales' AND salary > 25000;
- 4th February 2005Each pair from the previous question is stored using 2 bytes. Calculate the compression ratio achieved, given the uncompressed row (1 byte per pixel) uses 8 bytes.
- 5th February 2005Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
- 6th February 2005State the two values a Boolean data type can hold.
- 7th February 2005Convert the 8-bit binary number 01011010 to denary.
- 8th February 2005Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
- 9th February 2005State why a program written in a high level language must be translated.
- 10th February 2005Convert the hexadecimal number 1A to denary.
- 11th February 2005Convert the denary number 156 to an 8 bit binary number.
- 12th February 2005Which type of malware can replicate itself and spread across a network without attaching to another program or needing a user to run it?
- 13th February 2005Describe what a nested loop does when it processes a 2D array.
- 14th February 2005An image uses a colour depth of 2 bits per pixel. Calculate the maximum number of different colours it can represent.
- 15th February 2005A CPU's cache has a hit rate of 80%. During a task the CPU makes 4000 requests for data. Calculate the number of cache hits and cache misses.
- 16th February 2005Describe two negative consequences of throwing away old computer hardware instead of recycling it.
- 17th February 2005Write a function called isEven that takes one integer parameter, num, and returns True if num is even and False otherwise.
- 18th February 2005Write the pseudocode header and body for a function called isAdult that takes one integer parameter called age and returns True if age is 18 or over.
- 19th February 2005A company backs up its files onto magnetic tape cartridges, each with a capacity of 3 TB. The company needs to back up 20 TB of data. Calculate the minimum number of cartridges needed.
- 20th February 2005Give two reasons why network communication is divided into layers.
- 21st February 2005Explain why iterative testing, carried out throughout development, tends to make errors cheaper to fix than relying only on final testing.
- 22nd February 2005State what a foreign key is used for.
- 23rd February 2005Define the term 'interrupt' as used to describe a signal received by a CPU.
- 24th February 2005An 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.
- 25th February 2005Evaluate X = NOT A AND B when A = 0 and B = 1.
- 26th February 2005A pseudocode algorithm is: count <- 0, x <- 10, WHILE x > 0, count <- count + 1, x <- x - 3, ENDWHILE, OUTPUT count. Complete a trace table for x and count, laid out as x | count, then state the value output.
- 27th February 2005Give one advantage of a star topology compared with a mesh topology.
- 28th February 2005Explain why an interpreter is often preferred while a program is being written.