Daily Practice · GCSE Computer Science
March 1990 5-a-day
Every sheet in March 1990
The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.
- 1st March 1990State what a foreign key is used for.
- 2nd March 1990Define the term 'interrupt' as used to describe a signal received by a CPU.
- 3rd March 1990An array called items contains [12, 45, 7, 30, 19] at indices 0 to 4. Describe how a linear search would locate the value 30, stating the number of comparisons needed.
- 4th March 1990Evaluate X = NOT A AND B when A = 0 and B = 1.
- 5th March 1990A 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.
- 6th March 1990Give one advantage of a star topology compared with a mesh topology.
- 7th March 1990State why a program written in a high level language must be translated.
- 8th March 1990Add the 8-bit binary numbers 00101101 and 00010011, giving your answer as an 8-bit binary number.
- 9th March 1990State the three stages of the fetch-decode-execute cycle in the order they occur.
- 10th March 1990State one weakness of a simple shift cipher compared to modern encryption methods used on networks.
- 11th March 1990Describe what a nested loop does when it processes a 2D array.
- 12th March 1990Define the term 'pixel'.
- 13th March 1990Order these from fastest access speed to slowest: RAM, cache, registers, secondary storage.
- 14th March 1990Which piece of UK legislation makes it a criminal offence to gain unauthorised access to a computer system?
- 15th March 1990Evaluate the expression 23 DIV 4.
- 16th March 1990State the value returned by LENGTH(word) if word stores the string 'Computer'.
- 17th March 1990A 1 TB hard disk drive costs 40 pounds. A 500 GB solid-state drive costs 60 pounds. Calculate the cost per gigabyte of each device, and state which is cheaper per GB. Use 1 TB = 1000 GB.
- 18th March 1990Give two reasons why network communication is divided into layers.
- 19th March 1990A 'quantity' field on a website must only accept whole numbers from 1 to 10. Which validation check identifies that 15 has been entered?
- 20th March 1990A 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.
- 21st March 1990A row of 8 pixels is WWWBBBWW. Use run-length encoding to encode this row as pairs of (colour, run length).
- 22nd March 1990An array contains [9, 2, 6], to be sorted using insertion sort. Show the state of the array after each new element has been inserted into its correct position.
- 23rd March 1990Complete: NOT 0 = ?
- 24th March 1990State how many different values can be represented using 5 bits, and explain your reasoning.
- 25th March 1990State what LAN stands for.
- 26th March 1990Explain why an interpreter is often preferred while a program is being written.
- 27th March 1990An 8-bit register stores the value 01100000 (denary 96). State the resulting 8-bit binary value after a left shift by 1 place, and state whether an overflow occurs.
- 28th March 1990Which CPU register holds the address of the next instruction to be fetched?
- 29th March 1990Distinguish between the network security threats known as phishing and pharming.
- 30th March 1990A 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.
- 31st March 1990A row of pixels is encoded using run-length encoding as: 3W 4B 3W. State the original row of pixels it represents.