Font size
WorksheetsThe Inevitable End-of-Year Quiz
Total questions: 79
Worksheet time: 49mins
Which of these are hexadecimal digits?
F
G
6
0
H
How many different values can be represented using 8 bits?
128
255
256
999
Which of the TCP/IP model layers is responsible for breaking down the message into packets?
Network
Application
Transport
Internet
An array with 32 elements is input to a binary search algorithm. How many maximum number of comparisons are performed?
32
16
8
5
How is the midpoint of the list calculated?
midpoint= round ((first_element+last_element)/2)
midpoint=(lower_bound+upper_bound)/2
midpoint= round ((lower_bound+upper_bound)/2)
midpoint= round ((lower_bound+upper_bound))
11, 8, 13, 9, 7, 3
The process of obtaining data or instruction fron memory is called...
Decode
Execute
Fetch
Store
What is the output?
True
False
When ordering binary numbers for a Karnaugh Map, which of the following is the correct sequence?
00, 01, 11, 10
00, 11, 10, 01
11, 10, 01, 00
00, 01, 10, 11
Identify the correct expression for this Karnaugh Map
A v ¬B
A ^ ¬B
A ^ B
A v B
Identify the correct expression for this Karnaugh Map
A ^ ¬ B v C ^ D
A ^ B v C ^ ¬ D
Which is the proper way to write an h1 tag
<h1>Hello</h1>
<h1>"Hello
{h1}Hello{/h1}
<h1>Hello<h1>
</p>
What is 6.625 in fixed point binary (4 bits for the whole number / 4 bits for fractional part)?
01101010
10001010
01101100
10001100
100101000011 (8 bit signed mantissa / 4 bit signed exponent) what is the decimal number?
9.25
-9.25
-6.75
6.75
What is the normalised form of 0.0000111 0111
1.0110000 0011
1.0110000 0111
0.1110000 0111
0.1110000 0011
With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?
SELECT * FROM Persons WHERE FirstName=’a’
SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
SELECT * FROM Persons WHERE FirstName=’%a%’
How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
Which query would return only the fields DesignerID and Designer?
SELECT * FROM Designers
SELECT DesignerID, Name FROM Designers
SELECT DesignerID AND Designer FROM Designers
SELECT DesignerID, Designer FROM Designers
How many records would be returned by the following SQL "SELECT * FROM songs WHERE Length < 3 AND Protected = True"?
0
2
3
4
The mnemonic for STORE in Little Man Computing is:
(a)
The mnemonic for LOAD in Little Man Computing is:
(a)
Assuming the inputs are 45 and 25 respectively, what would the output be?
INP
STA 50
INP
ADD 50
OUT
HLT
(a)
When will it be appropriate to use UDP instead of TCP?
Sending an email
Sending an image
Streaming Live
Sending a music file
What does TCP guarantee?
delivery of data and packets delivered in the right order
the route data will take
fast, low latency delivery of data
safe data without viruses
Which of the four layers in TCP/IP will choose the route the data will take?
Application
Internet
Link
Transport
Select TWO rules TCP/IP must follow?
Senders computer name
Packets are numbered
Error Check
None of the above
Which of these is NOT correct of packet switching?
Messages cannot be easily intercepted
Establishes a route on which to send data packets
Packets need to be re-ordered
Maximises the use of the network
Which is the right order for network layers
Application Link Transport Network
Application Transport Link Network
Application Transport Network Link
Transport Link Network Application
The following Syntax is used for?
class Subclass-name extends Superclass-name
{
//methods and fields
}
Polymorphism
Encapsulation
Inheritance
None of the above
When overloading a method, the method header ________ .
Must exactly match the header of the method you are overloading.
Must have the same name, but differ in order, number, or type of parameters.
Can differ in name, but must have the same number and order of parameters.
Can be completely different from the method you are overloading, but must have @Override.
Which of these are required for a relational database to meet 1st normal form?
Data must be atomic
No repeating groups of data
No repeating attributes
Sets of data must have a unique identifier
Must meet 2nd normal form
Process of inserting an element in stack is called ____________
Create
Push
Evaluation
Pop
If the elements “A”, “B”, “C” and “D” are placed in a queue and are deleted one at a time, in what order will they be removed?
a) ABCD
b) DCBA
c) DCAB
d) ABDC
If the sequence of operations - push (1), push (2), pop, push (1), push (2), pop, pop, pop, push (2), pop are performed on a stack, the sequence of popped out values
2,2,1,1,2
2,2,1,2,2
2,1,2,2,1
2,1,2,2,2
A Queue uses a front and rear pointer?
True
False
A Queue can only store 6 data items. The Queue is sent 4 data items: Bert, Cynthia, Cedric and Albert. Where does the "Rear" index pointer point?
0
1
2
3
Which of the Star Wars movies does Clive consider to be the best?
Return of the Jedi
Attack of the Clones
Revenge of the Sith
A New Hope
The Empire Strikes Back
What type of device is this? (Remote Control)
Input
Output
What is Clive's favourite decade for music?
60s
70s
80s
90s
00s
Which is Clive's favourite teaching group?
3
4
8
I couldn't say, it would be like choosing a favourite niece or nephew
None, he hates you all equally
