WorksheetsYear 12 Summative Review - Nov 2022
Total questions: 50
Worksheet time: 26mins
First Step of the FETCH
The CPU reads the contents of the Program Counter to find the address of the next instruction to be fetched
The address in the MAR is then located in RAM
The contents of the RAM address are moved to the MDR
The instruction in the MDR is copied to the CIR
In the EXECUTE stage the result of a calculation is stored in the ..
ALU
MDR
Control Bus
Accumulator
Operand
The PC contains
Operand
Address
Operator
Data
What is the YELLOW REGISTER
ACC
MAR
CIR
RAM
What is the missing label?
storage
bus
output
CPU
There are 3 buses in von Neumann architecture. The data bus, the control bus and ???
address bus
instruction bus
processor bus
arithmetic bus
The speed of the clock is measured in cycles per second. This is expressed as .....?
gigabytes (GB)
megabytes (MB)
gigahertz (GHz)
cps (cycles per second
What is a register?
performs calculations in the ALU
a very fast part of main memory
part of the control unit
a small piece of very fast memory in the CPU
Lower energy requirements and can go into “sleep mode” when not actively processing
CISC
RISC
Multiple machine cycles per instruction
CISC
RISC
Compiler has to do more work
RISC
CISC
Cannot support pipelining
CISC
RISC
Which among the choices is optical storage ?
Back to the future
Which among the choices is magnetic storage ?
Back to the future
Which among the choices is solid state storage ?
Back to the future
Compact Disc - Read-Only Memory (CD-ROM) discs can hold around __________ of data
25 - 50GB
4.7GB
800MB
The CPU fetches instructions from.... and executes those instructions.
Memory
ALU
ROM
Input Device
Why is Virtual Memory needed in a computer system?
It is used as a fast type of memory for programs currently in use to speed up the performance of a computer.
When RAM gets full, instead of closing programs the Operating system uses virtual memory to store some data.
Which type of CPU Scheduling handles processes based on the arrival order?
First-Come, First-Served
Shortest-Job-First
Round Robin
Priority
Which algorithm is defined in Time quantum?
Shortest Job First
Round Robin
Priority
Multilevel Queue
The graphics display card will function properly without installing device driver.
TRUE
FALSE
Devices may work, but all of its features may not work properly if the driver is not installed.
TRUE
FALSE
True or False: Virtual machines can be isolated so for testing malware without damage to the host machine or network.
True
False
A virtual machine is:
a hardware emulation of another system
a software emulation of another system or program
a method of backing up data
Which of the following is not 'proprietary' software?
Windows 10
MAC OSX
Linux
McAfee
Which of the following is an advantage of 'open source' software?
You can edit the source code to customise it
You need to be an expert to edit code
Source code not made available
License restricts the copying / modifying / distribution of the software
Which of the following is a disadvantage of 'proprietary' software?
You can edit the source code to customise it
It may have bugs, since updates are not readily available
Less likely to have 'bugs' as updates are regular to fix them
May have features within the software you don't need, source code can't be changed.
THE ' * ' symbol in a query does what?
select fields with * in the data from the table
Select the fields written after it from the table
Select all fields from the table
This symbol is Not used in SQL
What kind of database we and SQL will be mostly deal with ?
Hierarchical Database
Network Database
Relational Database
Object oriented database
SELECT * FROM Students WHERE Gender="Female" AND Class=2.2
would return how many records?
1
2
3
4
With SQL, how can you insert a new record into the "Persons" table?
INSERT ('Jimmy', 'Jackson') INTO Persons
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
What does SQL stand for?
Structured Query Language
Strong Question Language
Structured Question Language
The first ever hard disk drive was made in 1979. What was its storage capacity?
5MB
250MB
500MB
1GB
A Caesar cipher encrypts the plaintext Et tu, Brute into the ciphertext ix xy, fvyxi. What would the same cipher encrypt it was Greek to me into?
mx aew kviio xs qi
ny bfx lwjjp yt rj
ep swo cnaag pk ia
qb eia ozmms bw um
