Font size
WorksheetsNational 5 Computing Science Prelim Revision
Total questions: 16
Worksheet time: 8mins
Select all the ways that a program can be evaluated
Fitness for Purpose
Efficiency of Code
Robustness
Readability
Select all the possible data structures
1D Array
Variable
Lattice
Matrix
Which data type can only hold True or False
Boolean
Integer
Real
Single
Which data type would you say in the SQA exam is used to hold the number 4.97
Boolean
Integer
Real
Single
Select all Standard Algorithms for National 5
Traversing a 1D Array
Input Validation
Running Total Within a Loop
Conditional Statement
Which component carries data to and from Main Memory
Control Unit
Registers
Address Bus
Data Bus
Which component is temporary storage inside the processor?
Control Unit
Registers
ALU
RAM
Floating point representation stores real numbers in binary using...
mantissa and exponent
vector and exponent
mantissa and resolution
vector and resolution
Select all ways of reducing a computer's power consumption
Lower screen brightness
Automatic stand by mode
Stop hard disk spinning after a set time
Higher capacity hard disk
Select all ways of ensuring a program is readable
Create a wireframe
High text size
Internal commentary
Meaningful identifiers
What is a logic error?
The program won't run as the mistake in the code breaks the rules of the programming language
The program runs but in testing it produces the wrong result
The program runs but then crashes while running
The program created doesn't match the design
Select the correct SQL statement to add a new record for Mr Alford to the Teacher table
SELECT * FROM Teacher WHERE Title="Mr" AND Surname="Alford";
INSERT INTO Teacher (Title, Surname) VALUES ("Mr","Alford");
INSERT (Title, Surname) VALUES ("Mr","Alford") INTO Teacher;
INSERT (Title, Surname) VALUES ("Mr","Alford") FROM Teacher;
Vector Graphics store...
A colour code for every pixel
Objects and attributes as text
Animation and transparency
Thumbnails
Which validation would be added to a database field to ensure data is entered in that field?
Range Check
Presence Check
Length Check
Restricted Choice
What is a parameter in a predefined function?
Data that is sent into the function to allow it to do it's job
An error that stops the function from working
Details from the creator on what the function does
A subprogram called by an event
Which law protects individuals' personal data?
GDPR (General Data Protection Regulation)
The Copyright, Designs and Patents Act
The Computer Misuse Act
The Communications Act
The Regulation of Investigatory Powers Act
