Daily Practice · GCSE Computer Science
November 2017 - GCSE Computer Science 5-a-day
Every GCSE Computer Science sheet published in November 2017, with answers. Systems, data representation, networks, algorithms and programming.
Every sheet in November 2017
The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.
- 1st November 2017State what is meant by a syntax error.
- 2nd November 2017A 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.
- 3rd November 2017What type of utility software reorganises files on a hard disk so fragmented parts are stored closer together?
- 4th November 2017Calculate the maximum number of comparisons required by a binary search on a sorted list of 512 items.
- 5th November 2017Given P = 0 and Q = 1, state the value of P OR Q.
- 6th November 2017Convert the hexadecimal number FF to an 8-bit binary number.
- 7th November 2017A 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.
- 8th November 2017State why a program written in a high level language must be translated.
- 9th November 2017Convert the 4-bit binary number 1101 to denary.
- 10th November 2017Two 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.
- 11th November 2017State why an organisation might employ penetration testers to test its network.
- 12th November 2017Describe what a nested loop does when it processes a 2D array.
- 13th November 2017State one example of a file format that commonly uses lossy compression.
- 14th November 2017State how many bits are in one byte, and how many bytes are in one kibibyte (KiB).
- 15th November 2017State whether the source code of proprietary (closed source) software is normally available for the public to view.
- 16th November 2017Write one line of pseudocode that converts the string stored in heightInput into a real number and stores it in a variable called height.
- 17th November 2017State the correct order of the three operations used to read data from a text file.
- 18th November 2017Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
- 19th November 2017Give two reasons why network communication is divided into layers.
- 20th November 2017Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
- 21st November 2017A 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.
- 22nd November 2017Each 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.
- 23rd November 2017Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
- 24th November 2017State the two values a Boolean data type can hold.
- 25th November 2017Convert the denary number 200 to hexadecimal, showing your working.
- 26th November 2017Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
- 27th November 2017Explain why an interpreter is often preferred while a program is being written.
- 28th November 2017Convert the hexadecimal number 1A to denary.
- 29th November 2017Convert the denary number 156 to an 8 bit binary number.
- 30th November 2017Which type of malware can replicate itself and spread across a network without attaching to another program or needing a user to run it?