Font size
S
M
L
XL
WorksheetsA2 Revision
Total questions: 90
Worksheet time: 1hrs 2mins
Name
Class
Date
1.
What is the name of the type of network that doesn't have a server?
a)
Client/Server
b)
Peer to Peer
c)
Server to Server
d)
Client to Client
2.
Which protocol would you use to transfer files?
a)
FTP
b)
SMTP
c)
POP3
d)
HTTP
3.
HTTPS encrypts web page data before it is sent out of the browser.
a)
True
b)
False
4.
Name the highlighted part of the URL:
https://www.facebook.com/
https://www.facebook.com/
a)
Protocol
b)
Subdomain
c)
Domain
d)
Top-level Domain
5.
What is a data collision?
a)
When two devices on a network transmit data at the same time
b)
When one device on a network transmits data
c)
When two devices on a network transmit at separate times
6.
Forwarding data packets to their destination by the most efficient route. What is this?
a)
WAP
b)
Switch
c)
Router
d)
Network Cards
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 MAC address is
a)
A unique identifier for all devices on a network
b)
A set of numbers that identify a computer on a network
c)
A unique identifier for computers on a network
9.
Which protocol would you use to create a copy of the email from your email server?
a)
FTP
b)
SMTP
c)
POP3
d)
HTTP
10.
Which of these is NOT a feature of a data packet?
a)
Header
b)
Payload
c)
Packet number
d)
Colour of packet
11.
Which of these is a benefit of client-server network model?
a)
Easier to perform backups
b)
Easier to install and update software
c)
Store everything centrally
d)
All of these answers
12.
What is this piece of network hardware?
a)
Coaxial cable
b)
Ethernet cable
c)
Fibre optic
13.
What piece of computer hardware is this?
a)
Hub
b)
Switch
c)
Router
14.
What is the umbrella term for computer viruses?
a)
Malware
b)
Virus
c)
Worms
d)
Trojans
15.
Which protocol would download the email from to your computer and delete it from the server?
a)
FTP
b)
SMTP
c)
POP3
d)
HTTP
16.
Which device is this?
a)
Optical Disk
b)
Hard Drive
c)
Flash Memory
d)
Magnetic Tape
17.
What logic gate is this?
a)
AND
b)
OR
c)
NOT
d)
XOR
18.
What gate is this truth table for?
a)
AND
b)
OR
c)
NOT
d)
THE
19.
You can make changes to an object with
a)
methods
b)
attributes
c)
modifiers
20.
In OO programming, a "blueprint" for an object is called
a)
A sprite
b)
A class
c)
A modifier
d)
A variable
21.
Which of these is NOT associated with OOP?
a)
Inheritance
b)
Optimisation
c)
Polymophism
d)
Encapsulation
22.
Described as 'the pattern of making attributes in a class private'
a)
Encapsulation
b)
Inheritance
c)
Objects
d)
Polymophism
23.
class Vampire inherits Monster
hasCastle = true
public procedure drinkBlood()
hasCastle = true
public procedure drinkBlood()
a)
Encapsulation
b)
Inheritance
c)
Polymorphism
d)
Object
24.
Methods behave differently according to the context in which they are used
a)
Encapsulation
b)
Inheritance
c)
Polymorphism
d)
Objects
25.
class Car
private colour
private speed
private direction
Which is NOT an attribute?
private colour
private speed
private direction
Which is NOT an attribute?
a)
Car
b)
Colour
c)
Speed
d)
Direction
26.
Which of these is the quickest?
a)
RAM
b)
Cache L3
c)
Cache L2
d)
Cache L1
27.
True or False; a quad core will ensure your computer is twice as good at everything than a dual core processor
a)
True
b)
False
28.
What is 1100 in denary?
a)
8
b)
10
c)
12
d)
14
29.
What does the ALU do?
a)
Calculations and Logical comparisons
b)
Addition and subtraction only
c)
Compares two numbers
d)
Passes things to memory
30.
When running out of memory where does the computer store data that isn't being used
a)
Virtual Memory
b)
Virtual Storage
c)
Virtual Machines
31.
What is 11011111 in HEX?
a)
DF
b)
AB
c)
DE
d)
EB
32.
In programming which of these would represent a string?
a)
"hello world"
b)
#
c)
12
d)
12.3
33.
What is the purpose of the CPU?
a)
To process all the data and instructions.
b)
To turn the computer on.
c)
To create PowerPoint presentations.
d)
To provide power to the computer.
34.
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.
35.
Which CPU is likely to process data the slowest?
a)
1.6 MHz
b)
2.6 MHz
c)
1.6 GHZ
d)
2.6 GHZ
36.
LOAD r1,
LOAD r2,
ADD r1,
DIV r1, #2
LOAD r2,
ADD r1,
DIV r1, #2
a)
Machine Code
b)
High Level
c)
Assembly Language
37.
01010101010100101010100101010101010011111001000100001010100101
a)
Machine Code
b)
High Level
c)
Assembly Language
38.
Translate and execute source code –Line by Line, Statement by Statement.
a)
Interpreter
b)
Translator
c)
Compiler
d)
Assembler
39.
Name an element which doesn't have a closing tag.
a)
<img>
b)
<head>
c)
<body>
d)
<p>
40.
Which tag is used to underline text?
a)
<a>
b)
<u>
c)
<b>
d)
<I>
41.
What is the correct syntax for inserting an image?
a)
<image source="untitled.jpg"/>
b)
<img src="untitled.jpg"/>
c)
<src img="untitled.jpg"/>
d)
<img scr="untitled.jpg"/>
42.
What is the function of the <p> tag?
a)
Defines a paragraph.
b)
Makes the text purple.
c)
It pushes the text to the right.
d)
Prints the webpage.
43.
How do you center text?
a)
text-align: true;
b)
text-align: false;
c)
text-align: center;
d)
text: align center;
44.
Which is the opening tag for an html document?
a)
<html/>
b)
html>
c)
</html>
d)
<html>
45.
How do search engines find the websites that it indexes?
a)
You have to submit your website.
b)
By searching the web.
c)
The get a list from the government
d)
By using spiders to move from link to link finding pages.
46.
Iteration is
a)
Used in programming to select which statements will be executed next based on a condition
b)
Two or more statements following one after the other
c)
Performing a loop in a program to repeat a number of statements
d)
Finding errors in a piece of code
47.
Write 45 as a binary number
a)
00101111
b)
00011101
c)
00101011
d)
00101101
48.
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
49.
Which law allows employers to monitor electronic communications?
a)
Data Protection Act
b)
Computer Misuse Act
c)
Copyright, Design and Patents Act
d)
RIPA
50.
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
51.
To break a hard problem up into smaller, easier ones.
a)
Decompose
b)
Pattern
c)
Abstraction
d)
Algorithm
52.
Translate Assembly Language code into Machine Code
a)
Assembler
b)
Compiler
c)
Translator
d)
Interpreter
53.
Translate entire source code all in one go into Machine Code
a)
Compiler
b)
Assembler
c)
Translator
d)
Interpreter
54.
Which register within the CPU contains the intermediate value of a calculation?
a)
Accumulator
b)
Instruction Register
c)
Program Counter
d)
ALU
55.
Which factors could affect the performance of the CPU?
a)
The physical size of the CPU.
b)
The clock speed, number of cores and cache size
c)
How heavy the CPU is.
d)
How many fans the CPU has
56.
What does the BRA loop do in LMC?
a)
This will keep looping the program until you stop it.
b)
This will loop the program until a certain condition is met.
c)
This will loop the program until the accumulator is 0.
d)
This will loop the program until the accumulator is negative
57.
Which of these statements is true about a Von Neumann architecture?
a)
Programs and instructions are stored separately
b)
Programs and instructions are stored together
58.
Which life cycle is this?
a)
Spiral
b)
Waterfall
c)
Incremental
d)
V-shaped
59.
In a JavaScript, prompt()
a)
displays a prompt dialog box
b)
displays an alert dialog box
c)
displays a single line comment
d)
displays a JavaScript statemen
60.
In a JavaScript, a semicolon(;) is used to
a)
define a scripting language
b)
display an alert dialog box
c)
add a single line comment
d)
end a JavaScript statement
61.
In a JavaScript, a // is used to
a)
define the scripting language
b)
display an alert dialog box.
c)
add a single line comment
d)
end a JavaScript statement
62.
Which device would you use:
If you needed to store music and/or films
If you needed to store music and/or films
a)
Optical Disk
b)
Hard Drive
c)
Flash Memory
d)
Magnetic Tape
63.
Which device would you use:
To store relatively large amounts of data in your home computer
To store relatively large amounts of data in your home computer
a)
Optical Disk
b)
Hard Drive
c)
Flash Memory
d)
Magnetic Tape
64.
What is the purpose of a firewall?
a)
To detect viruses on a system and prevent them from attacking it and spreading
b)
To prevent unauthorised connections coming in to and out of a network
c)
To prevent a hacker from logging on to the network
65.
What word is missing from the line below?
SELECT *
_______ CUSTOMER;
SELECT *
_______ CUSTOMER;
a)
FROM
b)
WHERE
c)
SELECT
d)
ORDER BY
66.
A row in a database.
a)
Record
b)
Field
c)
Entity
d)
Table
67.
A column in a database.
a)
Field
b)
Record
c)
Entity
d)
Validation
68.
A rule to make sure that only reasonable and sensible data is entered.
a)
Filter
b)
Query
c)
Validation
d)
Verification
69.
Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...
a)
Data Types
b)
Filters
c)
Sorts
d)
Validations
70.
A data type used for storing numbers with a fractional part e.g. 3.142
a)
Integer
b)
Boolean
c)
Real / Float
d)
String
71.
A unique identifying field.
a)
Primary Key
b)
Integer
c)
Verification
d)
Boolean
72.
What is a database?
a)
A piece of software to do calculations
b)
A device to load information onto the computer.
c)
A structured collection of information
d)
A calculator
73.
Which of the following describes a relational database?
a)
Access
b)
A database that has a table
c)
There are two or more tables that are linked using the primary keys
d)
There are more than one table that have duplicate data
74.
A scout company have a database with records of all the scouts. They want to create a list of all scouts who are under 15 and their achievements. What would they use?
a)
SQL UPDATE command
b)
Form
c)
SQL SELECT Query
d)
Sort
75.
A health club wants to find all the members who use the club 3 days or more a week. What will they put in the query in the 'days' SQL query criteria?
a)
>3
b)
<3
c)
<=3
d)
>=3
76.
A DBMS is a
a)
Database management system
b)
Database multi system
c)
Data set management system
d)
Database merger system
77.
How many records would be returned with the following SQL command:
SELECT * FROM Students
WHERE Surname LIKE 'S%'
a)
1
b)
2
c)
3
d)
4
78.
Which logic gate is this?
a)
NAND
b)
NOR
c)
XOR
d)
NXOR
79.
NOT(A OR B) = Q, if A=0 and B=0, what does Q equal?
a)
1
b)
0
80.
How many inputs of a NOR gate must be 1 to output 1?
a)
none
b)
1
c)
2
d)
3
81.
Convert 00011011.0110 (Fixed Point Notation) to denary
a)
27.376
b)
27.375
c)
27.374
d)
27.377
82.
Convert 00110100.1000 (Fixed Point Notation) to denary
a)
52.25
b)
52.125
c)
52.5
d)
52.05
83.
Convert 0.1110000 0011 (Floating Point Binary) to denary
a)
-7.0
b)
7.75
c)
7.25
d)
7.0
84.
What is the sum of:
a)
01111011
b)
01101111
c)
01111101
d)
01101101
85.
What is the sum of:
a)
10010000
b)
10001000
c)
10000100
d)
10100000
86.
Is this an odd number or an even number:
0 1 0 1 1 0 0 1
0 1 0 1 1 0 0 1
a)
Odd
b)
Even
87.
What is the sum of:
a)
11000100
b)
00110111
c)
100111010
d)
011111101
88.
Convert 254 to binary
a)
11110000
b)
11111100
c)
11111111
d)
11111110
89.
Convert 11001100 to decimal
a)
224
b)
134
c)
104
d)
204
90.
Convert 01000100 to decimal
a)
58
b)
68
c)
78
d)
88
Reset
