Daily Practice · GCSE Computer Science
June 2004 - GCSE Computer Science 5-a-day
Every GCSE Computer Science sheet published in June 2004, with answers. Systems, data representation, networks, algorithms and programming.
Every sheet in June 2004
The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.
- 1st June 2004Give one advantage of a relational database over a flat-file database.
- 2nd June 2004What type of utility software reorganises files on a hard disk so fragmented parts are stored closer together?
- 3rd June 2004Calculate the maximum number of comparisons required by a binary search on a sorted list of 512 items.
- 4th June 2004Given P = 0 and Q = 1, state the value of P OR Q.
- 5th June 2004Convert the hexadecimal number 3F to denary.
- 6th June 2004A 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.
- 7th June 2004Explain why an interpreter is often preferred while a program is being written.
- 8th June 2004Convert the 4-bit binary number 1101 to denary.
- 9th June 2004Two 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.
- 10th June 2004State why an organisation might employ penetration testers to test its network.
- 11th June 2004A 2D array grid is declared as grid[4][6]. State how many rows and columns it has and how many elements it holds in total.
- 12th June 2004State one example of a file format that commonly uses lossy compression.
- 13th June 2004State how many bits are in one byte, and how many bytes are in one kibibyte (KiB).
- 14th June 2004State whether the source code of proprietary (closed source) software is normally available for the public to view.
- 15th June 2004Write one line of pseudocode that converts the string stored in heightInput into a real number and stores it in a variable called height.
- 16th June 2004A programmer wants any syntax error in their program to be reported before the program starts running at all. State whether a compiler or an interpreter behaves this way, and explain why.
- 17th June 2004Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
- 18th June 2004State the layer that IP operates in, and describe its job.
- 19th June 2004Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
- 20th June 2004A table called bookings has fields bookingId, customerName and eventDate. Write an SQL statement that deletes the booking with bookingId 45.
- 21st June 2004Each 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.
- 22nd June 2004Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
- 23rd June 2004State the two values a Boolean data type can hold.
- 24th June 2004Convert the denary number 39 to an 8-bit binary number, showing your working.
- 25th June 2004Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
- 26th June 2004Describe what syntax highlighting is and how it helps a programmer.
- 27th June 2004Convert the hexadecimal number 1A to denary.
- 28th June 2004Convert the denary number 156 to an 8 bit binary number.
- 29th June 2004Which type of malware can replicate itself and spread across a network without attaching to another program or needing a user to run it?
- 30th June 2004Trace 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).