Font size
WorksheetsCambridge Technical Level 3 IT- Unit 1/LO2
Total questions: 64
Worksheet time: 47mins
Put a tick (✓) in the box next to the one correct answer. Which of the productivity software below would be the most suitable for storing large amounts of online shopping transaction data?
Database
Spreadsheet
Word Processor
Put a tick (✓) in the box next to the one correct answer. Which of the following allows a user to share images, text and video with a large number of recipients?
Social Media
Teleconference
Video Conference
VOIP
Put a tick (✓) in the box next to the one correct answer. Installable troubleshooting tools may not help a software developer to detect:
file corruption
file deletion
hardware issues
user error
Put a tick (✓) in the box next to the one correct answer. Which of the below features in the Application layer of the TCP/IP protocol stack?
FTP
ICMP
TCP
UDP
Put a tick (✓) in the box next to the one correct answer. A game magazine provides a link to download a new game which is initially provided as free, but has a built-in expiration date. This is an example of what kind of software?
Bespoke
Freeware
Off-the-shelf
Shareware
Put a tick (✓) in the box next to the one correct answer. Which of the following is an error reporting protocol?
ICMP
FTP
HTTP
SMTP
Put a tick (✓) in the box next to the one correct answer. Which productivity software is the most appropriate for creating a mail merge letter template?
Database
Spreadsheet
Word processor
Put a tick (✓) in the box next to the one correct answer. Which business software is most suitable for creating a safety poster?
CAD
CAM
MIS
DTP
Put a tick (✓) in the box next to the one correct answer. Which communication software enables several users to participate in a meeting over the phone?
Messaging
Personal assistants
Teleconference
Video conference
Put a tick (✓) in the box next to the one correct answer. Which software troubleshooting tool tests computer performance against an established norm?
Baseline
Error logs
Event logs
Installable tools
Put a tick (✓) in the box next to the one correct answer. Which of the following is an example of an engine management system in a car?
Embedded
Freeware
Off the shelf
Open source
Put a tick (✓) in the box next to the one correct answer. Which of the following is part of an Integrated Design Environment (IDE) that converts instructions into machine code?
Compiler
Debugger
Interpreter
Text editor
Put a tick (✓) in the box next to the one correct answer. Which of the following best describes a personal computer (PC) used at home?
Multiuser multitasking
Multiuser single application
Single user multitasking
Single user single application
Put a tick (✓) in the box next to the one correct answer. Which communication method would be most appropriate for discussing a new plane design?
Instant messaging
Teleconference
Video conference
Put a tick (✓) in the box next to the one correct answer. Which of the following is not a feature of an Internet Protocol (IP)?
Forwarding packets to individual computers.
Putting packets back together in order.
Sending packets to the Domain.
Sending packets to the Gateway.
Put a tick (✓) in the box next to the one correct answer. Which of the following is a reason why a publishing house may decide not to share the source code for the software it publishes?
To allow users to use the software on multiple devices.
To allow users to use the software on multiple platforms.
To improve the quality of future software upgrades.
To make the software more difficult to copy.
RK Manufacturing uses CAD/CAM software as part of its manufacturing process. Which of the following is a reason why RK Manufacturing uses CAD/CAM software?
CAM software includes templates that can help the design process.
The completed products are more accurate than those produced by human control.
The costs of manufacturing are shared amongst many different organisations.
The range of physical tools available for the machines is wider.
ATAT Printing has travelling engineers who carry out support visits at customer sites. Which of the following communication methods is best suited for use by an engineer wanting to communicate privately with the main office, in real time?
Instant Messaging
Social media
Written letter
Which of the following is a purpose of Simple Network Management Protocol (SNMP)?
To collect information from network devices
To manage data packet transfer across a network
To manage the transfer of data across the World Wide Web
To provide checksums for data integrity
Which of the following is a feature of an off-the-shelf operating system?
Advanced users may see the source code.
It is made to the user requirements.
It automatically provides regular security updates.
Non-essential functionality is removed.
Put a tick in the right hand column of the table to show the correct answer. Which of these items is an advantage of a teleconference?
Can send documents electronically
Requires physical presence
Limited to local participants
High travel costs
Put a tick in the right hand column of the table to show the correct answer. Which of these items is not a function of an operating system?
Displaying data on a screen
Managing hardware resources
Providing a user interface
Executing and managing applications
Put a tick in the right hand column of the table to show the correct answer. Which of these is not a characteristic of a token ring network?
Token moves between devices in a random order
Each device has equal access to the token
Data is transmitted in one direction
Token passing is used to prevent collisions
Put a tick in the right hand column of the table to show the correct answer. Which protocol is used to transfer email from server to server?
SMTP
HTTP
FTP
IMAP
BV Digital Comms. has developed its own VoIP software package. A cut-down version of the software is available as Freeware. Why would BV Digital Comms. choose to distribute the cut-down version of its VoIP software as Freeware?
To avoid copyright issues.
To discourage sales of the full programme.
To encourage software engineers to further develop their programme.
To encourage users to purchase the full version.
A sales team has been asked to analyse the sales figures for one section of a business. The team can use database or spreadsheet software for this purpose. Which of the following describes why the team may choose to use database software rather than spreadsheet software to analyse the data?
Spreadsheet software cannot store atomised data in related tables.
Spreadsheet software cannot create graphs from data.
Spreadsheet software cannot sort data alphabetically.
Spreadsheet software cannot sort data into number order.
Which of the following best describes the purpose of utility software?
To allow multiple users to use a computer.
To allow the user to maintain a computer.
To allow the user to manage contacts.
To allow the user to manage electricity and plumbing bills.
Businesses can use Short Message Service (SMS) for a range of different purposes. Which of the following would not be an appropriate use of SMS by a business?
To confirm a booking.
To distribute a new social media policy amongst staff.
To inform clients of a forthcoming invite-only sales event.
Put a tick (✓) in the box next to the one correct answer. Which of the following is a protocol used by a web server to deliver a webpage?
Hypertext Mark-up Language (HTML)
Hypertext Transfer Protocol (HTTP)
Simple Mail Transfer Protocol (SMTP)
Internet Control Message Protocol (ICMP)
Put a tick (✓) in the box next to the one correct answer. Which of the following may be a disadvantage to a business of using Open Source software?
Competitors may be using the same software.
It may include lots of features.
There may be an increased security risk as the source code can be edited by others.
The business is not tied into one vendor's system.
Put a tick (✓) in the box next to the one correct answer. Which of the following is an advantage of a multiprocessor operating system?
Every task is performed by the same processor.
Multiprocessor systems are easier to design.
Failure in one processor will result in complete system failure.
The throughput of data is usually greater than a single processor system.
Put a tick (✓) in the box next to the one correct answer. Which of the following is not a feature of a Personal Assistant system?
Plays music.
Personalised to different voices.
Provides news and sports updates.
Put a tick (✓) in the box next to the one correct answer. Which of the following is the most likely cause of a slow running application on a computer?
Insufficient Active Directory capacity.
Insufficient ports on the motherboard.
Insufficient ROM capacity.
Insufficient RAM capacity.
Put a tick (✓) in the box next to the one correct answer. Which of the following services is not provided by the User Data Protocol (UDP)?
Checksum capability to check on package delivery.
Packet transmission.
Packet retransmission.
Providing port numbers.
This was related to the most suitable productivity software for storing large amounts of online shopping transaction data.
Database
Spreadsheet
Choose a suitable way of sharing images, text, and video content with a larger number of recipients.
Social Media
Identify a type of error that might not be detected by installable troubleshooting tools.
User error
File corruption
Hardware issues
Select which protocol was in the Application layer of the TCP/IP stack.
FTP
TCP
Identify the type of software that is available for use at no cost.
Freeware
Shareware
Candidates were asked to select which software was initially provided free but had an expiry date.
Bespoke
Freeware
Shareware
Shareware
Candidates were asked to identify an error reporting protocol.
ICMP
HTTP
FTP
Candidates needed to identify productivity software most appropriate for creating a mail merge letter template.
Word processor
Candidates were asked to select which business software was most suitable for creating a safety poster.
CAD (Computer Aided Design)
DTP (Desk Top Publishing)
This was related to software for a meeting over the phone. Identify the correct answer.
Teleconference
Video Conference
The question described a software troubleshooting tool. Identify it from the description.
(a)
Identify the type of system described.
(a)
Identify the software tool from the description.
(a)
Identify the type of operating system described.
Identify the type of meeting described.
Identify the network process described.
Identify the purpose of the software feature described.
The completed products are more accurate than those produced by human control.
The completed products are less accurate than those produced by human control.
The completed products are more accurate than those produced by human control.
The completed products are equally accurate as those produced by human control.
Which of the following is an example of Instant Messaging?
Instant Messaging
Video Conferencing
To collect information from network devices, which of the following is used?
To collect information from network devices
To send information to network devices
To delete information from network devices
What is a benefit of a system that automatically provides regular security updates?
It requires manual updates.
It provides updates only on request.
It automatically provides regular security updates.
Freeware could be distributed to encourage users to purchase the full version.
To provide free access to all features
To limit access to certain features
To encourage users to purchase the full version
To discourage users from purchasing the full version
Spreadsheet software cannot store atomised data in related tables.
Spreadsheet software cannot store atomised data in related tables
Spreadsheet software can store atomised data in related tables
Spreadsheet software can store data in unrelated tables
Utility software is used to allow the user to maintain a computer.
To allow the user to delete the computer
To allow the user to maintain the computer
To allow the user to upgrade the computer
Which of the following is NOT appropriate for distributing a new social media policy amongst staff?
SMS
Intranet
Printed document
Which protocol is used by a web server to deliver a webpage?
FTP
HTTP
SMTP
SNMP
What is a disadvantage of using Open Source software?
It is expensive
It is not customizable
There may be an increased security risk as the source code can be edited by others
It is not widely used
What is an advantage of a multiprocessor operating system?
It is cheaper than a single processor system
It uses less power
It is easier to program
The throughput of data is usually greater than a single processor system
What is the most likely cause of a slow running application on a computer?
Which of the following is not provided by the UDP protocol?
