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