Daily Practice · GCSE Computer Science
February 2010 - GCSE Computer Science 5-a-day
Every GCSE Computer Science sheet published in February 2010, with answers. Systems, data representation, networks, algorithms and programming.
Every sheet in February 2010
The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.
- 1st February 2010A 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;
- 2nd February 2010Each 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.
- 3rd February 2010Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
- 4th February 2010State the two values a Boolean data type can hold.
- 5th February 2010Convert the 8-bit binary number 01011010 to denary.
- 6th February 2010Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
- 7th February 2010Explain the purpose of a breakpoint.
- 8th February 2010Convert the hexadecimal number 1A to denary.
- 9th February 2010Convert the denary number 156 to an 8 bit binary number.
- 10th February 2010Which type of malware can replicate itself and spread across a network without attaching to another program or needing a user to run it?
- 11th February 2010Explain why a running maximum should be initialised to the first element of the array rather than to 0.
- 12th February 2010An image uses a colour depth of 2 bits per pixel. Calculate the maximum number of different colours it can represent.
- 13th February 2010A 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.
- 14th February 2010Describe two negative consequences of throwing away old computer hardware instead of recycling it.
- 15th February 2010Write a function called isEven that takes one integer parameter, num, and returns True if num is even and False otherwise.
- 16th February 2010Write 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.
- 17th February 2010A 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.
- 18th February 2010Name the four layers of the TCP/IP model in order from the one closest to the user.
- 19th February 2010Explain why iterative testing, carried out throughout development, tends to make errors cheaper to fix than relying only on final testing.
- 20th February 2010State what a foreign key is used for.
- 21st February 2010Define the term 'interrupt' as used to describe a signal received by a CPU.
- 22nd February 2010An 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.
- 23rd February 2010Evaluate X = NOT A AND B when A = 0 and B = 1.
- 24th February 2010A 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.
- 25th February 2010Give one advantage of a star topology compared with a mesh topology.
- 26th February 2010A 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.
- 27th February 2010Add the 8-bit binary numbers 00101101 and 00010011, giving your answer as an 8-bit binary number.
- 28th February 2010State the three stages of the fetch-decode-execute cycle in the order they occur.