wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Final Year 11 quiz

Total questions: 123

Worksheet time: 2hrs 30mins

Name
Class
Date
1.

Look at the Algorithm Below. In the corresponding Trace Table, what value should 'A' be?

a)

1

b)

3

c)

5

d)

7

2.

Look at the Algorithm Below. In the corresponding Trace Table, what value should 'B' be?

a)

1

b)

3

c)

5

d)

7

3.

Look at the Algorithm Below. In the corresponding Trace Table, what value should 'C' be?

a)

1

b)

3

c)

8

d)

13

4.

Look at the Algorithm Below. In the corresponding Trace Table, what value should 'D' be?

a)

11

b)

13

c)

8

d)

1

5.

Look at the Algorithm Below. In the corresponding Trace Table, what value should 'E' be?

a)

3

b)

5

c)

8

d)

13

6.

Look at the Algorithm Below. In the corresponding Trace Table, what value should 'F' be?

a)

5

b)

8

c)

13

d)

18

7.

Which of these is an example of an operating system?

a)

Windows

b)

Word

c)

Excel

d)

PS3

8.

What can an operating system do?

a)

Allow the hardware and software to communicate?

b)

Make a computer run faster

c)

Make tea

d)

carry out hospital operations

9.

Smart phones don't need operating systems, only computers do.

a)

True

b)

False

10.
What is processor speed measured in?
a)
Kilometers per hour Km/h
b)
Bits per second BPS
c)
Gigahertz GHz
d)
Megabits Mb
11.
What happens to RAM when the computer is switched off?
a)
Data is lost
b)
Data is stored
c)
Data is retained for 10 seconds
12.

Utility Programs that:

Reorganize all scattered data and restore file in contiguous location

a)

Program Uninstaller

b)

Disk Defragmenter

c)

Backup Utility

d)

Data Recovery Utility

13.

A small program that allows a specific peripheral device to communicate with a computer system

a)

Driver Programs

b)

Firmware

c)

Operating System

14.

Utility Programs that:

Recover corrupted / accidentally deleted data

a)

Program Uninstaller

b)

Disk Scanning Program

c)

Backup Utility

d)

Data Recovery Utility

15.

Utility Programs that:

Makes duplicate copy of selected file or entire hard disk

a)

Program Uninstaller

b)

Disk Scanning Program

c)

Backup Utility

d)

Data Recovery Utility

16.
The following is not a type of Systems Software (4-6) 
a)
Device Drivers 
b)
Utility Programs 
c)
Applications 
d)
Operating Systems 
17.
Dividing tasks so that the Operating System appears to multitask is dealt with under: (4-6) 
a)
Memory Management 
b)
File Management 
c)
Processor Management 
d)
Peripheral Management 
18.
Diving processor time between processes so that they appear to multitask is known as: (1-3) 
a)
Time Slicing 
b)
Fish Slicing 
c)
Time waiting 
d)
Idle Time 
19.
Operating Systems need to manage System _________? (1-3) 
a)
Objectives 
b)
Electricity 
c)
Restores 
d)
Resources 
20.
To allow a user to interact with an Operating System – it must have a ______ ? (1-3) 
a)
User Connection 
b)
User Interface 
c)
Virtual Connection 
d)
Remote Access 
21.
Windows, Icons, menus and Pointers are all part of this? (1-4) 
a)
Graphical User Interface 
b)
Command Line Interface 
c)
Menu Interface 
d)
No User Interface 
22.
Operating Systems will allocate sections of RAM to the processes as part of: (4-6) 
a)
Processor Management 
b)
File Management 
c)
Peripheral Management 
d)
Memory Management 
23.
This piece of software is used to control hardware devices and allow an Operating System to make use of the hardware (7-9) 
a)
Device Management 
b)
Device Driver 
c)
Device System 
d)
Hardware Peripheral Device 
24.

The Program Counter

a)

Stores the address of the next instruction in memory

b)

Stores the address of where the next item will be fetched from

c)

Stores data fetched from memory, or waiting to be stored in memory

d)

Stores the result of arithmetic calculations

25.

Memory Address Register (MAR)

a)

Stores the address of the next instruction in memory

b)

Stores the address of where the next item will be fetched from

c)

Stores data fetched from memory, or waiting to be stored in memory

d)

Stores the result of arithmetic calculations

26.

Memory Data Register (MDR)

a)

Stores the address of the next instruction in memory

b)

Stores the address of where the next item will be fetched from

c)

Stores data fetched from memory, or waiting to be stored in memory

d)

Stores the result of arithmetic calculations

27.

Accumulator

a)

Stores the address of the next instruction in memory

b)

Stores the address of where the next item will be fetched from

c)

Stores data fetched from memory, or waiting to be stored in memory

d)

Stores the result of arithmetic calculations

28.

The control unit

a)

Controls the flow of data around the CPU and also decodes instructions

b)

Only controls the flow of data around the CPU

c)

Only decodes instructions

d)

Controls how much power is directed to all components within the computer

29.

The Arithmetic Logic Unit (ALU)

a)

Carries out numerical calculations and logical decisions

b)

Calculates the different items of number data stored within the Accumulator and converts them into logical decisions

c)

Calculates graphic data as they are only found within GPU units.

d)

Calculates the flow of execution in a program and decodes instructions into small steps to be carried out by the program counter.

30.

Cache

a)

A small piece of memory within the CPU that remembers the most recent instructions.

b)

A small piece of memory in the RAM (Random Access memory that keeps the most recent instructions at the front of the queue for processing.

c)

A small piece of memory that remembers lots of different instructions from all of the programs you run. This means the startup time for your computer will progressively get quicker.

d)

A small piece of memory in the Hard Disk Drive that supports the fast action of the CPU.

31.

The CPU carries out instructions and the Memory stores them.

a)

True

b)

False

32.
Who developed the idea of a stored program computer and modern computer architecture?
a)
John Von Neumann
b)
Bill Gates
c)
Steve Jobs
d)
Tim Berners-Lee
33.
What connects the processor and memory?
a)
Buses
b)
Cache
c)
NIC
d)
Control Unit
34.
What are the 3 parts of the Von Neumann computer architecture?
a)
Processor (CU & ALU), Memory Unit & Input/Output
b)
Processor, RAM & ROM
c)
Processor, RAM & Hard Disk
d)
Memory (CU & ALU), Hard Disk & Input/Output
35.
Which of these buses is bi-directional?
a)
Data Bus
b)
Control Bus
c)
Address Bus
d)
Cache Bus
36.
The location of where data can be found in the computer memory is called the?
a)
Address
b)
Coordinates
c)
Register
d)
Cache
37.
The MDR, MAR, PC & CIR are all examples of..?
a)
Registers
b)
Addresses
c)
Buses
d)
Control Units
38.
Which of the following is not a register?
a)
CU
b)
MAR
c)
MDR
d)
PC
39.

What data type is used for whole numbers?

a)

Real/Float

b)

Integer

c)

String

d)

Boolean

40.

What data type is used for yes or no?

a)

Real/Float

b)

Integer

c)

String

d)

Boolean

41.

What data type is used for a combination of letters, numbers and symbols?

a)

Real/Float

b)

Integer

c)

String

d)

Boolean

42.

What data type is used for decimals including money?

a)

Real/Float

b)

Integer

c)

String

d)

Boolean

43.

Arrays can hold any data types as long as all the items are the same data types.?

a)

True

b)

False

44.

Which data type can hold items of different types?

a)

String

b)

Record

c)

Array

d)

Group

45.

What is the equivalent of a record in Python?

a)

String

b)

Array

c)

Function

d)

List

46.

Where can records/lists be stored in Python? Pick 2 places.

a)

Table/Database

b)

Cabinet

c)

Text File

d)

Case

47.

What data type would the items in a text file be treated as in Python?

a)

Real/Float

b)

Integer

c)

String

d)

Boolean

48.

What character is typically used to separate fields in a text file?

a)

Full stop .

b)

Hash tag #

c)

Exclamation Mark !

d)

Comma ,

49.

What application would I NOT use to create a text file?

a)

PowerPoint

b)

Notepad

c)

Excel

d)

Word

50.

What action would I NOT use on a text file?

a)

Open

b)

Close

c)

Write

d)

Examine

51.

In the client-server model, what is the primary protocol used for communication between a browser & web server?

a)

FTP

b)

TCP

c)

HTTP

d)

SSL

52.
Which email protocol allows an email client to download email messages to the local computer?
a)
IMAP4
b)
SMTP
c)
TCP
d)
POP3
53.
Which email protocol allows an email client to read mail stored on the mail server?
a)
IMAP4
b)
SMTP
c)
TCP
d)
POP3
54.
A network consists of five computers, all running Windows 10 Professional. All the computers are connected to a switch, which is connected to a router, which is connected to the Internet. Which networking model does the network use?
a)
Star-bus
b)
Ring
c)
Hybrid
d)
Peer-to-Peer
55.
A network consists of five computers. Four computers are running Windows 10 Professional. One computer has been upgraded from Windows 10 Professional to Windows Server 2016. All the computers are connected to a switch, which is connected to a router, which is connected to the Internet. Which networking model can the network support that it could not support without the upgrade?
a)
Hybrid
b)
Client-Server
c)
Star-bus
d)
Ring
56.
A network consists of seven computers and a network printer, all connected directly to one switch. Which network topology does this network use?
a)
Hybrid
b)
Mesh
c)
Star-bus
d)
Star
57.

What is a network protocol?

a)

Lets you connect to a device

b)

Agreed way of transferring files between devices on a network

c)

Agreed way of sending emails on a network

d)

Agreed way of checking files for errors

58.

What does TCP stand for?

a)

Transcript Control Protocol

b)

Transition Control Protocol

c)

Transmit Control Protocol

d)

Transmission Control Protocol

59.

IP (Internet Protocol) is responsible for packet switching

a)

True

b)

False

60.

Select TWO statements which TCP/IP process follows

a)

Request from client sent to server

b)

Packets are sent in order

c)

Packets are sent as one file

d)

Confirmation is sent back to confirm that packets have been received

61.

Select TWO rules TCP/IP must follow?

a)

Senders computer name

b)

Packets are numbered

c)

Error Check

d)

None of the above

62.

Select the network layer where IP address/Packet Number/Error check is completed.

a)

Application Layer

b)

Transport Layer

c)

Internet Layer

d)

Link/Physical Layer

63.

What does UDP stand for?

a)

User Data Protocol

b)

User Datagram Protocol

c)

User Date Protocol

d)

User Dynamic Protocol

64.

When will it be appropriate to use UDP instead of TCP?

a)

Sending an email

b)

Sending an image

c)

Streaming Live

d)

Sending a music file

65.

One of the advantages of UDP?

a)

Secure

b)

Larger

c)

Smaller

d)

Faster

66.

Which protocol holds the email until you actually delete it?

a)

POP3

b)

IMAP

c)

SMTP

d)

FTP

67.

Which protocol holds the email only until you receive it?

a)

SMTP

b)

FTP

c)

IMAP

d)

POP3

68.

What does HTTPS stand for?

a)

Hyper Text Transfer Protocol

b)

Hyper Text Transport Protocol Secure

c)

Hyper Text Transport Protocol

d)

Hyper Text Transfer Protocol Secure

69.

Which protocol is responsible for transferring computer files between client and server on a computer network?

a)

SMTP

b)

FTP

c)

TCP/IP

d)

HTTP

70.

Data packets can arrive at different times at the final location?

a)

True

b)

False

71.

Before data transmission begins, devices send messages to one-another, completing a task called?

a)

Data Transmission

b)

Handshaking Process

c)

Network Protocol

d)

Packet Switching

72.

What is a Debugger?

a)

A program that scans software.

b)

it is used when a program fails to compile or to run. Error messages are displayed to help the programmer diagnose what has gone wrong.

c)

A program which removes viruses.

d)

A program which helps locate, identify and rectify errors in a program.

73.

Which IDE facility displays the order in which the lines of a program are executed, and possibly the values of variables as the program is being run?

a)

A Trace

b)

A Copier

c)

A Line Numberer

d)

A Variable Counter

74.

What is a Break Point?

a)

A facility which breaks a while loop or an 'if' statement.

b)

A Facility which displays the current value of any variable. The value can be 'watched' as the program code is single-stepped to see the effects of the code on the variable.

c)

A facility which interrupts a program on a specific line of code, allowing the programmer to compare the values of variables against expected values.

d)

A film staring Keanu Reeves.

75.

Which IDE tool converts each line of source code into machine code, and executes it as each line of code is run?

a)

Compiler

b)

Variable Watch

c)

Memory Inspector

d)

Interpreter

76.

Which IDE tool converts all source code into executable machine code before sending it to the CPU?

a)

Loader

b)

Compiler

c)

Debugger

d)

Linker

77.

Which IDE tool allows a programmer to enter, format and edit source code.

a)

Linker

b)

Compiler

c)

Interpreter

d)

Editor

78.

What is a Break Point?

a)

A facility which breaks a while loop or an 'if' statement.

b)

A Facility which displays the current value of any variable. The value can be 'watched' as the program code is single-stepped to see the effects of the code on the variable.

c)

A facility which interrupts a program on a specific line of code, allowing the programmer to compare the values of variables against expected values.

d)

A film staring Keanu Reeves.

79.

What are error diagnostics used for?

a)

To debug lines of code.

b)

Used to interrupt the program flow if the watched variable reaches a specified value.

c)

To spot mistakes.

d)

Used when a program fails to compile or to run to help the programmer understand what has gone wrong.

80.

Which IDE tool displays the current value of any variable?

a)

A variable count

b)

A variable value

c)

A variable watch

d)

A variable location box

81.
An IDE checks programming code using a:
a)
Debugger
b)
Fault finder
c)
Breakpoint
d)
Compiler
82.
Modern IDEs assist programmers by:
a)
Automatically completing code
b)
Writing programs for the user
c)
Stopping any errors from being produced
d)
Removing the need to write any code at all
83.

The Binary Integer 01001101 is represented in Denary as:

a)

73

b)

75

c)

77

d)

79

84.

5.23 would be stored as:

a)

Integer

b)

Real Number

c)

String

d)

Character

e)

Boolean

85.

What is the binary number 0111 1101 in hexadecimal?

a)

AC

b)

9C

c)

9D

d)

8B

86.

What is the Hexadecimal number 7C in denary?

a)

83

b)

123

c)

141

d)

124

87.

Which of these is a floating point number?

a)

3

b)

3.0

c)

7

d)

5.6

88.

Which of these cannot be accurately stored as a floating point number?

a)

1/8

b)

2/3

c)

4.00000000000000000001

d)

4/4

e)

17/9

89.

Why do we use flowcharts?

a)

To represent and plan algorithms in an easy way

b)

To use different mathematical shapes

c)

The computer can read them

d)

It's more complicated

90.
Which data type is used to store:
TRUE
a)
Boolean
b)
Double
c)
String
d)
Integer
91.
Which data type is used to store:
"D"
a)
Character
b)
String
c)
Integer
d)
Double
92.
This data type is used to store a mixture of letters and numbers and symbols.
a)
String
b)
Character
c)
Boolean
d)
Integer
93.

What is a variable?

a)

A storage location of memory which can change

b)

A random area to store things in.

c)

Something that changes

d)

Something that can only store numbers

94.

What is a Constant?

a)

A storage location of memory which does not change

b)

A random area to store things in.

c)

Something that changes

d)

Something that can only store numbers

95.

What does "SQL" stand for?

a)

Structured Question Language

b)

Structured Query Language

c)

Simple Query Language

d)

Simple Question Language

96.

Which statement is used to extract data from a database?

a)

Extract

b)

Get

c)

Open

d)

Select

97.

If you were wanting to filter data, which clause would you use?

a)

Where

b)

Order by

c)

From

d)

Select

98.

Which character returns all the data found in a table?

a)

%

b)

#

c)

*

d)

/

99.

Which word is missing from the following SQL statement?


Select * table_name

a)

With

b)

Where

c)

From

d)

And

100.

How would we script a SQL query to select "Description" from the Item table?

a)

SELECT Item.Description

b)

EXTRACT Description FROM Item

c)

SELECT Item FROM Description

d)

SELECT Description FROM Item

101.

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

a)

SELECT * FROM Items ORDER BY Price ASCENDING

b)

SELECT * FROM Items ORDER BY Price ASC

c)

SELECT * FROM Items BY Price LOWEST TO HIGHEST

d)

SELECT * FROM Items ORDER BY Price DESC

102.

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

103.
Write a code for the following: Return the names and imdb_ratings of all movies with ‘day’ in the name.
a)
SELECT * FROM movies WHERE name LIKE ‘day’;
b)
RETURN  name, imdb_rating FROM movies WHERE name LIKE '%day%';
c)
SELECT name, imdb_rating FROM movies WHERE name LIKE '%day%';
d)
SELECT * FROM movies WHERE imdb_rating AND name LIKE ‘%day%’;
104.
A column in a database
a)
record
b)
row
c)
field
d)
data
105.
Which of these groups are in the six common operators?
a)
#=, ^=, $=
b)
=, !=, >=
c)
>^, <>, =+
d)
<+>, >=<, (<)
106.
What does a linear search do?
a)
Looks at the first item of data, then each one in turn, until it finds the data item requested
b)
Organises the data into alphabetical order
c)
Splits the data until the requested data is found
107.
What is an advantage of a linear search?
a)
It is very quick
b)
It only works with ordered lists
c)
It is a simple algorithm
108.
What does a binary search do?
a)
Looks at the first item of data, then each one in turn, until it finds the data item requested
b)
Converts all the data into binary
c)
Takes the data and splits it in half repeatedly until it finds the data item requested
109.
Which search algorithm would be best to use with ordered data?
a)
A binary search
b)
Either binary search or a linear search
c)
A linear search
110.
What is an advantage of a binary search
a)
It's very quick
b)
It only works with ordered lists
c)
It is a simple algorithm
111.
What is the biggest disadvantage of a binary search?
a)
It is slow
b)
It can only be used if the data is sorted into an order
c)
It takes the data and keeps dividing it in half until it finds the item it is looking for
112.
Which of the following is not a sorting algorithm?
a)
Bubble Sort
b)
Long Sort
c)
Insertion Sort
113.
How many passes will a bubble sort go through?
a)
Only one pass
b)
Two passes
c)
Several passe - until the data is fully ordered
114.
Why does a bubble sort do a final pass even when the data is in the correct order?
a)
To save the data
b)
It does not recognise that the data is in order until the final pass requires no changes
c)
It needs to do this to put the data back in to a list
115.
Which of the following is an advantage of a bubble sort?
a)
It is a very small and simple computer program
b)
It takes a very long time to run
c)
It is very quick
116.
What does an insertion sort do?
a)
Separates a list of data into different collections of data which are sorted and gathered back into a list
b)
Goes through a list of data a number of times and compares two items that are side by side to each other to see which is out of order
c)
Goes through a list, comparing two items that are side by side, and continues to move one value until it is in the correct place.
117.
Which of the following is an advantage of a insertion sort when compared with a bubble sort?
a)
It is quicker than a bubble sort algorithm
b)
It is simpler than a bubble sort algorithm
c)
There is no advantage.
118.
How many passes will an insertion sort go through?
a)
Only one pass
b)
Two passes
c)
Several passes - until the data is fully ordered
119.
Which type of sort algorithm is this?
a)
Bubble
b)
Merge
c)
Insertion
120.
Breaking a complex problem down into smaller problems and solving each one individually.
a)
Decomposition
b)
Abstraction
c)
Programming
d)
Algorithmic Thinking
121.
What is abstraction?
a)
The process of filtering out unnecessary detail.
b)
The process of filtering out irrelevant characteristics
c)
The process of filtering out irrelevant characteristics and unnecessary detail.
122.
Which of the following is an example of thinking computationally?
a)
Planning out your route when going to meet a friend
b)
When going to meet a friend, wandering around until you find them
c)
When going to meet a friend, asking a parent to plan your route for you
123.
What is Abstraction?
a)
The use of computers to solve problems.
b)
Representing 'real world' problems in a computer using variables and symbols and removing unnecessary elements from the problem
c)
Breaking down a large problem into smaller sub-problems.
d)
Identifying the steps involved in solving a problem.

Similar Resources on Wayground

PAS Genap IPA Fisika Kelas X A

120 questions

PAS Genap IPA Fisika Kelas X A

quiz

Worksheet

•

10th Grade

G10-TLE-Computer-2022-2023

121 questions

G10-TLE-Computer-2022-2023

quiz

Worksheet

•

10th Grade

Đề Cương Ôn Tập HK2 TIN HỌC 10

120 questions

Đề Cương Ôn Tập HK2 TIN HỌC 10

quiz

Worksheet

•

10th Grade

Q3 Study Guide

125 questions

Q3 Study Guide

quiz

Worksheet

•

9th - 12th Grade

IGCSE Pseudocode Practice

119 questions

IGCSE Pseudocode Practice

quiz

Worksheet

•

9th Grade

Latihan ASLM Informatika

119 questions

Latihan ASLM Informatika

quiz

Worksheet

•

9th Grade

Graphic Design MP3 Review

119 questions

Graphic Design MP3 Review

quiz

Worksheet

•

9th Grade

Vocabulary Test

123 questions

Vocabulary Test

quiz

Worksheet

•

9th Grade