Font size
WorksheetsIT Fundamentals CompTIA practice
Total questions: 75
Worksheet time: 43mins
Christian has logged onto his bank's website. He wants to pay some bills electronically and transfer funds to his savings account. He checks to see if the padlock icon is visible in the address bar. The padlock is there, and it is green. What does that indicate?
The green color has no meaning.
You should not trust a green padlock.
The certificate is pending, but you should trust it anyway.
A highly trusted certificate.
When Sally walks into her house, she uses her voice to turn on lights and to tell her TV to turn on the news. What are these examples of?
Home automation
Robotics
IoT
Smart devices
Frank, a technician, has finished installing a wireless router. Jessica is connected to the WiFi. However, she can only see the company intranet pages. What should Frank do to troubleshoot the problem?
Clear the browser cache
Disable the pop-up blocker.
Configure the browser proxy settings.
Apply a firmware update.
Which of the following are optical storage devices? (Select three.)
BD
SSD
DVD
USB flash drive
CD
Identifying the problem is the first step in CompTIA's troubleshooting model. Which of the following are tasks associated with this step? (Select three.)
Duplicate the problem
Question users
Identify symptoms
Escalate as necessary
Consider multiple approaches
A federal government agency is working on updating their employee handbook to specifically cover employee internet usage.
Which of the following are topics that should be covered under this section in the handbook? (Select three.)
Workplace surveillance
Data protection
Personnel management policies
Social media and email
Impersonation
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
Database software
Spreadsheet software
Business accounting software
Which type of device is designed specifically for video gaming and is designed to be connected to a HD TV for display?
Tablet
Desktop
Server
Console
You want to use an application and are not connected to a network. Which of the following application delivery methods should you choose?
Network hosting
Local installation
n-tier application
Cloud hosting
A systems engineer has discovered an attack on the network, which is threatening to shut down a web service by overloading it with bogus requests. The attacker is using bot malware to enlist compromised systems (called zombies) to remotely manipulate them.
Which of the following is the threat being utilized by the attacker?
Data destruction
Service outage
Distributed denial-of-service attack
Replay attack
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.
Patents are automatically given to patent holders without the need to apply for the patent.
Patent holders are required to provide the public with details about how their invention works.
Anything that is owned by a patent holder is called intellectual property.
Which of the following is the binary number equivalent of the hexadecimal number F5C8?
1010010011010001
1101000110100100
1111010111001000
1101001110111001
Which of the following BEST describes computer data processing?
Data is saved to a hard disk.
Data in memory is converted to information.
A graphic image is displayed on a screen.
A document is scanned by a user.
Which of the following is an advantage to using a hardware token over password authentication?
Hardware tokens are less expensive to implement than passwords.
Hardware tokens are easier to implement than passwords.
Hardware tokens need to be physically stolen or copied to be used.
Hardware tokens can be used in multifactor authentication.
Jason works out of his home using a Small Office Home Office (SOHO) network and is planning on moving to a new city in a few months. What is the MOST likely reason Jason would choose Digital Subscriber Line (DSL) over a fiber network in his next home?
DSL provides higher upload and download speeds.
DSL cables provide better performance over longer distances.
DSL is more likely to be available at his new home.
DSL does not interfere with voice calls.
A programmer is creating an application that needs to store a value indicating if the user is logged in or not. Which of the following would be the BEST data type to accomplish this?
Boolean
String
Integer
Float
What is the maximum supported transfer rate for the IEEE 1394b standard?
400 Mbps
480 Mbps
5 GBps
800 Mbps
Mark is a database administrator who's responsible for managing the records in a boat inventory relational database for a local chain of boat shops. Recently, the owners have decided to expand to several more stores. Mark has hired David, an assistant administrator, to help out.
In order to get started, he wants to grant permission to the assistant to retrieve and view information in the database. Which of the following SQL commands can Mark use to grant this permission to David?
GRANT ALL ON boatinventory TO david
GRANT UPDATE ON boatinventory TO david
GRANT SELECT TO david ON boatinventory
GRANT SELECT ON boatinventory TO david
A network administrator for a legal firm has installed a Wi-Fi access point in company headquarters and is now ready to configure the access point from a company laptop computer. What is the first step that the administrator needs to take to begin configuring the access point?
Establish a Bluetooth connection.
Select the correct 802.11 standard.
Enter the IP address of the access point web configuration page.
Enter the SSID of the access point.
When resetting a password for a website, which of the following are the MOST likely security identification requirements that you need to meet before the password can be changed? (Select two.)
Answer a security question.
Enter a security code.
Meet the password complexity requirements.
Enter the new password twice.
Add the password to a password manager.
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 * FROM Suppliers WHERE supplier_name = 'CafeFresh'
DELETE Suppliers WHERE supplier_name = 'CafeFresh'
DELETE FROM TABLE Suppliers WHERE supplier_name = 'CafeFresh'
DELETE supplier_name = 'CafeFresh' FROM Suppliers
What group of database commands is used to define and modify metadata?
Data correlation
Data manipulation
Data definition
Data control
A system administrator has been troubleshooting a problem with a database server not providing the information necessary to generate reports from a customer application. The administrator has tried testing several theories, but nothing seems to resolve the issue.
Which of the following describes the MOST effective action the administrator should take next to try to resolve the problem?
Escalate the problem to the database engineer.
Keep a record of the testing attempts to include in the action plan.
Consult with other system administrators in the company.
Research the company knowledge base and the internet.
Marcus was assigned to troubleshoot a problem with a customer not being able to access a cloud application. Which of the following is the LAST step in the troubleshooting methodology that should be completed?
Verify full system functionality and, if applicable, implement preventive measures
Implement the solution or escalate as necessary
Document findings/lessons learned, actions, and outcomes
Establish a plan of action to solve the problem and identify potential effects
Which of the following is not a form of biometrics?
Retina scan
Face recognition
Fingerprint
Smart card
Your company has a disaster recovery plan that says the order to restore data is customer data, financial system, then email. This is an example of what?
Prioritization
Fault tolerance
Business Plan
Cloud backups
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 FAT16.
Format the flash drive to NTFS.
Format the flash drive to FAT32.
Re-partition the flash drive.
In which of the following should you expect some privacy?
Emailing an important document to a friend using an employer email system
Metadata stored by a web browser
Sharing a photo through a mobile phone app
Personally identifiable information entered into a human resource database
Which of the following flow chart concepts is depicted below?
Vectors
Arrays
Sequence
Methods
Which of the following is a database concept that allows for storage and analysis for a few dozen to billions of data points?
Scalability
Processing speed
Storage
Concurrent use
Which of the following is a type of variable that can hold
many values at the same time?
Variable
Constant
Value
Array
A system engineer is helping to design new security measures for company headquarters. Which of the following authentication factors could be included as a solution for Type 2 (something you have) authentication? (Select two.)
A password
A fob
A fingerprint
A pattern drawn on a screen
A physical location
You're troubleshooting a computer running Windows 10. The operating system has halted and a blue screen has been displayed on the monitor with an error message.
Check the voltage levels on the DC side of the power supply
Uninstall the last application or system update that was installed.
Update the BIOS.
Search for the error in Microsoft's knowledgebase.
Remove all memory modules and replace them one at a time until the error reappears.
Which of the following networking interfaces connects a computer to a wired local area network (LAN)?
RJ-11
RFID
RJ-45
NFC
Christopher is surfing the web and sees an amazing offer for a product he's interested in. He clicks the link and begins the process of purchasing the item. While he is proceeding with the purchase, he notices that the address bar is a maroon color.
Should he proceed with putting in private information and purchasing the item from this site?
No, he needs to create a user account first.
No, the maroon color indicates an invalid certificate.
Yes, maroon is a trusted certificate.
Yes, maroon means a pending certificate.
A method is declared within a class. Which of the following would be an example of a method for a Car class?
Start engine
style
color
wheels
You are replacing your graphics card and want to uninstall the current driver. Which of the following would be the BEST method to uninstall the driver?
Remove the device from Control Panel
Delete the software folder.
Remove the device from Device Manager.
Uninstall the software package.
What do the light and dark spots on an optical disc represent?
Write speed
1s and 0s
Type of disc
Read speed
After setting up an Internet connection, you cannot connect to Internet websites, just company intranet sites. What is MOST likely the problem?
Proxy settings
Invalid certificate
Private browsing
Browser cache
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
Branching
Encapsulation
Programming array
Dropbox and Microsoft's OneDrive are both popular applications for storing files. What is a fundamental difference between Dropbox and OneDrive?
Dropbox is installed by default on Windows systems (starting with Windows 10).
OneDrive is a cloud-based storage solution.
OneDrive is installed by default on Windows systems (after Windows 7).
Dropbox is available as an Android application and an iPhone application.
Which of the following is the basic difference between a password and a passphrase?
Passphrases are shorter than passwords and easier to remember.
Passphrases are the same length as passwords but can include spaces.
Passphrases are longer than passwords but more difficult to remember.
Passphrases are longer than passwords and can include spaces.
Which of the following BEST describes a flowchart?
It starts at the first line and then executes one line at a time until the end.
It is a step-by-step procedure that illustrates how a problem is to be solved.
It is a visual representation of the logic in a program.
It does the same thing over and over in exactly the same way.
What is displayed based on the output from the following pseudocode if the count is 42?
declare number total = 32
declare number count
while count > total
count = count - 1
loop
31
32
33
0
A database administrator wants to create a copy of an entire database. Which of the following SQL (Structured Query Language) commands can the administrator use to create the copy?
BACKUP database_name
CREATE BACKUP database_name
BACKUP DATABASE database_name
CREATE BACKUP DATABASE database_name
You are troubleshooting a client's issue. Whenever she tries to double-click on a folder, the folder highlights but does not open. Your client gets frustrated because she has to keep clicking until the folder finally opens.
Which of the following should you do to correct this issue?
Select a faster double-click speed in Mouse Properties.
Select a faster double-click speed in Mouse Properties.
Tell the user to click the mouse buttons faster.
Select a slower double-click speed in Mouse Properties.
Which of the following BEST describes the Small Office Home Office (SOHO) hardware component that translates an internet service provider's (ISP) signals into 1s and 0s that can be used by a computer?
Modem
Firewall
Router
Switch
Which of the following access controls gives only backup administrators access to all servers on the network?
Discretionary
Authorization
Role-based
Mandatory
Small files that a website saves on your computer to remember your preferences are called ______________.
Reminders
Fingerprints
Malware
Cookies
A developer is working on an application that needs to be able to read, write, update, and delete database records. Which of the following database access methods should the developer use?
Query builder
Programmatic access
User interface access
Direct access
A new server has been installed and requires a static IP address. Which of the following would be a valid IP address?
172.84.0.211
255.255.255.0
10.88.257.0
127.0.0.1
What must a laptop have in order to work outside of the house and still remain connected to the internet?
Bluetooth module
Infrared sensor
WLAN card
Bluetooth module
Paul has been asked to install a new printer. The most important requirement is that the printer needs to be fast. Which of the following printer types is the fastest?
Inkjet printer
3D printer
Dot matrix printer
Laser printer
Which of the following BEST describes the file "/Users/Hannah/Rivers.js"?
"Rivers.js" is an executable file with a "/Users/Hannah/Rivers.js" filename.
It's an image file with a "/Users/Hannah/Rivers.js" filename.
"Rivers.js" is an image file in the "/Users/Hannah/" subfolder.
"Rivers.js" is an executable file in the "/Users/Hannah/" subfolder.
Jonathan has a computer with an older PC bus interface and is getting a fiber optic connection for his home office.
Which of the following BEST describes the processing speed environment?
Both the older PC bus and the fiber optic equipment run at a MHz processing speed.
The older PC bus runs at a MHz processing speed, while the fiber optic network equipment runs at a GHz processing speed.
Both the older PC bus and the fiber optic equipment run at a KHz processing speed.
The older PC bus runs at a KHz processing speed, while the fiber optic network equipment runs at a MHz processing speed.
A user has entered a search string into an application and clicked on the search icon. Which of the following is the NEXT step in the computing process?
Input
Output
Storage
Processing
If you select a file on your desktop and delete it, what happens to the file?
It is moved to the Recycle bin and deleted later.
It is moved to the Recycle bin.
It is immediately deleted and removed from the storage media.
Its filename is removed and it is deleted later.
As a database administrator, you want to make sure that the Phone field in a record is not left blank by an employee filling in personal information.
Which of the following could you apply to the field to keep it populated?
Schema
Constraint
Form
Primary key
Which of the following statements BEST describes a firewall?
A firewall is a peripheral device attached to your computer that restricts the flow of data between the computer and a network.
A firewall filters data packets between a computer and the internet.
A firewall restricts the flow of data between hosts and networks by checking data packets to make sure they are safe.
A firewall blocks all traffic between computers and networks.
Why should backup media be stored offsite?
It is required by government regulations in the USA.
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.
To reduce the possibility of theft.
Which of the following are exclusively associated with copyright protection? (Select three.)
Right to lend a work
Right to reproduce a work
Right to make derivatives of a work
Right for anyone to display a work
Right to apply for a patent
Which connector on the back of a computer is used to attach a mouse to a modern PC system?
USB B
Mini-DIN
RJ-45
USB A
High-density (three row), female DB-15
You have configured your Windows systems to automatically backup user data every night at midnight. You also take a system image backup once a month.
In addition, which of the following would MOST likely ensure that you are protected against data loss? (Select TWO).
Restrict restoration privileges to system administrators.
Regularly test restoration procedures.
Write-protect all backup media.
Store a copy of all backups off-site.
Configure System Maintenance to automatically defragment system hard drives every night.
The vast amount of data collected from Internet searches, social media posts, customer transactions, military surveillance, medical tests, weather sensors, and other data sources are collectively referred to as ________________.
Big Data
Metadata
Business Data
Omni Data
A relational database has become corrupted, and now the database administrator needs to import the most recent database backup to fix the issue.
Which SQL command can the administrator use to perform this task?
UPDATE
RESTORE
DROP TABLE
INSERT INTO
You are working on a program that needs to keep track of many values at the same time. Which of the following would you use?
A variable
A constant
A float
An array
What is the name of the narrow strip along the bottom of the Windows environment?
Shortcuts menu
Navigation bar
Taskbar
Toolbar
You are using a program that can run multiple operating systems and manage hardware and storage. What are you most likely using?
Network Attached Storage
Hypervisor Type 1
An Embedded OS
Solid State Drive
Which of the following can be used to ask a database questions and receive the data we're looking for?
Tables
Forms
Queries
Reports
You have purchased new computers and will be disposing of your old computers. Instead of recycling the computers, you decide to resell them by placing an ad on the Internet. These computers were previously used for storing sensitive information.
To properly protect the accidental discovery of the company's sensitive information, which of the following steps MUST be completed prior to getting rid of the computers?
Include the original operating system discs and product keys with the computers
Delete user data and applications from the hard drives
Reformat the hard drives
Use data wiping software to clear the hard drives
Select the tags you MUST use to have a proper HTML document. (Select three.)
<body>
<html>
<h1>
<head>
<div>
April wants to protect her Small Office Home Office (SOHO) network from malicious data that could enter her network and impact her business. Which of the following provides the BEST solution for protecting her computer from malicious data?
Firewall
Switch
Modem
File server
Brandon, a technician, has recently noticed that the wireless network in the office has slowed down. What could he do to support faster connections?
Upgrade to 802.11g
Change the default password
Enable Wi-Fi Protected Access
Reduce any possible EMI
Which application makes sure your computer has the most recent versions of its system software?
Disk Cleaner
Windows Defender
Windows Update
Backup and Restore
Which of the following are common risks of using social media? (Select two.)
Online information that you post is difficult to remove.
You can be added to a group without your permission.
Personal information can be used without your permission
Privacy settings are virtually non-existent
Anonymity can lead some people to post harmful comments.
