Daily Practice · GCSE Computer Science
November 2002 - GCSE Computer Science 5-a-day
Every GCSE Computer Science sheet published in November 2002, with answers. Systems, data representation, networks, algorithms and programming.
Every sheet in November 2002
The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.
- 1st November 2002A mono sound clip has a sample rate of 4000 Hz and lasts 2 seconds. Calculate the total number of samples taken.
- 2nd November 2002State the type of program that is typically stored in ROM.
- 3rd November 2002State one reason a small business might choose to use open source software instead of proprietary (closed source) software.
- 4th November 2002A FOR loop runs: total = 0, FOR i = 1 TO 4, total = total + i, NEXT i. State the value of total after the loop finishes.
- 5th November 2002Give one specific way this code could be refined without changing what it does: a = 5, b = 3, c = a + b, PRINT c
- 6th November 2002State the typical maximum capacity of a single-layer DVD.
- 7th November 2002Name the four layers of the TCP/IP model in order from the one closest to the user.
- 8th November 2002State what is meant by a syntax error.
- 9th November 2002A 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.
- 10th November 2002What type of utility software reorganises files on a hard disk so fragmented parts are stored closer together?
- 11th November 2002Calculate the maximum number of comparisons required by a binary search on a sorted list of 512 items.
- 12th November 2002Given P = 0 and Q = 1, state the value of P OR Q.
- 13th November 2002Convert the hexadecimal number FF to an 8-bit binary number.
- 14th November 2002A 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.
- 15th November 2002A 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.
- 16th November 2002Convert the 4-bit binary number 1101 to denary.
- 17th November 2002Two 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.
- 18th November 2002State why an organisation might employ penetration testers to test its network.
- 19th November 2002An array named temps holds 12 values. State the index of the first item and the index of the last item.
- 20th November 2002State one example of a file format that commonly uses lossy compression.
- 21st November 2002State how many bits are in one byte, and how many bytes are in one kibibyte (KiB).
- 22nd November 2002State whether the source code of proprietary (closed source) software is normally available for the public to view.
- 23rd November 2002Write one line of pseudocode that converts the string stored in heightInput into a real number and stores it in a variable called height.
- 24th November 2002State the correct order of the three operations used to read data from a text file.
- 25th November 2002Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
- 26th November 2002State the difference between HTTP and HTTPS, and give one situation where HTTPS is essential.
- 27th November 2002Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
- 28th November 2002A 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.
- 29th November 2002Each 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.
- 30th November 2002Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?