Daily Practice · GCSE Computer Science
November 2012 - GCSE Computer Science 5-a-day
Every GCSE Computer Science sheet published in November 2012, with answers. Systems, data representation, networks, algorithms and programming.
Every sheet in November 2012
The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.
- 1st November 2012State the typical maximum capacity of a single-layer DVD.
- 2nd November 2012State the layer that IP operates in, and describe its job.
- 3rd November 2012State what is meant by a syntax error.
- 4th November 2012A 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.
- 5th November 2012What type of utility software reorganises files on a hard disk so fragmented parts are stored closer together?
- 6th November 2012Calculate the maximum number of comparisons required by a binary search on a sorted list of 512 items.
- 7th November 2012Given P = 0 and Q = 1, state the value of P OR Q.
- 8th November 2012Convert the hexadecimal number FF to an 8-bit binary number.
- 9th November 2012A 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.
- 10th November 2012Describe what syntax highlighting is and how it helps a programmer.
- 11th November 2012Convert the 4-bit binary number 1101 to denary.
- 12th November 2012Two 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.
- 13th November 2012State why an organisation might employ penetration testers to test its network.
- 14th November 2012Trace this algorithm with data = [4, 9, 2, 9, 7] and state the final output. total = 0; count = 0; for i = 0 to 4: if data[i] > 5 then total = total + data[i] and count = count + 1; next i; print(total, count).
- 15th November 2012State one example of a file format that commonly uses lossy compression.
- 16th November 2012State how many bits are in one byte, and how many bytes are in one kibibyte (KiB).
- 17th November 2012State whether the source code of proprietary (closed source) software is normally available for the public to view.
- 18th November 2012Write one line of pseudocode that converts the string stored in heightInput into a real number and stores it in a variable called height.
- 19th November 2012State the correct order of the three operations used to read data from a text file.
- 20th November 2012Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
- 21st November 2012Explain the role of TCP when a large file is downloaded.
- 22nd November 2012Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
- 23rd November 2012A 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.
- 24th November 2012Each 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.
- 25th November 2012Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
- 26th November 2012State the two values a Boolean data type can hold.
- 27th November 2012Convert the denary number 200 to hexadecimal, showing your working.
- 28th November 2012Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
- 29th November 2012Give one advantage and one disadvantage of using a compiler.
- 30th November 2012Convert the hexadecimal number 1A to denary.