Font size
WorksheetsCOMPUTER 1
Total questions: 75
Worksheet time: 40mins
An accountant needs to send an email with sensitive information to a client and wants to prevent someone from reading the email if it is intercepted in transit. The client's email system does not allow them to receive attachments due to their company security policies. Which of the following should the accountant use to send the email?
Host-based firewall
Cipher text
File level encryption
Plain text
Which of the following provides services to hosts on its network?
Server
Storage
Client
Lorraine, a user, connects a new mouse to a laptop, and the mouse works with no additional steps taken. Which of the following installation types does this BEST describe?
Plug-and-play
Manual
Hot-swappable
Web based
What do ADSL and VDSL have in common?
Both can support speeds of up to 1 Gbps.
Both are symmetric.
Both use fiber optic cables.
Both use phone wires to carry their signal
Why should backup media be stored offsite?
To reduce the possibility of theft.
It improves the efficiency of the restoration process.
o prevent the same disaster from affecting both the system as well as its associated backup media.
It is required by government regulations in the USA.
Why should backup media be stored offsite?
To reduce the possibility of theft.
It improves the efficiency of the restoration process.
To prevent the same disaster from affecting both the system as well as its associated backup media.
It is required by government regulations in the USA.
Why should backup media be stored offsite?
To reduce the possibility of theft.
It improves the efficiency of the restoration process.
Correct Answer:
To prevent the same disaster from affecting both the system as well as its associated backup media.
It is required by government regulations in the USA.
ow many bits are in a single byte?
four
eight
twelve
sixteen
What is the name of the narrow strip along the bottom of the Windows environment?
Toolbar
Taskbar
Shortcuts menu
Navigation bar
Which of the following scenarios is an example of why an application or utility would need a database for persistent data storage?
A system manager edits and saves a network device's configuration.
A student creates and saves a graphic image.
A business manager edits and saves a PowerPoint presentation.
A customer fills out an online form to order a Bluetooth speaker.
A database administrator wants to export a table as a backup before changes are made to the table structure. Which of the following commands should be executed?
UPDATE
SELECT
BACKUP
ALTER TABLE
Which of the following wireless technologies requires a distance of approximately 4 cm (1.5 inches) in order to establish a communications link between devices?
Infrared
WiFi
NFC
Bluetooth
As a systems engineer, which of the following is the BEST way to secure a new wireless access point or router that you have just installed?
Configure anti-malware software.
Make sure to use data encryption.
Enable the default firewall or a third-party firewall.
Change the device's default password.
Which of the following describes the firmware in gaming consoles, TVs, and smart cars?
Graphical User Interface
Device management
Embedded OS
Access control
As a systems engineer, which of the following is the BEST way to secure a new wireless access point or router that you have just installed?
Configure anti-malware software.
Make sure to use data encryption.
Enable the default firewall or a third-party firewall.
Change the device's default password.
Which of the following describes the firmware in gaming consoles, TVs, and smart cars?
Graphical User Interface
Device management
Embedded OS
Access control
You are vacationing at a friend's cabin on the lake and using the office computer to complete some work-related tasks using a web browser. The browser keeps slowing down after a few minutes of use. You check for extensions (add-ons) and notice that there are several listed. Knowing that extensions can slow down a browser, what should you do to speed up the web browser processing time?
Uninstall the web browser and re-install it.
Remove several of the extensions.
Disable several of the extensions.
Uninstall several of the extensions.
Cynthia is part of a team that uses a cloud-based collaboration solution. She is editing a shared spreadsheet when she notices that other people's work is not appearing on her copy. What is the problem in this scenario?
File encryption
File permissions
Upload maximums
File synchronization
A small business named Widgets, Inc. has hired you to evaluate their wireless network security practices. As you analyze their facility, you note the following using a wireless network locator device.
They use an 802.11n wireless network.
The wireless network is broadcasting an SSID of Linksys.
The wireless network uses WPA2 with AES security.
Directional access points are positioned around the periphery of the building.
Which of the following would you MOST likely recommend your client do to increase their wireless network security? (Select two.)
Configure the wireless network to use WPA with TKIP security.
Disable SSID broadcast.
Upgrade to an 802.11g wireless network.
Change the SSID to something other than the default.
Cynthia is part of a team that uses a cloud-based collaboration solution. She is editing a shared spreadsheet when she notices that other people's work is not appearing on her copy. What is the problem in this scenario?
File encryption
File permissions
Upload maximums
File synchronization
A small business named Widgets, Inc. has hired you to evaluate their wireless network security practices. As you analyze their facility, you note the following using a wireless network locator device.
They use an 802.11n wireless network.
The wireless network is broadcasting an SSID of Linksys.
The wireless network uses WPA2 with AES security.
Directional access points are positioned around the periphery of the building.
Which of the following would you MOST likely recommend your client do to increase their wireless network security? (Select two.)
Configure the wireless network to use WPA with TKIP security.
Correct Answer:
Disable SSID broadcast.
Upgrade to an 802.11g wireless network.
Change the SSID to something other than the default.
On a Linux system which directory contains applications and files used by users?
/home
/bin
/usr
/etc
Lisa is a software developer and needs to create a complied executable program for one of her clients. Which of the following is a compiled programming language she could use? (Select two.)
SQL
Java
PHP
C#
A user is installing a business software package on a desktop computer and wants to change the default location for file installation so they can select specific features to install.
Which of the following is available in the software installer to give the user this capability?
Advanced options
Add-ons and plug-ins
Software license agreement
Software subscription
As a database administrator, you want to speed up query retrieval time in your relational database. Which of the following SQL commands could you use to accelerate retrieving data with a query?
CREATE INDEX
ALTER TABLE
CREATE TABLE
CREATE VIEW
A technician walks into the office with a UPS. What sort of threat will this device prepare a system for?
Wiretapping
Denial-of-service
Power outage
Data redundancy
What is another term used to describe a workstation computer?
Server
Desktop
Tablet
Terminal
Which of the following BEST describes a motherboard?
A unit that supplies electricity to computer components
A printed circuit board that contains sockets and slots for upgradeable components
A chip that controls all other parts of a computer by getting information from them and then telling them what to do
A chip that makes sure all necessary parts are plugged in and working properly on bootup so that the operating system can start loading
A network administrator has successfully restored access to network data, hardware, and communications after a natural disaster and updated the disaster recovery plan.
Which of the following should the network administrator do before the next disaster occurs?
Estimate tangible and intangible impacts.
Prioritize which systems need to be restored first.
Conduct disaster recovery exercises.
Perform a business impact analysis.
Even if you perform regular backups, what must be done to ensure that you are protected against data loss?
Regularly test restoration procedures.
Restrict restoration privileges to system administrators.
Configure System Maintenance to automatically defragment system hard drives every night.
Write-protect all backup media.
Hannah is the manager of a successful Thai cuisine restaurant. It's November and Hannah wants to begin reviewing salary expenses for the year. She decides to generate a payroll report for all her employees.
Which of the following types of business software could easily provide Hannah with the report she needs?
Project management software
Business accounting software
Database software
Spreadsheet software
You have two different keyboard layouts configured on your Windows 10 computer. Which of the following keyboard shortcuts allows you to easily switch between them?
CTRL + ALT + DE
Start + K
CTRL + SHIFT + ESC
Start + Spacebar
Which of the following encoding schemes would MOST likely be used to represent an emoji?
ASCII
Unicode
Hexadecimal
Binary
Which of the following logic components is being used and how much is the interest if the amount is 5,000? (Select two.)
IF amount < 5,000 THEN interest = 7%, ELSE interest = 8%.
Looping
Branching
8%
8%
The first step in data analytics is to collect raw data and summarize the information. What is the next step in data analytics?
The analysts use statistical tools and formulas to look for trends, patterns, and data correlations.
The analysts create reports that help them make informed business decisions.
The business applies for a trademark or patent to protect the data information.
he business makes data-driven decisions based on the data information.
After setting up an Internet connection, you cannot connect to Internet websites, just company intranet sites. What is MOST likely the problem?
Browser cache
Private browsing
Invalid certificate
Proxy settings
What is the basic difference between a switch and a router in a Small Office Home Office (SOHO) network?
A switch translates data into a series of 1s and 0s; a router sends data to a device on the network.
A switch sends data to a device on the network; a router sends data to another network.
A switch forwards data to an ISP router; a router checks each bit of data to make sure it is safe.
A switch sends data to another network; a router sends data to a device on the network.
Python is a general purpose programming language that is popular for creating websites and mobile applications. Python is known as a readable and user-friendly language. What does the following code do?
color = input('What is your favorite color?\n')
print('Your favorite color is %s.' % color)
It sends the output to a printer.
It sets the font color to the color specified in the input.
It sets the system color variable.
It gets input and produces output
Which of the following runs exclusively from the cloud, relying on cloud technologies? (Select two.)
Microsoft Word
Dropbox
Google Drive
Adobe Photoshop
Linda has just purchased a Tesla electric car with online navigation software and the ability to automatically drive itself.
Which of the following BEST describes this type of technology?
Digital assistant
Hyper-automation
Edge computing
IoT (Internet of Things)
The basic (and smallest) unit of computer information is the bit (binary digit). Memory and file sizes are commonly measured in multiples of bits.
What is the first multiple of a bit called?
Byte
Decimal
Kbps
Kilobyte
A database administrator wants to export all the data in a database to a comma separated value file (.CSV) where it can be opened by spreadsheet software. Which of the following would be the EASIEST way to create the exported file?
SQL query
Transact SQL
Database dump
Database form
A user is shopping online and has added two items to the cart. When the user clicks the Checkout button, the shopping cart programming logic checks to see if the user is logged in already. If the user is logged in, the checkout process continues, otherwise, the user is prompted to sign in. Which of the following describes the logical component being used?
Looping
Encapsulation
Programming array
Branching
Which of the following connectors are used to terminate a Cat 5e and Cat 6a network cable
RJ-11
RJ-45
LC
BNC
Cindy wants to use a database to store and retrieve information for a research project. She has gathered photos, newspaper articles, interviews, and notes. The information does not appear to have a clear pattern. Which of the following types of data does Cindy want to store?
Non-structured
Relational
Structured
Semi-structured
Sharon works for a data analytics consulting firm. She is currently helping an international trading company promote a new line of organic beauty supplies to customers.
Which of the following is the first step Sharon needs to perform in the analysis process?
Capture the data.
Report the data.
Store the data.
Correlate the data.
Which of the following lists the basic computing and processing steps in order?
Input, retrieval, processing, and storage
Input, processing, output, and storage
Input/output, processing, and storage
Input, retrieval, output, and storage
A technician is installing a new SOHO wireless router.
Which of the following is the FIRST thing the technician should do to secure the router?
Change the router's default password
Press the WPS button
Adjust the radio power levels
Disable SSID broadcast
Jacob, a system manager, is performing tasks in a command line interface and wants to access the "/usr/local/share/blueskies.bmp" file. Which file system and file type is he trying to access?
Jacob is using a Windows operating system; the file type is an image file
Jacob is using a Windows operating system; the file type is an audio file.
Jacob is using a Linux operating system; the file type is an audio file.
acob is using a Linux operating system; the file type is an image file.
When a programmer is using branching or looping, a comparison is made to determine the next instruction to execute. A credit score of 690 or above is considered good, and below 690 is considered poor and a greater risk to lend someone money.
In the following pseudocode, what would be the correct comparison operator to use?
IF creditScore _____ 690 THEN interest = 8%, ELSE interest = 18%.
=
<=
<>
>=
Which network type uses a coaxial cable to receive its signal?
Fiber-optic
Cellular
Satellite
Cable
Which of the following are legitimate sources for obtaining software installation files for a device? (Select three.)
Google Play store
Freeware websites
Merchant app stores
Authorized resellers
Which of the following are basic architectural components of a relational database? (Select three.)
Primary keys
Tables
Fields
Records
Cliff needs to find a solution to a problem. He has several employees that work on team projects. He wants to find a centralized storage solution that can be used for shared storage, has enough space for even the largest files, is easy to deploy, attaches to his current network infrastructure, and is not too expansive. What device should he choose?
NAS
Cloud storage
DAS
File server
Which of the following accurately describes the characteristics of patents? (Select two.)
Patent holders use a symbol (such as a logo) to make it easy for people to know who created their invention.
Patent holders can prevent other people from making or selling their patented invention for a limited time.
Anything that is owned by a patent holder is called intellectual property.
Patent holders are required to provide the public with details about how their invention works.
Jessica has connected her new printer to her Windows 10 computer, but Windows is not recognizing it. What should she do?
Reset the USB cable
Power cycle the printer
Restart Windows
Install the latest driver
Which of the following do cybercriminals frequently use to alter or compromise data integrity?
Malware attack
TCP session hijacking
Replay attack
On-path attack
Classes contain properties, which are the attributes or characteristics that objects can hold as fields or private variables.
Which of the following is TRUE about properties?
Other programs can access and change properties directly
Methods are used to read or write properties.
The properties are read-only, so there is no need to access them publicly.
Properties in a class do not actually have the ability to store data in the fields or private variables.
Which digital communication medium consists of top-level posts with threads of response posts?
Chat room
Discussion board
Social network
Email client
Bob is configuring a new inventory tracking system that uses special labels to mark each inventory item. To track the inventory, Bob must be within 25 meters of the label and use a special reader to retrieve the information that's embedded in the tag.
Which of the following device interfaces is MOST likely being used?
NFC
Active RFID
NIC
Passive RFID
Which of the following contains procedures and processes for mitigating vulnerabilities in systems that support critical company workflow and resources?
Action plan
Business continuity plans
Contingency plans
Enterprise resource plan
Dave, a videographer, wants to purchase a network switch that will improve the performance of transferring video from his video editing workstation to a backup server. Which of the following transfer rates currently available to consumers is the FASTEST for network switches?
Tbps
Kbps
Gbps
Mbps
What is the term for software that anyone can use or modify for free?
Proprietary software
Read-write software
Linux software
Open-source software
Which of the following video standards provided resolutions up to 1024x768, color depths up to 32 bits, and higher refresh rates when it was released?
answer
Incorrect answer:
SVGA
HDMI
XGA
VGA
A small business has doubled in size over the past year. The IT consultant for the company is recommending the addition of a computing device that will provide central access to business resources. Which of the following describes the type of device needed?
Business-class workstations
Laptops for each employee
Tablets for each employee
Network Server
Edward, a database user, would like to gather some specific information from a database and then manipulate the data in a spreadsheet. Edward then wants to save that information in a file format that will be used by another application. Which of the following database features would work BEST to accomplish this?
Table
Report
Query
Form
Sally is trying to name a folder "Student Grades/1st Period". She keeps getting an error message that reads "The file name cannot contain these characters.". What is wrong with her folder name choice?
The number 1 is not allowed; it must be changed to an alpha character.
The space between "Student" and "Grades" is not allowed.
The name must be in lowercase characters.
/ is a reserved character.
Which of the following lets you store unstructured data?
Non-relational database
DBMS
Relational database
Flat file database
Which of the following provides services to hosts on its network?
Server
Storage
Client
Tom has a 7-gigabyte file he wants to put on a 16-gigabyte flash drive. To be able place this large file on the flash drive, what must Tom do to this flash drive first?
Format the flash drive to FAT32.
Format the flash drive to NTFS.
Re-partition the flash drive.
Format the flash drive to FAT16.
A software developer wants to provide a compiled executable program to a customer. Which of the following computer languages would provide this capability?
Perl
PowerShell
Ruby
C++
small business wants to persistently store customer feedback and product feature requests. The business also wants to be able to index and sort the information by priority. Which of the following would be the BEST option to track this information?
SSD
Database
Flat file
Memory
A restaurant chain maintains a Suppliers relational database that lists all suppliers for the restaurant. Recently, the restaurant ended a contract with CafeFresh in favor of another supplier of organic produce.
The database manager wants to use a SQL command to remove CafeFresh from the database. Which of the following commands would remove all CafeFresh records?
DELETE supplier_name = 'CafeFresh' FROM Suppliers
DELETE FROM TABLE Suppliers WHERE supplier_name = 'CafeFresh'
DELETE Suppliers WHERE supplier_name = 'CafeFresh'
Correct Answer:
DELETE * FROM Suppliers WHERE supplier_name = 'CafeFresh'
Which of the following describes an entity that issues digital certificates to certify the ownership of a public key?
Certificate Authority (CA)
Public Key Infrastructure (PKI)
Data Encryption Standard (DES)
Root certificate
Patricia, a database system manager for a large hotel chain, is setting up a relational database to track customer hotel registrations for each hotel. The table in the database currently includes fields (columns) for First Name, Last Name, Phone, Email, License Plate #, and Check-in Date. Patricia, a database system manager for a large hotel chain, is setting up a relational database to track customer hotel registrations for each hotel. The table in the database currently includes fields (columns) for First Name, Last Name, Phone, Email, License Plate #, and Check-in Date.
What can Patricia do to make sure that each record (row) in the database is unique?
Designate the Phone field as the primary key.
Combine the Email field and the Phone field to use as the primary key.
Designate the License Plate # field as the primary key.
Create an additional Check-in ID field.
