CompTIA Tech+ Part 2 Review

Which feature of a database is essential for handling a growing number of users without performance degradation?

• Fixed data types

• Multiple query options

• Single user access

• Scalability

Answer explanation

Explanation:
Scalability allows a database to handle more users and data without slowing down or crashing.

Real-World Example:
Think of a restaurant—a small diner might struggle with 100 customers at once, but a scalable restaurant expands seating and staff to handle more people efficiently.

When downloading software for your computer, what is a best practice to ensure the software is legitimate?

• Download the software from a link in your email.

• Download the software from a pop-up advertisement that appears while browsing.

• Download the software from the official vendor's website.

• Download the software from a file-sharing service.

Answer explanation

Explanation:
Official websites provide safe, verified versions of software, reducing the risk of malware or fake programs.

Real-World Example:
Would you buy a phone from an official store or a sketchy street vendor? The official store guarantees it’s real!

Which of the following best describes an integer in computer science?

• A single alphanumeric character or symbol.

• A sequence of characters that can include letters, numbers, and symbols.

• A whole number that can be positive, negative, or zero, without any fractional or decimal part.

• A number that includes a fractional part, separated from the integer part by a decimal point.

Answer explanation

Explanation:
Integers include -5, 0, 10, but not 3.14 (which has a decimal).

Real-World Example:
Counting apples in a basket—there’s no such thing as 2.5 apples!

An office manager is tasked with setting up a new wireless network for the company. The manager wants to ensure the network is secured against unauthorized access while maintaining a high level of performance. Which encryption standard should be used for the office's Wi-Fi network?

• WPA2

• WPA

Answer explanation

Explanation:
WPA2 is a strong encryption method that protects Wi-Fi networks from hackers.

Real-World Example:
A locked door with a modern security system is like WPA2—it’s much harder to break into than an old rusty lock (WPA).

What is the purpose of a product key when installing software?

• To activate additional features not included in the base version of the software.

• To uniquely identify each user who installs the software.

• To verify the legitimacy of the software and ensure it is not used beyond its licensed agreement.

• To provide a password for accessing the installed application.

Answer explanation

Explanation:
A product key ensures that only licensed users can install and use the software.

Real-World Example:
Think of a concert ticket—only people with a real ticket can enter the event.

What is the role of methods in programming?

• They are used to store pieces of data for an object in object-oriented programming.

• They are commands used to manipulate the user interface of an application.

• They provide the main structure and definition for objects in object-oriented programming.

• They define a set of instructions that perform a specific task when called upon in a program.

Answer explanation

Explanation:
A method is a reusable piece of code that performs an action, like adding numbers or displaying text.

Real-World Example:
A coffee machine has a method to brew coffee when you press a button.

You are responsible for updating inventory records after a shipment has arrived. To accurately reflect the new stock levels, what direct/manual method would you use to update the existing records in the company's relational database?

• Using a file transfer protocol to replace the database file with an updated version.

• Opening the database file in a text editor and manually changing the record values.

• Editing a spreadsheet that is used to bulk import data at a later time.

• Executing an SQL UPDATE statement through the database's command-line interface.

Answer explanation

Explanation:
The UPDATE statement allows you to change specific data in a database efficiently.

Real-World Example:
If a customer changes their phone number, updating their record directly in the database ensures it stays current.

What type of data is considered critical when developing a business continuity plan?

• Redundant backup copies of old email archives.

• System logs and application binaries.

• Customer databases and financial records.

• Temporary files and cached user profiles.

Answer explanation

Explanation:
Customer and financial data are essential for business operations—losing them could shut down a company.

Real-World Example:
If an online store loses customer order data, they wouldn’t know who bought what!

What does the term 'GB' stand for in computing when referring to data storage capacity?

• Gigablock

• Gigabit

• Gigaquad

• Gigawatt

• Gigabyte

Answer explanation

Explanation:
A gigabyte (GB) is a unit of storage equal to 1,024 megabytes (MB).

Real-World Example:
A typical movie file might be 2GB in size, meaning it takes up 2 gigabytes of storage.

When configuring a new email client, which protocol should be used if the user needs to continuously sync and access email messages from multiple devices?

• SMTP

• HTTP/S

• POP3

• IMAP

Answer explanation

Explanation:
IMAP stores emails on the server, allowing access from multiple devices while staying synchronized.

Real-World Example:
When you check email on your phone and laptop, IMAP ensures both devices show the same inbox.