Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

GCSE Terms

Total questions: 69

Worksheet time: 42mins

Name
Class
Date
1.
The SQL command to choose the data to be displayed in a query
a)
SELECT
b)
SHOW
c)
FROM
d)
WHERE
2.
The SQL command to choose which tables the data for the query will be taken from
a)
SELECT
b)
WHERE
c)
FROM
d)
SHOW
3.
What does * mean in the following query: SELECT * FROM Customers
a)
Nothing
b)
All records
c)
All rows
d)
All records containing *
4.
Complete the following SQL query to find all records for surname = "Khan":
SELECT * FROM Customers ......
a)
surname = "Khan"
b)
WHERE surname = "Khan"
c)
AND surname = "Khan"
d)
WHEN surname = "Khan"
5.

What information is stored as metadata?

a)

width, height, colour depth, colour index

b)

height, colour depth, colour index, bit ratios

c)

hex to binary lookup, width, colour table, bit management

d)

pixel count, colour depth, colour index, bit ratios

6.

How many colours are available for an image where the colour depth is 3?

a)

2

b)

4

c)

3

d)

8

7.
what is the task of the DNS?
a)
translate a domain name into the correct IP address
b)
translate an IP address into a domain name
c)
Gives names to websites which aren't named
d)
Leaves websites alone
8.
A LAN makes use of external hardware such as satellites and phone lines
a)
True
b)
False
9.
Which protocol is responsible for sending/receiving packets on the internet?
a)
Http
b)
Ftp
c)
IMAP
d)
TCP/IP
10.

What network topology is this?

a)

STAR

b)

BUS

c)

RING

d)

MESH

11.

What network connection type is this?

a)

Mesh

b)

Star

c)

LAN

d)

WAN

12.

How many layers are in the TCP/IP model?

a)

4

b)

7

c)

5

d)

6

13.

What does the Application do when receiving a file?

a)

Encodes the data

b)

Displays the data

c)

Splits it into packets

d)

Attaches the MAC addresses

14.

Which order are the layers in when receiving data?

a)

Link, Network, Transport, Application

b)

Application, Transport, Network, Link

c)

Link, Transport, Network, Application

d)

Application, Network, Transport, Link

15.
What frequencies does Wi-Fi use in the UK?
a)
2.4GHz, 5GHz and 9GHz
b)
2.6GHz, 3.9GHz an
c)
1.2GHz and 5GHz
d)
2.4GHz and 5GHz
16.

There is no centralised storage so each workstation stores data independently.

a)

Peer to peer

b)

Client / server

17.

With a central backing store, regular backups can be organised or implemented easily.

a)

Peer to peer

b)

Client / server

18.

What is the difference between HTTP and HTTPS?

a)

HTTPS encrypts information

b)

HTTP encrypts information

c)

HTTPS routes the packets

d)

HTTP is a newer version

19.

What is the technical word for 'Delay'?

a)

Bandwidth

b)

Latency

c)

Backbone router

d)

Web Server

20.

Which layer splits data into packets?

a)

Transport Layer

b)

Application Layer

c)

Network Layer

d)

Link Layer

21.

Which of the following are stored in RAM?

a)

Boot up instructions

b)

Saved work

c)

Programs

d)

Programs and data currently in use

22.

Virtual Memory is ...

a)

Cloud storage

b)

Data that cannot be edited

c)

part of the computers hard drive is treated as RAM

d)

volatile memory

23.

The part of the CPU that performs calculations and logic operations

a)

Register

b)

Control Unit

c)

Clock

d)

Arithmetic/logic unit (ALU)

24.

A higher sample rate means (tick all that apply)

a)

A better quality/more accurate recording

b)

A lower quality/less accurate recording

c)

A larger file size required to store the final recording

d)

A small file size required to store the final recording

25.

When recording a sound, computers take measurements at regular intervals. This is called

a)

Interval selection

b)

Parameters

c)

Sampling

d)

Digital signals

26.

Which legislation governs the act of intellectual property theft? (1-4)

a)

The Copyright, Designs and Patents Act

b)

The Data Protection Act

c)

The Freedom of Information Act

d)

The Computer Misuse Act

27.

Which legislation governs the act of hacking? (1-4)

a)

The Freedom of Information Act

b)

The Data Protection Act

c)

Creative Commons License

d)

The Computer Misuse Act

28.

Which of these is true about the Freedom of Information Act? (3-6)

a)

An individual has the right to have any of their personal data corrected that is inaccurate or out of date

b)

An individual has the right to compensation if their personal data is stolen

c)

An individual has right of access to information held by public authorities

d)

An individual has the right to share any intellectual property they have

29.

Why would an author obtain a Creative Commons License? (5-9)

a)

To stop the public sharing their work

b)

To make sure their work has a patent

c)

To make sure they are able to legally sell their work

d)

To give the public the right to share, use and build upon work they have created

30.

Which of the following statements is true about open source software? (3-6)

a)

The software cannot be copied, modified or shared

b)

The software can be copied, modified or shared

c)

There is normally a cost to pay for a license to use the software

d)

The software is not available for public use

31.

Which of the following statements is false about proprietary software? (3-6)

a)

The software cannot be copied, modified or shared

b)

The software can be copied, modified or shared

c)

A fee is usually required to purchase a software license

d)

An example of the software is the Microsoft Office suite

32.

Hayley has designed a new web app. She thinks another company is changing her idea. Which act would Hayley use to stop this person from doing this?

a)

Creative Commons Licence

b)

Computer Misuse Act

c)

Copyright designs and Patents Act

d)

Freedom of Information Act

33.
What happens if you increase the clock speed?
a)
CPU can process instructions quicker
b)
CPU can process more instructions at the same time
c)
CPU will explode
d)
CPU processes too fast for the cache to handle
34.
What happens if you increase the number of cores
a)
CPU can process instructions quicker
b)
CPU can process more instructions at the same time
c)
CPU will explode
d)
CPU processes too fast for the cache to handle
35.

Which of these are not a steps in the FDE cycle?

a)

Instructions are fetched from main memory

b)

Instructions are decoded in the control unit

c)

The decoded instruction is executed

d)

The ALU decodes the instructions

e)

The program counter transfers the data to be decoded to the MDR

36.

Which of the following has the largest memory?

a)

RAM

b)

Cache

37.

Which of the following is the fastest memory?

a)

RAM

b)

Cache

38.
Where are the results of calculations stored?
a)
Accumulator
b)
ALU
c)
MDR
d)
CIR
39.

Which of the following are not secondary storage devices?

a)

Hard Drive

b)

USB Stick

c)

CD

d)

RAM

e)

Registers

40.
Which of the following is an example of 'main memory'.
a)
Hard Drive
b)
USB Drive
c)
RAM
d)
ROM
41.
What is the program counters job?
a)
To count the programs
b)
It contains the memory address of the next instruction to be loaded
c)
It stores instructions
d)
It carries out the calculations
42.
What are registers used for?
a)
To check that students are in school.
b)
To temporarily hold bits of data needed by the CPU.
c)
To make sure that the CPU runs properly.
d)
To make the CPU faster.
43.
How can a bigger cache improve CPU performance?
a)
By being able to carry out more calculations
b)
By being able to store more recently used instruction inside the CPU for quicker access times
c)
By being able to 
44.
What is the purpose of the Memory Address Register (MAR)?
a)
Holds the location in memory (address) of the next piece of data or program to be fetched (or stored).
b)
Stores result of fetch from memory which is either an instruction or data. It receives instructions or data from memory via the data bus.
45.
What is the purpose of the Memory Data Register (MDR)?
a)
•Stores the result of fetch from memory which is either an instruction or data.
b)
Holds the location in memory (address) of the next piece of data or program to be fetched (or stored).
46.
What is the purpose of the Accumulator?
a)
•Holds the current instruction to be executed, having been fetched from memory. •Contents are transferred to control unit for decoding.
b)
•Stores a running total of the calculation that is currently being executed.
47.
Which of the following is an ADVANTAGE of Hard Disk Drives over Solid State Drives?
a)
Faster Performance
b)
Usually More Storage Space
c)
More Quiet
More Quiet
d)
None of the Above
48.
Which of the following is an example of a count controlled loop?
a)
While.... do
b)
Repeat.... until
c)
For..... next
49.
A section of a program containing the keyword if in Python is an example of what?
a)
Sequence
b)
Selection
c)
Iteration
50.
Which of the following contains syntax errors?
a)
for index in range(1, 5, -1):
b)
While x > 3
c)
if fred == name:
51.
name = "NEWSPAPER". Which of the following will NOT print out the 'S'?
a)
print("NEWSPAPER"[3])
b)
print(name[3])
c)
print(name(3))
d)
print(name[3:4])
52.
length is an example of a...
a)
Argument
b)
Parameter
c)
Variable
d)
Procedure call
53.
The drawSquare subprogram is an example of a...
a)
Function
b)
Procedure
54.
A function...
a)
Never has parameters
b)
Always returns a value
c)
Must has parameters
d)
Does not return a value
55.
The keyword in Python to tell that you are writing a function is...
a)
function
b)
def
c)
result
d)
return
56.

An algorithm can be defined as...

a)

...defined set of steps that can be used to complete a task

b)

...a set of steps that can be used to complete a task

c)

a random set of steps that can be used to complete a task

d)

an order of doing things correctly to complete something

57.

Sequence is when...

a)

...instructions are executed one after another

b)

instructions are executed one after another in a series

c)

instructions are executed by the user

d)

instructions are executed one after another but not always in series

58.

In computer programming 'iteration' is used to...

a)

... loop around and around a piece of code until the correct answer is chosen

b)

...loop around a piece of code until a condition is met that activates the next part of the program

c)

...loop around and around a piece of code until a condition is met that ends the iteration

d)

...loop twice around a piece of code until a condition is met that ends the iteration

59.

An assembler translator...

a)

...converts assembly language programs into machine code

b)

...converts programs created in any language into machine code

c)

...converts programs created in any high level language into machine code

60.

An interpreter is a translator that converts high level languages into machine code. It does this by...

a)

...working three lines at a time, checking syntax, converting to machine code and executing the code

b)

...working one line at a time, converting to machine code, checking syntax and executing the code

c)

...working one line at a time, checking syntax, converting to machine code and executing the code

d)

...working three lines at a time, converting to machine code, checking syntax and executing the code

61.

In programming a translator is used to convert different programming languages into machine code. There are three types...

a)

Assembler, interpreter & compiler

b)

Assembler, identifier & compiler

c)

Assembler, identifier & interpreter

d)

Compiler, identifier & interpreter

62.

Syntax is a set of rules that defines how program statements must be written in order for the translator to understand them. A syntax error is...

a)

...an error in the spelling of program statements

b)

...an error in the format of the program statements such as missing keywords

c)

...an error in the format of the program statements such as missing semi-colons or keywords spelt incorrectly

d)

...an error in the punctuation of program statements

63.

What is the main difference between a constant and a variable?

a)

A constant's value remains the same whereas a variable's value can change

b)

A constant's value only changes if a variable's value changes

c)

A constant's value remains the same whereas a variable's value can be changed by the user

d)

A constant's value remains the same whereas a variable's value can be changed, but only once

64.

A real number (or float) is a data type for fractional numbers that typically takes up 4 bytes of memory. Which of the following is a real number?

a)

26

b)

"26.0"

c)

260

d)

2.60

65.
Which protocol would you use to transfer files?
a)
FTP
b)
SMTP
c)
POP3
d)
HTTP
66.
What is an IP address?
a)
A way of sending information
b)
A way of indicating the location of a device
c)
A way of deleting viruses 
d)
A secure communication method. 
67.
It is a software code that is deliberately created by an attacker. 
a)
Virus
b)
worm
c)
Trojan
d)
Rootkit
68.
Protect an internal network from external attacks
a)
Antivirus 
b)
VPN
c)
Firewall
d)
AVIRA
69.
Firewalls remove viruses
a)
False
b)
True