Font size
WorksheetsRevision
Total questions: 71
Worksheet time: 41mins
Using a spreadsheet program over a manual version of a table is likely to provide which of the following advantages (more than 1
Less calculation errors due to automatic calculations
Fewer mistakes made
Data can be shared electronically
Use more paper due to printing
Which of the following software will store/query/sort data?
Spreadsheet
Presentation
Database Management System
Word Processing
Which of the following software will create documents/letters/invoices?
Spreadsheet
Word Processing
Database Management System
Presentation
Which of the following software will create visual displays e.g. slides for clients/staff to view while a demonstration is happening?
Spreadsheet
Word Processing
Graphics Manipulation
Presentation
Which of the following software will allow staff to communicate?
Web browser
Word Processor
Database
Which of the following software will produce adverts/leaflets?
Graphics Manipulation/publishing
Web browser
Word Processing
Which of the following software will allow a staff member to view a web page?
Web browser
Graphics manipulation
Presentation
Database
What does closed source software entail?
Giving no access to the source code
Giving full access to the source code
Giving partial access to the source code
Open source software allows... (multiple answers)
the modification and improvement of source code
no modification and improvement of source code
bug fixes
no bug fixes
One difference between open and closed source is ... (multiple answers)
open requires a cost to purchase a license
closed requires a cost to purchase a license
open may have ongoing fees like a subscription
closed may have ongoing fees like a subscription
BIOS stands for what?
Basic Input Output Server
Basic Input Output System
Basic In Out System
Basic In Out Server
The BIOS can... (multiple answers)
alter hardware settings
alter software programs
alter boot drive
alter system date and time
BIOS settings are store in...
ROM
RAM
SSD
HDD
Which of the following is a benefit of using virtual storage (NOT VIRTUAL MEMORY)? (multiple answers)
data is stored away from the computer
all data can be backed up at the same time
can access data from elsewhere in the world
allows less local storage
Which of the following is a benefit of using virtual storage (NOT VIRTUAL MEMORY)? (multiple answers)
data can be recovered from an off site location
do not need to worry about local storage size when backing up on virtual storage
storage can be expanded to increase the storage capacity
needs an internet connection
Which of the following is a disadvantage of LAN?
can't share hardware
can't share files
can't share an internet connection
it may be costly to set up
Which of the following can be shared on a LAN? (multiple answers)
hardware
files
internet connection
user activity
A LAN can centrally ... (multiple answers)
perform maintenance
provide security
provide usernames and passwords
store data
A LAN can monitor ...
internal hardware
cctv footage
external hardware
user activity
A LAN allows access to data on
any machine on the LAN and WAN
any machine on the LAN
any machine on the WAN
A LAN does not allow access to data
A LAN allows access to data on ...
any machine on the LAN and WAN
any machine on the LAN
any machine on the WAN
A LAN does not allow access to data
A set of rules to ensure data is transferred between devices properly is known as what?
Network Protocol
Network Policy
Standard
User Policy
A network policy may specify what?
time and date
IP address
MAC address
format of data
Which of the following are protocols? (multiple answers)
HTTPS
HPPS
FPO
IP
UDP
Which of the following are protocols? (multiple answers)
FTP
POPO
IMAP
WPA
ZOG
Which of the following are protocols? (multiple answers)
VoIP
SMTP
BIOS
RDP
DHCP
Which of the following are descriptions of protocol layers? (multiple answers)
Each layer applies protocols in order i.e. one after the other
Each lay applies protocols at the same time
Each layer is independent allowing modification without effecting other layers
Each layer is not independent but allows modification without effecting other layers
Which of the following are descriptions of protocol layers? (multiple answers)
Each layer can communicate with any layer
Each layer can only communicate with adjacent layers
Layers allow for standards for individual tasks
Layers do not allow for standards for individual tasks
Which of the following are descriptions of protocol layers? (multiple answers)
Each layer breaks a task down into manageable units
Each layer performs tasks and does not need them broken down
It is easy to find a issue with a layer
it is difficult to find an issue with a layer
Which of the following best describes a Multi-User Operating System?
runs multiple programs at the same time
allows multiple users at the same time
allows multiple computers to work together on a single task
has a dedicated limited function
Which of the following best describes a Multi-Tasking Operating System?
runs multiple programs at the same time
allows multiple users at the same time
allows multiple computers to work together on a single task
has a dedicated limited function
Which of the following best describes a Distributed Operating System?
runs multiple programs at the same time
allows multiple users at the same time
allows multiple computers to work together on a single task
has a dedicated limited function
Which of the following best describes a Embedded Operating System?
runs multiple programs at the same time
allows multiple users at the same time
allows multiple computers to work together on a single task
has a dedicated limited function
Which of the following are the first and second steps of dealing with an interrupt?
● Interrupt checked for at start/end of each fetch-execute cycle
● If the interrupt is of a lower/equal priority to the current process then the current process continues
● (If interrupt raised) contents of registers copied to stack
● Flags are set to determine if interrupts are enabled / disabled
● Program counter changed to point to Interrupt Service Routine (ISR) // ISR runs
● After interrupt complete, previous register values restored back from stack
● Flag is reset
● If higher priority interrupt received during servicing of interrupt, this is added to stack and new interrupt dealt with
Which of the following are the third and fourth steps of dealing with an interrupt?
● Interrupt checked for at start/end of each fetch-execute cycle
● If the interrupt is of a lower/equal priority to the current process then the current process continues
● (If interrupt raised) contents of registers copied to stack
● Flags are set to determine if interrupts are enabled / disabled
● Program counter changed to point to Interrupt Service Routine (ISR) // ISR runs
● After interrupt complete, previous register values restored back from stack
● Flag is reset
● If higher priority interrupt received during servicing of interrupt, this is added to stack and new interrupt dealt with
Which of the following are the fifth and sixth steps of dealing with an interrupt?
● Interrupt checked for at start/end of each fetch-execute cycle
● If the interrupt is of a lower/equal priority to the current process then the current process continues
● (If interrupt raised) contents of registers copied to stack
● Flags are set to determine if interrupts are enabled / disabled
● Program counter changed to point to Interrupt Service Routine (ISR) // ISR runs
● After interrupt complete, previous register values restored back from stack
● Flag is reset
● If higher priority interrupt received during servicing of interrupt, this is added to stack and new interrupt dealt with
Which of the following are the seventh and eighth steps of dealing with an interrupt?
● Interrupt checked for at start/end of each fetch-execute cycle
● If the interrupt is of a lower/equal priority to the current process then the current process continues
● (If interrupt raised) contents of registers copied to stack
● Flags are set to determine if interrupts are enabled / disabled
● Program counter changed to point to Interrupt Service Routine (ISR) // ISR runs
● After interrupt complete, previous register values restored back from stack
● Flag is reset
● If higher priority interrupt received during servicing of interrupt, this is added to stack and new interrupt dealt with
What is the aim of memory management?
To ensure secondary storage is used efficiently and not wasted
To ensure primary storage is used efficiently and not wasted
To ensure ROM is used efficiently and not wasted
To ensure RAM is used efficiently and not wasted
What does memory management do?
Defragments a drive
Removes cached data and clears up temporary internet files
Removes data not needed anymore, frees up space and allocates memory to applications
frees up space and allocates storage space for applications upon install
Which of the following describes paging?
Paging uses variable sized divisions to split up memory. Paging is divided logically.
Paging uses fixed sized divisions to split up memory. Paging is divided logically.
Paging uses fixed sized divisions to split up memory. Paging is divided physically.
Paging uses variable sized divisions to split up memory. Paging is divided physically.
Which of the following describes segmentation?
Segmentation uses variable sized divisions to split up memory. Segmentation is divided logically.
Segmentation uses fixed sized divisions to split up memory. Segmentation is divided logically.
Segmentation uses fixed sized divisions to split up memory. Segmentation is divided physically.
Segmentation uses variable sized divisions to split up memory. Segmentation is divided physically.
When would virtual memory be used?
Virtual memory may be used when ROM is almost full to enable applications to continue running by using secondary storage to act as memory until there is enough free space in ROM.
Virtual memory may be used when RAM is almost full to enable applications to continue running by using primary storage to act as memory until there is enough free space in RAM.
Virtual memory may be used when RAM is almost full to enable applications to continue running by using secondary storage to act as memory until there is enough free space in RAM.
Virtual memory may be used when RAM is almost full to enable applications to continue running by using secondary storage to act as memory until there is enough free space in ROM.
If RAM is full could you load an application?
Yes
No
If data is in virtual memory, what needs to happen before it can be used?
It needs to be saved
It needs to be moved back to RAM
It needs to be deleted from secondary storage
It needs to be transferred to ROM
Which statements are true? (multiple answers)
Paging causes internal fragmentation whereas segmentation causes external fragmentation
Paging causes external fragmentation whereas segmentation causes internal fragmentation
A page table is used to map page location which is slower than a segmentation table
A segmentation table is used to map segment locations which is slower than a page table
Which statements are true?
RAM is more expensive that secondary storage per GB
RAM is less expensive that secondary storage per GB
Over use of virtual storage causes slow down and even disk thrashing if segments have to be swapped back and forth too often
Over use of virtual memory causes slow down and even disk thrashing if pages have to be swapped back and forth too often
Which of the following describes a stack?
Stack is a FIFO/FILO and uses one pointer. A stack is pushed and popped.
tack is a LIFO/FILO and uses one pointer. A stack is enstacked and destacked.
Stack is a FIFO/FILO and uses one pointer. A stack is enstacked and destacked.
Stack is FILO/LIFO and uses one pointer. A stack is pushed and popped.
Which of the following describes a queue?
A queue is FIFO/LIFO and uses two pointers. A queue is pushed and popped.
A queue is FIFO/LILO and uses one pointer. A queue is enqueued and dequeued.
A queue is FIFO/LILO and uses two pointers. A queue is enqueued and dequeued.
A queue is FIFO/LILO and uses two pointers. A queue is pushed and popped.
Which of the following describes a tuple?
A tuple cannot be changed at runtime because it is immutable
A tuple cannot be changed at runtime because it is mutable
A tuple can be changed at runtime because it is immutable
A tuple can be changed at runtime because it is mutable
Which of the following describes an array?
An array is variable in size. Arrays hold data of a single data type.
An array is variable in size. Arrays hold data of a multiple data type.
An array is fixed in size. Arrays hold data of a multiple data type.
An array is fixed in size. Arrays hold data of a single data type.
Which of the following describes a list?
An list is variable in size. Arrays hold data of a single data type.
An list is variable in size. Arrays hold data of a multiple data type.
An list is fixed in size. Arrays hold data of a single data type.
An list is fixed in size. Arrays hold data of a multiple data type.
Calculations are easily performed using which method?
Sign and magnitude
2's complement
Which of the following only has 1 representation for 0 (zero)?
sign and magnitude
2's complement
Which of the following allows for larger numbers to be stored?
Sign and magnitude
2's complement
Which of the following requires additional hardware for calculations?
Sign and magnitude
2's complement
Accuracy is achieved when ...
the number of bits used for the mantissa is increased.
the number of bits used for the exponent is increased.
Range is achieved when ...
the number of bits used for the mantissa is increased.
the number of bits used for the exponent is increased.
Which of the following describes assembly language? (multiple answers)
uses mnemonics e.g. LDA
Uses English words
Uses an assembler to convert to machine code
uses a translator to convert to machine code
Which of the following describes a high level language? (multiple answers)
uses mnemonics e.g. LDA
Uses English words
Uses an assembler to convert to machine code
uses a translator to convert to machine code
Which of the following describes a high level language? (multiple answers)
one to one conversion to machine code
produces multiple lines of machine code per line of code
specific to the processor type
can be used on multiple processor types
Which of the following describes a assembly language? (multiple answers)
one to one conversion to machine code
produces multiple lines of machine code per line of code
specific to the processor type
can be used on multiple processor types
Multicore processors can...
execute multiple instructions at the same time
execute multiple FDE cycles at the same time
run programs in parallel
run one instruction at a time
Which of the following are issues of multicore systems?
cannot perform an FDE cycle
some instructions cannot be run in parallel
instructs may need other instructions to finish
programs need to be written specifically to use multicore features
Encryption does what? (multiple answers)
scrambles data
converts data into data that cannot be read
makes data more readable
converts data into data that be read
Which of the following is symmetric encryption?
encryption which uses the same key for both encryption and decryption
encryption which uses two keys, one for encryption, one for decryption
Which of the following is asymmetric encryption?
encryption which uses the same key for both encryption and decryption
encryption which uses two keys, one for encryption, one for decryption
Which of the following describes encryption?
Two-way, so data can be restored to original form, but key is required.
One-way (non-reversible) mathematical process that produces a value from the input value.
Which of the following describes hashing?
Two-way, so data can be restored to original form, but key is required.
One-way (non-reversible) mathematical process that produces a value from the input value.
Describe hashing?
A mathematical value created to enable the verification of data. This value is used to check against values stored in a table.
Data that is converted using an algorithm and then converted back.
Which of the following makes hashing useful?
useful for data storage of items that need to be verified, hash of input compared against hash stored to confirm correctness.
useful for data that needs to be returned to the user as impossible to return to.
Once hashed, can data be returned to?
Yes
No
