stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
N5 Computing Science Revision Flashcards | StudBud
Explore
/
N5 Computing Science Revision
N5 Computing Science Revision
48 terms
·
StudBud Administration
·
25 plays
General revision Questions
Flashcards
48 cards
F
Practice quiz
P
Host live
L
Questions
48
Answers
1
Name this type of design notation?.
flow chart
structure diagram
pseudocode
2
SET answer to num1 + num2 - State the number of variables required
5
6
1
3
3
What is a Logical Error
Code that is missing
Code that doesn't behave as intended
Code that doesn't follow the rules
Code that crashes when it runs
4
Name the standard algorithm that makes sure data entered in a program is correct?
error testing
presence check
input validation
length check
5
Students age must be between 11-18. What type of validation is this?
Length Check
Presence Check
Restricted Choice
Range Check
6
What is a Computer Translator?
Translate from code created in Natural Language to Machine Code
Normal text into machine code
Google Translate
Machine code to normal text
7
What is the data type to represent whole numbers?
Real
Boolean
Integer
String
8
What are the Functional requirements of a database?
Processes and activities that the system has to perform.
All of the queries that the system must have working.
Information that the system has to contain to function.
All the testing that is carried out on a database.
9
State the type of navigation shown
hierachical
Linear
structured
straight
10
The programming construct of joining two strings together is known as?
storing
assignment
concatenation
initialising
11
The image shown is an example of what?
Prototype
web page
wireframe diagram
12
What are complex conditions?
A condition that cannot be solved
A condition with one part
A condition that is easy to solve
Conditions with two or more parts to them
13
Why is a foreign key used in a relational database?
To link two tables together
To create a new record
To make sure there are no errors in the database
In case you lose the primary key
14
What type of error is shown in the image?
Syntax
Logic
Execution
15
State two implications for the school under the Data Protection Act!
Data must be sent to third parties
Data must always be deleted each week
Data must be kept safe and secure
Data must be accurate and up-to-date
16
What data type would be used to store the following information: £13.99
integer
real
boolean
string
17
CONSTRUCT - Pre-defined Functions:
normal, extreme, exceptional
input validation, traversing an array, running total
length, random, round
AND, OR, NOT
18
What are end-user requirements of a database?
The end users are the testers of the database
The tasks they expect to be able to do using the database
The end users are the people that buy the database.
The people who are going to be using the database.
19
The data structure you need to know for N5 Computing Science is:
character
array
string
boolean
20
State the most suitable data type for storing 20.05
boolean
integer
string
single
21
What type of loop is shown in the image?
fixed
repeating
conditional
22
A database field cannot be left empty. What type of validation is this?
presence check
restricted choice
length check
range check
23
What is the function of the ALU (Arithmetic Logic Unit)?
Process mathematical and logical operations
Provide audio output
Execute software instructions
Manage input devices
24
What does traversing a array mean?
accessing each element stored in an array
storing many pieces of information in one structure
creating a list within computer memory
using a loop to gather data for an array
25
What does a compiler do?
Converts a program into machine code before it is run
Helps a programmer debug their code
Converts a program into machine code when it is run
All of the above
26
Two methods of improving readability of code are?
save the code at regular intervals
Use internal commentary
compile the program immediately
use meaningful variable names
27
Extended ASCII is
7-bit of codes
6-bit of codes
8-bit of codes
16-bit of codes
28
What are the 5 steps in the software design cycle (in order)?
Requirements, Testing, Design, Maintenance, Implementation,
Requirements, Design, Implementation, Testing, Maintenance
Requirements, Implementation, Review, Maintenance, Recycle
Design, Requirements, Implementation, Testing, Maintenance
29
What is a syntax error?
Occurs because of an invalid command.
Occurs when an unexpected input is received.
The program doesn't produce the correct output.
The code isn't finished and stops before the task completes.
30
What is the purpose of a firewall
Translating code into binary
Scramble data to make it unreadable
Compressing a file to make it smaller
Block traffic entering and leaving a network
31
What value could you enter here for extreme test data?
35
20
40
10
32
What are the two types of graphics used in N5 Computing Science?
Bitmap and Vector
Bitmap and Attributes
Vectors and Attributes
Pixels and Vectors
33
What type of error is shown in the image?
logic
execution
syntax
34
For index = 1 to 5 is an example of what type of loop?
fixed
conditional
repeating
35
State the type of navigation shown
hierachical
template
linear
structured
36
What is a running total within a loop?
To read/write from a text file
To check data entered by a user meets requirements.
To add up the values that are entered into a loop.
An individual element in a record.
37
What is input validation?
To check data entered by a user matches the requirements.
To get free parking.
An individual element in a record.
To read/write from a text file
38
What is the function of the Control Unit?
Wires that connect the CPU to other devices
Part of the CPU that handles all of the calculations
The part of the CPU that handles the loading of commands and decoding
Part of the CPU that interacts with input/output devices
39
What is encryption?
disguises data so that it can't be understood
changes data so that it no longer has the same meaning
encodes data, such as using M for male and F for female
40
What is an execution error?
Syntax Error
Wrong calculations
When the program suddenly crashes for a given reason
Incorrect spelling or grammar
41
What is the data type to represent decimal numbers?
Boolean
Integer
Real
String
42
Which of the 4 SQL queries is a correct SQL notation?
SELECT "condition" FROM "table" WHERE "table"
SELECT "field" FROM "table" WHERE "condition"
SELECT "condition" FROM "table" WHERE "condition"
SELECT "table" FROM "field" WHERE "condition"
43
What values would be exceptional test data for this image?
30
-1
100
25
44
Why would you need to return to the analysis stage of the software development process?
As errors were detected at the design stage
Because you have to
As the design stage is does not make sense
45
To evaluate a website, A website is fit for purpose if:
All user and functional requirements are met.
All users can use all sections of the website.
All testing is carried out by the same person.
All testing criteria are passed successfully.
46
What is a pre defined function?
An algorithm
Pre written code provided by the software environment
Test plan
A database
47
What is a primary key in a database used for?
to make sure data is not lost
to uniquely identify a record in a database
to make sure data is entered in a field
48
StudentID number must be exactly 4 numbers. What type of validation rule is this?
Presence Check
Range Check
Length Check
Restricted Choice
