wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Higher Computing Prelim Revision Jan 20

Total questions: 103

Worksheet time: 56mins

Name
Class
Date
1.
How would you pass a variable that is local to one subprogram?
a)
By Value
b)
By Reference
c)
You wouldn't need to pass it at all
2.
How would you pass a variable that is used in a subprogram but not changed?
a)
By Value
b)
By Reference
c)
You wouldn't need to pass it at all
3.
How would you pass an array that is used in a subprogram but not changed?
a)
By Value
b)
By Reference
c)
You wouldn't need to pass it at all
4.
How would you pass a variable changed by a subprogram?
a)
By Value
b)
By Reference
c)
You wouldn't need to pass it at all
5.
Which of these wastes RAM?
a)
Passing an array by reference
b)
Passing an array by value
c)
Using local variables
d)
Not having Reddit open while you work
6.
How would requirements elicitation be carried out?
a)
Read documentation about the current system
b)
Use pseudocode to plan the program
c)
Make sure the development team have regular meetings
d)
Pass the requirements by value
7.
Which of these is NOT a reason that an accurate software specification is valuable
a)
It forms the basis of a legal contract with the client
b)
It can be used to create a test plan
c)
It enables a high quality user manual to be written
d)
It enables the programmers to know exactly what the problem is that they must solve
8.
Which of these is NOT an advantage of Rapid Application Development?
a)
It enables the programmers to know exactly what the problem is that they must solve
b)
•Subsystems/specific elements can be prioritised and tested as early as possible 
c)
•allows changes to the design to be made at any time throughout the life of the project in response to client feedback
d)
•A range of proposed solutions can be developed on a small scale instead of the need for full implementation
9.
Which of these is the 8 bit two's complement representation of -87
a)
10101001
b)
01010101
c)
00110011
d)
11111111
10.
Which of these design methodologies involves taking a main problem and breaking it down into sub-problems?
a)
Top-down Design and Rapid Application Development
b)
Agile and Top-down Design
c)
Top-down Design and Stepwise Refinement
d)
only Top-down Design
11.
A Vector Graphic contains three squares and two circles. Choose the correct effect below if a triangle is added to the graphic:
a)
The file size will increase slightly
b)
The file size will decrease
c)
The file size will stay the same
12.
What operator is used to concatenate Strings?
a)
*
b)
+
c)
&
d)
[]
13.
What is substring?
a)
Joining two Strings together
b)
Splitting two Strings apart
c)
Taking only part of a String
d)
Finding the length of a String
14.
Which standard algorithm is shown:  set found to false,  Loop for each entry,  If entry =target, set found to true, end if, end loop
a)
Find Maximum
b)
Find Minimum
c)
Count Occurrences
d)
Linear Search
15.
Which standard algorithm is shown:  set total to 0,  Loop for each entry,  If entry >50, add one to total, end if, end loop
a)
Find Maximum
b)
Find Minimum
c)
Count Occurrences
d)
Linear Search
16.
Which standard algorithm is shown:  set high to first array entry,  Loop for rest of array,  If current entry > high, set high to current entry, end if, end loop
a)
Find Maximum
b)
Find Minimum
c)
Count Occurrences
d)
Linear Search
17.
Explain fully why cache memory enhances the execution of a piece of software
a)
Cache is memory close to the processor holding frequently used instructions
b)
Cache is fast access memory close to the processor holding frequently used instructions
c)
Cache is fast access memory close to the processor
d)
Cache holds frequently used instructions
18.
What is a compound key?
a)
another name for a primary key
b)
a primary key created from more than one field
c)
a primary key created from more than one record
d)
a primary key created from more than one table
19.
A list of 20 names and exam marks is to be stored.
Which of these would be the most efficient data structure(s) to use?
a)
a record
b)
a string array and an integer array
c)
a string array
d)
20 separate strings and integers
20.
What is the scope of a global variable?
a)
the entire program
b)
the procedure in which it is declared
c)
the entire world
d)
the range of values it can hold
21.

A foreign key

a)

is a primary key in its own table and used in a second table to create a link between them

b)

is a field in both tables used to create a link between them

c)

is a primary key used in two tables to create a link between them

d)

is where the primary key is made up of two or more fields

22.

A rentals table is designed as shown

RENTAL (CustomerID*, ToolID*, Date, Insurance)


What type of key is used in this table?

a)

Primary

b)

Foreign

c)

Compound

d)

Surrogate

23.

a)
b)
c)
24.
Write the number -78 in 8-bit two's complement notation
a)
10110010
b)
00110010
c)
11001110
d)
01001110
25.
What is a surrogate key?
a)
a field created to uniquely identify a record when no obvious primary key exists
b)
a primary key created from more than one field
c)
another name for a primary key
d)
a unique identifier for a record
26.
Which law is designed to control the use of personal data?
a)
Data Protection Act
b)
Computer Misuse Act
c)
Copyright, Design and Patents Act
d)
RIPA
27.
Which of these precautions is most effective for securing personal  information such as bank details?
a)
use of biometric data
b)
use of usernames and passwords
c)
use of simple encryption
d)
use of anti-virus and firewall software
28.
 Which statement best describes what happens to the temporary working memory (RAM) of a computer when it is shut down? 
a)
It is deleted
b)
It is saved in the users document files 
c)
It is saved in the computer's data storage files 
d)
It is synced automatically with the cloud 
29.

Select all the ways that a program can be evaluated

a)

Fitness for Purpose

b)

Efficiency of Code

c)

Robustness

d)

Readability

30.

Which data type would you say in the SQA exam is used to hold the number 4.97

a)

Boolean

b)

Integer

c)

Real

d)

Single

31.

Which component carries data to and from Main Memory

a)

Control Unit

b)

Registers

c)

Address Bus

d)

Data Bus

32.

Which component is temporary storage inside the processor?

a)

Control Unit

b)

Registers

c)

ALU

d)

RAM

33.

Floating point representation stores real numbers in binary using...

a)

mantissa and exponent

b)

vector and exponent

c)

mantissa and resolution

d)

vector and resolution

34.

Select the correct SQL statement to add a new record for Mr Alford to the Teacher table

a)

SELECT * FROM Teacher WHERE Title="Mr" AND Surname="Alford";

b)

INSERT INTO Teacher (Title, Surname) VALUES ("Mr","Alford");

c)

INSERT (Title, Surname) VALUES ("Mr","Alford") INTO Teacher;

d)

INSERT (Title, Surname) VALUES ("Mr","Alford") FROM Teacher;

35.

Software that is "fit for purpose" is efficient and easily maintained.

a)

True

b)

False

36.

Which term is used to describe the fact that software should be able to be used by ALL types of users?

a)

Accessibility

b)

Useability

c)

Optimisation

37.

Which term is used to describe software that does not crash easily with unexpected input?

a)

Fit for purpose

b)

Reliable

c)

Robust

d)

Efficient

38.

What type of interface would only suit an expert user?

a)

Menu Driven

b)

GUI - Graphical User Interface

c)

WIMP - Windows Icon Menu Pointer

d)

Command Driven

39.

Wireframes are used to design user interfaces to

a)

determine the layout of the screen

b)

be a visual guide used to communicate the specifications to the user

c)

determine the content layout, navigation and interface requirements

d)

provide a visual layout of the page content

40.
Which of the following cannot be created by JavaScript?
a)
Displaying the time of day
b)
Validating a web form
c)
Connecting to a database
d)
Creating an interactive menu
41.
Which method is more secure for transferring data?
a)
$GET
b)
$POST
42.
Which of the following is false about client side scripts?
a)
They rely on the user's computer.
b)
They should not be used to transfer sensitive data.
c)
They are used to retrieve sensitive data from a server.
d)
They can use $GET and $POST methods.
43.
Which answer will complete the SQL statement correctly to display all records where the employees name in the field 'first' is 'Eric' using the database empinfo ?
a)
select * from empinfo where first = 'Eric';
b)
search all from empinfo where first = 'Eric';
c)
select * from employee where first = 'Eric';
d)
select * from empinfo where first = 'Eric';
44.
Which of the following is not a method for optimising the loading times of a website?
a)
Compress videos
b)
Use embedded stylesheets and scripts
c)
Use external scripts and stylesheets
d)
Eliminate code that is not needed.
45.
A 'bot' that is used to scan HTML for key words, meta tags and other information for search engines is known as 
a)
A web crawler
b)
meta data
c)
a meta tag
d)
phishing
46.
______ testing involves users outside of the design process using real world test data in order to test the website.
a)
Alpha
b)
Beta
c)
Compatibility
d)
None of these
47.
Which type of testing is concerned with ensuring that an information system, for example, can function correctly on a laptop, phone, desktop and tablet?
a)
Usability testing
b)
Debugging
c)
Compatibility testing
d)
Alpha testing
48.
The type of testing concerned with screen layout, navigation, target audience and finding information is primarily
a)
Debugging
b)
Alpha testing
c)
Beta Testing
d)
Usability testing
49.

Which best explains the differences between a flat file and a relational database?

a)

Flat files only have one table

b)

Flat files only have one table and are prone to data inconsistencies unlike relational databases

c)

Relational databases have multiple tables to avoid data anomalies which are commonplace in flat file databases

50.

Validation of data is conducted to ensure

a)

That any data entered is correct

b)

That any data entered is accurate

c)

That any data entered is acceptable and sensible

d)

That any data entered is accurate and sensible

51.

A foreign key

a)

is a primary key in its own table and used in a second table to create a link between them

b)

is a field in both tables used to create a link between them

c)

is a primary key used in two tables to create a link between them

d)

is where the primary key is made up of two or more fields

52.

Change the border size of the body or image

a)

border-style

b)

border-width

c)

border-color

d)

width

53.

sets the element to one side of the page

a)

margin

b)

width

c)

float

d)

height

54.

sets the color of words in a paragraph

a)

h1 {

color: pink;

}

b)

img {

color: pink;

}

c)

body {

color: pink;

}

d)

p {

color: pink;

}

55.

What does a class do?

a)

adds color to words

b)

adds style to specific elements

c)

adds style to a whole page

d)

adds a lot more work

56.

Select the rule set to make all the text in your web page blue and centered.

a)

p {

color: blue;

}

b)

body {

text-align: left;

color: blue;

}

c)

p {

text-align: center;

color: blue;

}

d)

body {

text-align: center;

color: blue;

}

57.

Which selector will change the font of the text?

a)

font-size

b)

text-align

c)

font-famiy

d)

text-decoration

58.
What is the difference between an HTML Tag and an HTML element?
a)
An HTML Tag is case sensitive and an HTML element is not case sensitive.
b)
An HTML Tag is always paired and an HTML element is an "empty" tag.
c)
An HTML Tag defines content and an HTML Element includes the opening and closing tags and everything in between.
d)
An HTML Tag defines content and an HTML Element gives additional meaning and content.
59.
John wants the name of his book to appear in search results for Google. Where should this information be
placed within his webpage?
a)
head
b)
meta
c)
body
d)
nav
60.
Which item refers to the start tag, the end tag and everything in between?
a)
HTML Element
b)
HTML Tag
c)
HTML Attribute
d)
CSS
61.
Which tag defines the visible content of a web document?
a)
<head>
b)
<meta>
c)
<title>
d)
<body>
62.
Which line of code correctly places a gif image named "tiger" into a webpage?
a)
<img src="tiger" alt="BengalTiger" />
b)
<img gif=tiger alt="BengalTiger">
c)
<image source="tiger.gif" alt=BengalTiger" />
d)
<img src="tiger.gif" alt="BengalTiger" />
63.
Which hyperlink shows an absolute link?
a)
href="www.nytimes.com">NYTimes</a>
b)
<a href="page1.html">Page One<a>
c)
<a href="http://www.target.com">Target<a>
64.
what does the following tag do <div>
a)
defines a division or a section in an HTML document
b)
defines all the divas in the classroom
65.
Defines a division or a section in an HTML document. Used to group block-elements to format them with CSS
a)
<div>
b)
<span>
c)
<caption>
d)
<group>
66.
used to group inline-elements in a document
a)
<span>
b)
<div>
c)
<elements>
d)
<group>
67.

Which statement allows us to add a record to a table?

a)

Add To

b)

Update To

c)

Add Into

d)

Insert Into

68.

Which word is missing from the following SQL statement?


Select * table_name

a)

With

b)

Where

c)

From

d)

And

69.

What is the correct order of clauses in a SQL statement?

a)

SELECT, FROM, ORDER BY, WHERE

b)

SELECT, FROM, WHERE, ORDER BY

c)

SELECT, WHERE, FROM, ORDER BY

d)

WHERE, FROM, SELECT, ORDER BY

70.

You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?

a)

UPDATE Designer SET PhoneNo = '01224123456'

b)

UPDATE Designer (PhoneNo) VALUES ('01224123456')

c)

UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'

d)

UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'

71.

How would you display Chairs in the Items table that have a Price greater than £50.

a)

SELECT * FROM Items WHERE Type = 'Chair' AND Price > 50

b)

SELECT * FROM Items WHERE Type = 'Chair' OR Price < 100

c)

SELECT * FROM Iterms WHERE Type = 'Chair' AND Price >= 50

d)

SELECT * FROM Items WHERE Price > 50

72.

Which SQL statement would add a record to the database?

a)

INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

b)

INSERT VALUES ('SMI01', 'M Smith', 'mail@msmith.com', 01224123456') INTO Designer

c)

INSERT ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') INTO Designer

d)

INSERT Designer INTO VALUES (''SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

73.

Match the following SQL term with a description - ORDER BY

a)

The fields to display

b)

The field and order used to sort the results

c)

The table used in the query

d)

The criteria that must be met

74.

Identify the guidelines for group functions and the GROUP BY clause. (choose 2 answers)

a)

You cannot use a column alias in the GROUP BY clause.

b)

The GROUP BY column must be in the SELECT clause.

c)

By using a WHERE clause, you can exclude rows before dividing them into groups.

d)

The GROUP BY clause groups rows and ensures order of the result set.

75.

Using a subquery is equivalent to performing two sequential queries and using the result of the first query as the search values in the second query.

a)

True

b)

False

76.
Return only the customers who have ER anywhere in their last name. 
a)
last_name LIKE "%er%"
b)
last_name = "%er"
c)
last_name = "%er%"
d)
last_name LIKE "%er"
77.
AVG, COUNT, MAX, MIN and SUM are known as what?
a)
Aggregate functions
b)
Wildcard filters
c)
Subqueries
d)
Calculated field
78.

In the Fetch- Decode - Execute cycle, it doesn’t matter which order things take place

a)

True

b)

False

79.
During the Fetch-Decode-Execute cycle, the software to be run is located in main memory (RAM)
a)
True
b)
False
80.

Which Register is the first to be accessed during the Fetch- Decode- Execute cycle?

a)

PC

b)

MAR

c)

MDR

d)

CIR

81.

What Do the letters PC stand for in the PC Register

a)

Program Counter

b)

Process Counter

c)

Programmer Counter

d)

Counter Strike

82.

What does the MAR stand for?

a)

Memory Address Register

b)

Memory Addressed Register

c)

Memory Access Register

d)

Memory Aardvark Register

83.

The Fetch-Decode-Execute cycle runs continuously when the computer is turned on.

a)

True

b)

False

84.

When something is loaded from memory, where is it first stored?

a)

The CIR

b)

The MAR

c)

The MDR

d)

The ALU

85.
The MAR holds the contents of the memory location
a)
True
b)
False
86.

What is the name of the unit in CPU that controls and coordinates all parts of the computer system?

a)

Arithmetic unit

b)

Logic unit

c)

Control unit

d)

Registers

87.

What is the name of the unit in the CPU that performs arithmetic and logic operations?

a)

ALU

b)

CU

c)

MAR

d)

MDR

88.

What happens simultaneously as the data is moved to the Memory Address Register?

a)

The instruction is executed

b)

The ALU is prepared to execute arithmetic or logic operations

c)

Data is sent via the data bus to the ALU

d)

The Program Counter is incremented with the memory address of the next instruction to be "fetched"

89.

Used to transmit data between areas of the processor.

a)

Data bus

b)

Address bus

c)

Control bus

90.

Which of these statements about agile is correct

a)

There is a continuous delivery of software from the early stages of the software

b)

someone who is agile can do sick flips

c)

agile is a software development method

d)

agile is linear approach to software development

91.

what are the three types of maintenance

a)

Corrective, Adaptive, Perfective

b)

Flex tape, WD 40, Super glue

c)

Fix, Repair, Maintain

92.

Which of these methods involves the end users the most?

a)

Waterfall

b)

Agile

c)

Telling them to do it themselves

d)

RAD

93.

Out of agile, waterfall and RAD...

a)

waterfall is the fastest method for developing software

b)

agile is the least adaptive

c)

RAD has the lowest user involvement

d)

agile splits the project into a number of small independent modules

94.

What is 0.125 in fixed point binary (4 bits for the whole number / 4 bits for fractional part)?

a)

10001000

b)

00000010

c)

00001000

d)

00011000

95.
Real numbers are represented using a mantissa and an exponent.  What is the effect of increasing the number of bits used for the mantissa?
a)
The precision/accuracy increases
b)
The precision/accuracy decreases
c)
The range increases
d)
The range decreases
96.
State the type of relationship between doctors and patient
a)
One-to-one
b)
One-to-many
c)
Many-to-many
97.
State the type of relationship between schools and head teachers
a)
One-to-one
b)
One-to-many
c)
Many-to-many
98.
What are the main advantages RAD and Agile methodologies have over the traditional 'waterfall' software development process?
a)
The client is continually involved and developers can respond to changes in the specification during development
b)
The developers are not pestered by the client continually so can work faster
c)
RAD and Agile are better suited to very large complex projects
d)
RAD and Agile are faster, cheaper and better just because
99.
These are added to variables in s program.  When the variable is changed, program execution is halted allowing the programmer to identify what made the change.  This is a...
a)
Breakpoint
b)
Watchpoint
100.
These are added to a line of code in a program.  When this line is reached, program execution is halted allowing the programmer to examine the values held in the variables.  This is a...
a)
Breakpoint
b)
Watchpoint
101.
This type of subprogram returns a single value which can be assigned to a variable.
a)
Subprocedure
b)
Function
102.
1. Set up the address bus with the address to be accessed
2. ???
3. Memory accesses relevant location
4. Transfer the data from RAM to CPU registers via the Data Bus
5. Decode and execute
a)
Activate Address Bus
b)
Activate Read line on Control Bus
103.
When registering for a new music streaming service, you have to chose a username.  What check may need to be performed on the chosen username?
a)
Restricted Choice Check
b)
Range Check
c)
Check to ensure it is unique
d)
Validation Check

Similar Resources on Wayground

JARINGAN FIBER OPTIC

100 questions

JARINGAN FIBER OPTIC

quiz

Worksheet

•

11th Grade

Eras Technology Test

99 questions

Eras Technology Test

quiz

Worksheet

•

12th Grade

Year 9 Big Fat QUIZ of the Year

108 questions

Year 9 Big Fat QUIZ of the Year

quiz

Worksheet

•

9th - 12th Grade

Soal Ms. PowerPoint

100 questions

Soal Ms. PowerPoint

quiz

Worksheet

•

12th Grade

Mundos Digitales - Examen Diagnóstico

100 questions

Mundos Digitales - Examen Diagnóstico

quiz

Worksheet

•

10th Grade - University

Word Within The Word Lists 1-4

100 questions

Word Within The Word Lists 1-4

quiz

Worksheet

•

3rd Grade - University

Computer Science Revison

100 questions

Computer Science Revison

quiz

Worksheet

•

11th Grade

Electronics I PreTest

98 questions

Electronics I PreTest

quiz

Worksheet

•

9th - 12th Grade