WorksheetsITF-Practice-Sample1
Total questions: 75
Worksheet time: 38mins
Katy has uninstalled a photo editing application, but an icon still appears on her web browser for the application. Which of the following is the BEST solution for getting rid of the icon?
Remove the application add-on in the web browser.
Disable the application add-on in the web browser.
Clear browsing data and launch a new instance of the browser.
Re-install and then uninstall the application.
April is a database manager who wants to insert some new records (rows) into the company's customer contact database. Instead of using a database client to insert the records, she wants to use a command. Which of the following languages provides a command for inserting records into a database?
DDL (Data Definition Language)
DCL (Data Control Language)
DML (Data Manipulation Language)
HTML (HyperText Markup Language)
Databases, authentication, and user accounts are all part of a website's ________.
Frontend
Protocols
Backend
Full stack
What of the following is a reserved character in the ext4 file system?
?
|
:
/
Which of the following helps you determine your level of software product technical support?
Software agreement
Product key
Product ID
Enterprise license
Which type of RAM runs at the same clock speed as the CPU and data bus?
SDRAM
DRAM
Flash memory
Static RAM
Modern computing devices are getting smaller, lighter, and more energy efficient. What is an example of a CPU that meets these criteria?
Apyc processor
Xeon processor
Pentium processor
Atom processor
Dan is using Search on his web browser to find Clearwater Beach, which could be in Alabama or Florida. Which of the following search phrases would help Dan find the beach location MOST effectively?
"Clearwater Beach" Alabama OR Florida
"Clearwater Beach Alabama +Florida"
"Clearwater Beach" Alabama +Florida
Clear* Beach Alabama OR Florida
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?
Form
Constraint
Schema
Primary key
What must a laptop have in order to work outside of the house and still remain connected to the internet?
WLAN card
Infrared sensor
FireWire connection
Bluetooth module
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 indicates that a website is using a valid digital certificate to secure the website and encrypt data?
The web browser is updated to the latest version.
A padlock symbol is displayed to the left of the URL in the address bar.
The URL starts with "https" instead of "http".
There are no pop-up windows that appear when you access the website.
Which of the following are examples of event logging?
An application requiring multifactor authentication.
A system manager implementing an access control list.
A network keeping track of a user signing in and out of an account.
A network file server keeping metadata for each file.
A web browser storing visited URLs in its history.
As a software developer, you need to create a variable to store postal codes. Which data type would you MOST likely use?
String
Integer
Boolean
Float
You are trying to connect a new USB device to your computer. You install the driver and then connect the device to an open USB port. The device does not work. Which of the following troubleshooting steps is the BEST to try first?
Install a new USB controller card.
Replace the USB device.
Make sure the USB device is plugged in properly.
Try a different USB cable.
A system administrator is part of an IT team planning to install virtual private network (VPN) connection software on all company laptops and desktops. Which of the following is the MOST important precaution that should be taken before installing the software?
Update passwords on the company devices before installing the software.
Make sure the website transaction for purchasing the software is secure.
Obtain the installation files from a legitimate source.
Back up all data files on all company devices before installing the software.
A business has come up with a new logo for the company and they want to protect the logo as part of their brand. Which of the following protections should they use?
Trademark
Copyright
Patent
Intellectual property
What is the name of the large background area of the Windows environment that holds icons for files, folders, and applications?
Background
Home Screen
Window
Desktop
Joe, a user, receives an email from a popular video streaming website urging him to renew his membership. The email appears official, but Joe has never had a membership before. When Joe looks closer, he discovers that a hyperlink in the email points to a suspicious URL. Which of the following security threats does this describe?
Zero-day attack
Man-in-the-middle
Phishing
Trojan horse
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
Float
Integer
String
Which of the following runs exclusively from the cloud, relying on cloud technologies?
Microsoft Word
Adobe Acrobat Reader
Adobe Photoshop
Google Drive
Dropbox
The troubleshooting methodology starts by identifying the problem. The first step in identifying the problem is to gather information. Which of the following is the NEXT step?
Establish a plan of action
Identify symptoms
Establish a theory of probable cause
Duplicate the problem, if possible
A mobile device has poor performance and is slow to respond to screen inputs. After troubleshooting, a technician decides to perform a factory reset. Which of the following actions should a technician take before doing so?
Ensure that the battery is fully charged.
Backup all data to an attached computer or a cloud backup service.
Perform a remote wipe to clear any personal data.
Close all running applications.
Which of the following is not a form of biometrics?
Fingerprint
Smart card
Face recognition
Retina scan
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'
DELETE * FROM Suppliers WHERE supplier_name = 'CafeFresh'
Your company wants to use multifactor authentication. Which of the following would you most likely suggest?
Token and smartphone
PIN and smart card
Password and passphrase
Fingerprint and retinal scan
Which of the following refers to digital content that is delivered over the internet?
World wide web
ISP
Network
TCP/IP suite
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 would best prevent an unauthorized person from remotely accessing your computer?
Anti-spam software
Firewall
Lockdown device
Anti-malware software
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
Lynda, a programmer, is developing a Linux device driver in assembly language. Many device drivers are written in the C language. Which of the following is the BEST reason for using assembly language instead of C?
Code written in assembly is easier to read than compiled C code.
Assembly code is more portable than C.
Assembly code is more detailed and doesn't use libraries.
Code written in assembly is more efficient and allows direct access to hardware.
You are troubleshooting a malfunctioning notebook computer. Nothing appears on the LED display when the system is powered on. Which of the following is the BEST step to try first?
Plug in an external monitor
Replace the motherboard
Calibrate the battery
Replace the video card
Designations at the end of file names such as .docx and .html are called ________.
File extensions
File properties
File permissions
File domains
Which of the following is the first thing you should do in the troubleshooting process when trying to identify possible causes of a problem?
A. Divide and conquer to find a possible cause.
B. Check with others to see if they can duplicate the problem.
C. Test your theories to verify the cause of the problem.
D. Check for obvious or common issues.
Julien, a programmer, was fixing a bug in the programming code written by another developer. He discovered that the code with the bug was repeated several times. Instead of fixing the bug in multiple places, which of the following programming features should he use so the code is only located in one place?
Loops
Variables
Functions
Container
Which of the following is the best device to deploy to protect your private network from an untrusted public network?
Gateway
Router
Hub
Firewall
Which programming language type is the most basic human-readable and closest to actual machine language?
Compiled
Assembly
Query
Interpreted
Carol is connecting to a wireless network from her Windows 10 laptop and wants to make sure that her laptop is hidden from other computers on the network and that file sharing is disabled. Which of the following wireless network options should Carol select to enable these features?
Connect automatically
Network security key
Public
Private
In the decimal number system, you can think of each digit representing a place (or column) in the number. For example, in the decimal number 652, the two, the five, and the six are all in different places and each place can be expressed as 10 to a specific power. Which power of 10 does 6 in the above example represent?
10 to the third power
10 to the second power
10 to the zero power
10 to the first power
On a flowchart, which of the following represents a decision?
Rectangle
Arrow
Parallelogram
Diamond
Which of the following software types would be considered collaboration software?
Project management software
Database software
Email client software
Word processing software
A systems engineer wants to encrypt a hard drive that contains critical data. Which type of data encryption can be used to protect the data on the hard drive?
SSL/TLS encryption
WPA2 encryption
Whole disk encryption
Identifying the problem is the first step in CompTIA's troubleshooting model. Which of the following are tasks associated with this step?
Question users
Identify symptoms
Question the obvious
Duplicate the problem
Escalate as necessary
Which of the following has the ability to store user data even if the power to the computer is off?
Cache memory
System memory
Firmware/BIOS
Hard drive
Which of the following is not an advantage of SSDs over HDDs?
Low power consumption
Durable
Small and light
Inexpensive
Rebecca has noticed that her new computer is beginning to run slower than when she first purchased it, especially when using business applications from her hard drive. Which of the following would be the BEST solution to help speed up the processing time on the new computer?
Change the screen display to a lower resolution.
Delete any unwanted data files.
Remove (uninstall) any unnecessary software.
Defragment the hard drive.
In a relational database table, rows are better known as .
Instances
Fields
Categories
David is running a Microsoft SQL Server database that provides an ODBC (Open Database Connectivity) driver that allows applications to access database management systems (DBMSs) using SQL commands. The database setup stores employees' personal information used by Human Resources and company managers. In addition to the database setup, David has provided an application that lets employees modify their personal information. The application utilizes the ODBC and SQL commands to make changes to the employee records in the database. Which combination of database access methods reflects the environment David has configured to store and manage employees' personal information?
Programmatic access and user interface access
Direct access and query builder
Query builder and programmatic access
Programmatic access and direct access
Becca is working on a program that will store data. The program will need quick access to data and data persistence is not important. Where should the data be stored?
In flash memory
In a database
In memory
In a flat file
Your company is having issues with employees who write down their passwords on sticky notes, paper notepads, and other types of paper. Even though they're often hidden in drawers or behind computer equipment, it is still a high security risk for the company. As the managing IT administrator for your company, what is the BEST solution to reduce or eliminate this issue?
Work with Human Resources to provide security training.
Provide employees with training on how to create strong passwords.
Physically monitor the employees with a CCTV system.
Update the acceptable use policy (AUP).
Besides entering a URL to go directly to a website, what else can you enter in a browser address bar to explore the internet?
Enter a package tracking number to find out a package status.
Enter the filename of a file on your local hard drive to view the file.
Enter a MAC address to find out which device it is assigned to.
Enter one or more search terms for a topic.
Which DOCSIS version introduced support for download speeds of up to 1.2 Gbps?
2.0
1.0
3.1
3.0
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 of the following are examples of Type 1 (something you know) identification?
A. Single-use passwords
B. Software tokens
C. Voice recognition
D. Hardware tokens
E. Personally identifiable information (PII)
Read the description and each database object. Select the one that is matched with its correct description and database object.
Formatted summary of information from a database – Report. User-friendly interface for adding to or retrieving information from a database – Form. Stores raw data in a relational database – Table. Retrieves specific information from a database. Can also be used to update, edit, and delete information – Query.
Formatted summary of information from a database – Form. User-friendly interface for adding to or retrieving information from a database – Report. Stores raw data in a relational database – Table. Retrieves specific information from a database. Can also be used to update, edit, and delete information – Query.
Formatted summary of information from a database – Table. User-friendly interface for adding to or retrieving information from a database – Form. Stores raw data in a relational database – Query. Retrieves specific information from a database. Can also be used to update, edit, and delete information – Report.
Formatted summary of information from a database – Query. User-friendly interface for adding to or retrieving information from a database – Form. Stores raw data in a relational database – Report. Retrieves specific information from a database. Can also be used to update, edit, and delete information – Table.
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?
Robotics
IoT
Home automation
Smart devices
Object-Oriented Programming (OOP) is a newer approach to programming where functionality is divided into smaller groups of tasks and actions. With OOP, you can model real world objects in a programming language. There are two main concepts. The first is like a template, and the second is the specific models built from the templates. What are these two concepts called?
A. Attributes
C. Objects
B. Classes
E. Values
D. Properties
What is the first step of the data analytics process?
Generating information
Creating a data report
Using statistical tools to analyze data
Collecting raw data
You've just finished installing a wireless access point for a client. Which action best protects the access point from unauthorized tampering with its configuration settings?
Disabling DHCP
Disabling SSID broadcast
Changing the default administrative password
Implementing MAC address filtering
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?
CREATE BACKUP DATABASE database_name
CREATE BACKUP database_name
BACKUP database_name
BACKUP DATABASE database_name
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.
Jacob is using a Linux operating system; the file type is an image file.
Which of the following encoding schemes would MOST likely be used to represent an emoji?
ASCII
Unicode
Hexadecimal
Binary
In addition to having a good backup that can restore files that have been encrypted as a result of a ransomware attack, which of the following is one of the BEST ways to avoid being threatened to pay a ransom?
Refuse to pay any ransom
Train employees on social engineering attacks
Keep all copyrights, patents, and trademarks up-to-date
Protect confidential company information
Which of the following lists the basic computing and processing steps in order?
A. Input, retrieval, processing, and storage
B. Input, processing, output, and storage
C. Input/output, processing, and storage
D. Input, retrieval, output, and storage
Assigning a unique letter (such as N:) to a shared drive is called __________ the drive.
A. Mapping
B. Formatting
C. Encrypting
D. Partitioning
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 is more likely to be available at his new home.
DSL provides higher upload and download speeds.
DSL does not interfere with voice calls.
DSL cables provide better performance over longer distances.
While browsing the Internet on a Windows 10 workstation, the Internet Explorer browser window hangs and stops responding. Which Task Manager tab would you use to end Internet Explorer? (Select two.)
A. Performance
B. Processes
Startup
Services
Details
Email and instant messaging (IM) seem to be very similar. What is the major difference between the two communication systems?
Email is much faster.
With instant messaging, you and the message recipient are logged into the same sever.
With instant messaging, you and the message recipient are logged into different servers.
With email, you and the message recipient are logged into the same server.
Which of the following networking interfaces connects a computer to a wired local area network (LAN)?
NFC
RJ-45
RJ-11
RFID
Diana, a developer, needs to program a logic component that will allow the user to enter a series of values. Which of the following would BEST provide that functionality?
Scripting
Branching
Looping
Case statement
Which of the following is an advantage of DisplayPort 1.4 over HDMI 2.0?
DisplayPort connection monitors are less expensive than HDMI connection monitors.
DisplayPort is supported by more devices than HDMI.
DisplayPort has a greater maximum bandwidth than HDMI.
DisplayPort can connect gaming consoles; HDMI can only connect computers to monitors.
What do you call the software that can communicate with a computer's hardware, provides a user interface to accept commands, maintains a filing system, and has built-in security features?
Database
Virus software
Operating system
Intrusion prevention system
Which of the following is the correct binary representation of the number 22?
10101
10110
10111
11000
What is junk email?
Unwanted, unsolicited email
Email applications that don't function well
Poorly worded email drafts
Another name for webmail applications
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.
