Knowledge + Practice

CompTIA ITF+ FC0-U61 (FC0-U61) — Questions 826–900

986 questions total · 14pages · All types, answers revealed

Take a mock exam Exam hub

Page 12 of 14

826

MCQhard

You are the IT support technician for a small office with 5 computers, a shared printer, and a router providing internet access. Users report that the network has been slow and intermittent for the past two days. Additionally, print jobs from multiple users are frequently stuck or fail halfway. You have already verified that all network cables are securely connected, restarted the router and printer, and updated the printer drivers. The issue persists. One user mentions that their computer sometimes shows a 'Windows has detected an IP address conflict' notification. Based on this scenario, which course of action should you take next to resolve the most likely root cause?

A.Check for IP address conflicts on the network and assign static IP addresses if necessary

B.Disable Windows Firewall on all computers

C.Reinstall the operating system on all computers

D.Replace the network switch with a new one

AnswerA

An IP address conflict causes intermittent connectivity and can disrupt printer communication; resolving the conflict will restore stability.

Why this answer

Option C (Check for IP address conflicts) is correct because the IP conflict notification strongly indicates that two devices on the network have the same IP address, causing intermittent connectivity and printer issues. Option A (Replace the network switch) is premature and would not resolve a conflict. Option B (Disable the Windows Firewall) is unrelated and could introduce security risks.

Option D (Reinstall the operating system) is too drastic and unlikely to fix an IP conflict.

Full explanation →

827

MCQmedium

A small business owner wants to protect sensitive customer data stored on a laptop that is frequently used on public Wi-Fi networks. The owner is considering implementing a security control that ensures data remains confidential even if the laptop is stolen. Which of the following is the BEST control for this scenario?

A.Use a VPN when connected to public Wi-Fi

B.Install antivirus software

C.Implement full-disk encryption

D.Require a strong password for user login

AnswerC

Full-disk encryption protects data at rest by encrypting the entire drive, so data is unreadable without the decryption key.

Why this answer

Full-disk encryption (FDE) protects data at rest by encrypting the entire storage volume, typically using AES-128 or AES-256. Even if the laptop is stolen, the encrypted data remains unreadable without the decryption key, ensuring confidentiality. This directly addresses the requirement for data protection after physical theft.

Exam trap

The trap here is that candidates confuse encryption of data in transit (VPN) with encryption of data at rest (FDE), or assume that a strong password alone is sufficient to protect data after physical theft.

How to eliminate wrong answers

Option A is wrong because a VPN encrypts data in transit over public Wi-Fi, but does not protect data stored on the laptop if it is stolen. Option B is wrong because antivirus software detects and removes malware but does not encrypt data or prevent access to stored files after theft. Option D is wrong because a strong password protects the login screen but can be bypassed by booting from a live USB or removing the hard drive, leaving the data accessible.

Full explanation →

828

MCQeasy

A user wants to ensure that a document cannot be edited by others. Which file property should be set?

A.Archive

B.Hidden

C.System

D.Read-only

AnswerD

Read-only prevents modifications to the file.

Why this answer

The read-only property prevents users from modifying or deleting the file's contents, as it restricts write access to the file. When set, any attempt to edit and save the document will result in an error unless the file is saved with a new name or the property is cleared. This is the standard file attribute used in Windows and other operating systems to enforce write protection at the file system level.

Exam trap

The trap here is that candidates confuse the read-only property with the hidden or system attributes, mistakenly thinking that hiding a file or marking it as system will prevent editing, when in fact only read-only enforces write protection at the file system level.

How to eliminate wrong answers

Option A is wrong because the archive attribute is used by backup software to mark files that have been modified since the last backup, and it does not restrict editing. Option B is wrong because the hidden attribute simply hides the file from normal directory listings, but it does not prevent the file from being opened, edited, or deleted by a user who knows its path. Option C is wrong because the system attribute marks a file as critical to the operating system, which can protect it from casual deletion but does not inherently prevent editing; it is intended for OS files, not user documents.

Full explanation →

829

Multi-Selectmedium

Which TWO of the following are examples of high-level programming languages? (Select TWO).

Select 2 answers

A.Machine code

B.Assembly

C.Python

D.Java

E.Binary

AnswersC, D

Python is a high-level language with strong abstraction.

Why this answer

Python and Java are both high-level programming languages because they provide strong abstraction from the computer's hardware, using human-readable syntax and automatic memory management. Python is interpreted and dynamically typed, while Java is compiled to bytecode and statically typed, but both allow developers to write code without managing registers or memory addresses directly.

Exam trap

CompTIA often tests the distinction between 'high-level' and 'low-level' languages, and the trap here is that candidates confuse 'binary' or 'machine code' with a programming language, or think assembly is high-level because it uses readable mnemonics.

Full explanation →

830

MCQhard

Refer to the exhibit. A user is unable to access the internet but can ping the default gateway. Based on the exhibit, what is the most likely cause?

A.Firewall blocking traffic

B.Duplicate IP address

C.Incorrect DNS server

D.Incorrect subnet mask

AnswerC

If the DNS server is misconfigured or unreachable, the user cannot resolve domain names to IP addresses, even though local connectivity works.

Why this answer

The user can ping the default gateway, which confirms that Layer 3 connectivity to the local network is working and that the firewall is not blocking ICMP traffic. However, the inability to access the internet (by name or IP) while local connectivity works points to a failure in name resolution. An incorrect DNS server address prevents the client from resolving domain names to IP addresses, which is the most likely cause given the symptoms.

Exam trap

The trap here is that candidates often assume 'no internet' means a firewall or routing issue, but the ability to ping the gateway proves Layer 3 connectivity is fine, forcing the focus onto DNS as the missing piece for name-based access.

How to eliminate wrong answers

Option A is wrong because if a firewall were blocking traffic, it would typically block all outbound traffic or specific protocols, but the user can successfully ping the default gateway (which often passes through the same firewall), so a firewall is not the issue. Option B is wrong because a duplicate IP address would cause intermittent connectivity or complete loss of network access, often with an address conflict warning, and would likely prevent pinging the default gateway reliably. Option D is wrong because an incorrect subnet mask would prevent the user from reaching the default gateway at all (since the host would calculate that the gateway is on a different subnet), yet the user can ping the gateway, so the subnet mask must be correct.

Full explanation →

831

MCQhard

A company implements a policy where employees must swipe their ID card and then enter a PIN to access the server room. Which two authentication factors are being used?

A.Something you know and something you are

B.Something you have and something you are

C.Something you have and something you know

D.Something you know and somewhere you are

AnswerC

Correct. ID card is something you have; PIN is something you know.

Why this answer

The ID card is 'something you have' (possession factor) and the PIN is 'something you know' (knowledge factor). This is multi-factor authentication.

Full explanation →

832

MCQmedium

A database administrator needs to add a new customer record to the 'customers' table. Which SQL statement should they use?

A.INSERT INTO customers VALUES (...)

B.DELETE FROM customers WHERE ...

C.SELECT * FROM customers

D.UPDATE customers SET ...

AnswerA

INSERT INTO adds a new row.

Why this answer

INSERT INTO is used to add new records to a table.

Full explanation →

833

MCQmedium

A user wants to upgrade their laptop's storage to improve boot times and file transfer speeds. The laptop has an available M.2 slot. Which type of drive should the user choose?

A.2.5-inch SATA HDD

B.SATA M.2 SSD

C.NVMe M.2 SSD

D.External USB 3.0 HDD

AnswerC

NVMe M.2 SSDs use PCIe lanes and are much faster than SATA.

Why this answer

NVMe M.2 drives are significantly faster than SATA drives because they use the PCIe bus, offering much higher read/write speeds for booting and file transfers.

Full explanation →

834

MCQhard

A small business owner wants to purchase a software application for accounting. The application is available under two licenses: a single-user commercial license for $500, and a GNU General Public License (GPL) version for free. The owner is concerned about support and future updates. Which of the following is a key consideration for the owner?

A.The GPL version cannot be used for commercial purposes.

B.The owner can pay a developer to modify the GPL version to include needed features.

C.The GPL version will likely have no support options.

D.The commercial license is required to obtain paid support.

AnswerB

The GPL allows modification, so hiring a developer for custom features is a key benefit.

Why this answer

The GNU General Public License (GPL) is a copyleft license that grants users the freedom to run, study, share, and modify the software. Because the owner can access the source code, they can legally hire a developer to add features or fix bugs, which directly addresses the concern about support and updates. This makes option B correct, as it highlights a key advantage of open-source licensing.

Exam trap

The trap here is that candidates mistakenly believe open-source licenses like the GPL prohibit commercial use or lack any support options, when in fact they permit commercial use and often have robust community or third-party support ecosystems.

How to eliminate wrong answers

Option A is wrong because the GPL explicitly allows commercial use; the 'commercial' restriction is a common misconception, and the GPL only requires that modified versions also be distributed under the GPL. Option C is wrong because while the GPL version may lack official vendor support, community forums, documentation, and third-party support options often exist, and the owner could also contract a developer for support. Option D is wrong because paid support is not exclusive to commercial licenses; many open-source projects offer paid support contracts, and the owner could also obtain support from third-party vendors or community resources.

Full explanation →

835

Multi-Selecthard

A company's IT policy mandates data backups following the 3-2-1 rule. Which THREE of the following practices align with this rule?

Select 3 answers

A.Keeping one backup on the same external drive as the original

B.Having the original data on a server, a backup on a tape, and another backup on a separate cloud

C.Having a local backup on a NAS and a remote backup on a different cloud provider

D.Storing one backup in a cloud storage service

E.Using two different external hard drives for backups, both kept in the same building

AnswersB, C, D

Three copies on two media types (server/cloud and tape) with one offsite.

Why this answer

The 3-2-1 rule means: at least 3 copies of data, on 2 different media types, with 1 copy offsite.

Full explanation →

836

MCQmedium

A user is selecting a new computer and sees that the CPU has a clock speed of 3.6 GHz and four cores. What does the clock speed of 3.6 GHz indicate?

A.The number of instructions per cycle

B.The number of billions of cycles per second

C.The power consumption of the CPU

D.The amount of cache memory available

AnswerB

GHz means billions of cycles per second.

Why this answer

Clock speed (GHz) indicates how many billions of cycles per second the CPU can execute. It does not directly indicate cache size, core count, or power consumption.

Full explanation →

837

MCQmedium

Refer to the exhibit. A user is able to browse the internet using the Ethernet connection but not the Wi-Fi. What is the most likely cause?

A.The Wi-Fi adapter is not connected to any network

B.The Wi-Fi adapter is disabled

C.The DNS suffix is missing

D.The default gateway is incorrect

AnswerA

'Media disconnected' indicates no active wireless connection.

Why this answer

The exhibit shows that the Ethernet interface has an IP address (192.168.1.114) and is connected to the internet, while the Wi-Fi interface shows 'Not connected' with no IP address assigned. Since the user can browse the internet via Ethernet but not Wi-Fi, the most likely cause is that the Wi-Fi adapter is not connected to any network, meaning it has not associated with a wireless SSID or obtained an IP address via DHCP.

Exam trap

The trap here is that candidates may confuse 'Not connected' with a disabled adapter or a configuration issue like a missing DNS suffix, but the exhibit clearly shows the Wi-Fi adapter is enabled yet has no IP address, pointing to a lack of network association.

How to eliminate wrong answers

Option B is wrong because if the Wi-Fi adapter were disabled, it would typically show a status like 'Disabled' or 'Not operational' in the network settings, not 'Not connected' — the adapter is enabled but not associated with a network. Option C is wrong because a missing DNS suffix would not prevent the Wi-Fi adapter from obtaining an IP address or connecting to a network; it would only affect name resolution, and the user can already browse via Ethernet, indicating DNS is working. Option D is wrong because an incorrect default gateway would still allow the adapter to show a connected status with an IP address, but the user would be unable to reach external networks — the exhibit shows the Wi-Fi adapter has no IP address at all, so the gateway is irrelevant.

Full explanation →

838

MCQeasy

What is the primary purpose of a password manager?

A.To generate and store strong, unique passwords

B.To store passwords in the cloud

C.To share passwords with others

D.To bypass authentication

AnswerA

Correct. Password managers create and manage complex passwords.

Why this answer

Password managers generate and store strong, unique passwords for each account, reducing password reuse.

Full explanation →

839

MCQeasy

A database administrator wants to enforce that a column only accepts whole numbers. Which data type should be used?

A.Integer

B.String

C.Boolean

D.Float

AnswerA

Integer stores whole numbers without decimals.

Why this answer

The INTEGER data type is specifically designed to store whole numbers without fractional components. In database systems, enforcing a column to accept only whole numbers requires a data type that disallows decimal points, which INTEGER does by definition. Using INTEGER ensures data integrity by rejecting any non-integer input, such as 3.14 or 'abc'.

Exam trap

The trap here is that candidates often confuse FLOAT with INTEGER, assuming FLOAT can store whole numbers, but FLOAT always permits decimal places, which violates the 'whole numbers only' constraint.

How to eliminate wrong answers

Option B (String) is wrong because strings can store any sequence of characters, including non-numeric values like 'hello' or '123.45', and do not enforce numeric constraints. Option C (Boolean) is wrong because Boolean only stores true/false values (often 0 or 1), not arbitrary whole numbers like 42 or -7. Option D (Float) is wrong because Float stores approximate numeric values with decimal points (e.g., 3.14 or 2.0), allowing fractional parts that violate the requirement for whole numbers only.

Full explanation →

840

MCQhard

A software team uses version control and one developer commits a change that breaks the build. Which practice should be enforced to prevent this in the future?

A.Schedule daily automated builds

B.Require peer review for all commits

C.Implement a code freeze during releases

D.Set up a pre-commit hook to run unit tests

AnswerD

Pre-commit hooks automatically run tests, rejecting commits that break them.

Why this answer

Option D is correct because a pre-commit hook runs automated unit tests on the developer's local machine before the commit is accepted. If the tests fail, the commit is blocked, preventing broken code from entering the shared repository and breaking the build. This enforces immediate validation at the point of commit, catching issues before they affect other team members.

Exam trap

The trap here is that candidates confuse 'preventing' with 'detecting'—they choose daily builds (A) or peer review (B) because those are familiar practices, but only a pre-commit hook actively blocks the broken code from being committed in the first place.

How to eliminate wrong answers

Option A is wrong because scheduling daily automated builds detects breakage after the fact, not preventing it; the broken commit still enters the repository and disrupts the team until the next build runs. Option B is wrong because peer review focuses on code quality and logic, but it does not automatically run tests or block a commit that would break the build; a reviewer might miss a test failure. Option C is wrong because a code freeze is a temporary measure to stabilize a release, not a continuous practice to prevent build breaks from everyday commits.

Full explanation →

841

MCQhard

You are a junior developer at a small company that uses a monolithic web application written in Python. The application runs on a single server and uses a MySQL database. Recently, the application has become slow during peak hours. The operations team reports high CPU usage on the server. You suspect that the database queries are not optimized. You propose to refactor the application to use a caching layer. However, your manager is concerned about adding complexity and suggests that you first optimize the most frequently executed queries. You review the code and find that the most frequent query selects all columns from a large table without a WHERE clause. The table has over 1 million rows. Which course of action should you take?

A.Implement a caching layer using Redis.

B.Upgrade the server to have more CPU and RAM.

C.Add an index on all columns used in the query.

D.Modify the query to include a WHERE clause that filters on an indexed column.

AnswerD

Adding a WHERE clause reduces the amount of data retrieved, improving performance.

Why this answer

Option D is correct because the query selects all columns from a large table without a WHERE clause, which forces a full table scan. Adding a WHERE clause that filters on an indexed column reduces the number of rows scanned, dramatically improving performance without introducing the complexity of a caching layer. This directly addresses the high CPU usage caused by inefficient query execution.

Exam trap

The trap here is that candidates assume adding an index always speeds up any query, but without a WHERE clause, an index is never used—the database still must scan the entire table.

How to eliminate wrong answers

Option A is wrong because implementing a caching layer (e.g., Redis) adds architectural complexity and does not fix the root cause—the unoptimized query itself; caching would only mask the problem and could lead to stale data issues. Option B is wrong because upgrading hardware (more CPU/RAM) treats the symptom (high CPU usage) rather than the cause (inefficient query), and it is a costly, temporary fix that does not improve query logic. Option C is wrong because adding an index on all columns used in the query is meaningless for a SELECT * without a WHERE clause—indexes speed up row filtering, not full table scans; the query still retrieves every row, so no index can help.

Full explanation →

842

MCQmedium

An organization wants to ensure that employees only have access to the data necessary to perform their job functions. Which principle should be applied?

A.Defense in depth

B.Separation of duties

C.Mandatory access control

D.Least privilege

AnswerD

Users get minimum necessary permissions.

Why this answer

The principle of least privilege grants users only the permissions they need to do their work, minimizing potential damage.

Full explanation →

843

Multi-Selectmedium

Which TWO of the following are benefits of virtualization in a data center?

Select 2 answers

A.Improved disaster recovery capabilities

B.Increased hardware reliability

C.Reduced hardware footprint

D.Enhanced physical security

E.Simplified network configuration

AnswersA, C

VMs can be backed up and migrated easily.

Why this answer

Virtualization enables rapid restoration of virtual machines (VMs) from snapshots or backups, often within minutes, regardless of underlying hardware failures. This decoupling of the OS from physical hardware allows VMs to be migrated or recovered on different hosts, significantly improving recovery time objectives (RTOs) and recovery point objectives (RPOs) compared to physical server recovery.

Exam trap

The FC0-U61 exam often tests the misconception that virtualization inherently improves hardware reliability or simplifies networking, when in fact it primarily improves resource utilization and disaster recovery capabilities.

Full explanation →

844

MCQhard

A company is designing a disaster recovery plan. They need to restore operations within 4 hours and can tolerate up to 1 hour of data loss. Which combination of Recovery Time Objective (RTO) and Recovery Point Objective (RPO) should they set?

A.RTO = 4 hours, RPO = 1 hour

B.RTO = 2 hours, RPO = 1 hour

C.RTO = 4 hours, RPO = 4 hours

D.RTO = 1 hour, RPO = 4 hours

AnswerA

RTO of 4 hours meets the requirement; RPO of 1 hour meets the data loss tolerance.

Why this answer

The Recovery Time Objective (RTO) defines the maximum acceptable downtime to restore operations, which is 4 hours. The Recovery Point Objective (RPO) defines the maximum acceptable data loss measured in time, which is 1 hour. Option A correctly matches these requirements: RTO = 4 hours and RPO = 1 hour.

Exam trap

The trap here is that candidates often confuse RTO and RPO, swapping the values or assuming tighter objectives are always better, rather than matching them precisely to the stated business requirements.

How to eliminate wrong answers

Option B is wrong because it sets RTO = 2 hours, which is stricter than the required 4 hours; while this would meet the requirement, it is not the correct combination as the question asks for the specific values they should set based on the given tolerances. Option C is wrong because it sets RPO = 4 hours, which would allow up to 4 hours of data loss, exceeding the 1-hour tolerance. Option D is wrong because it swaps the objectives: RTO = 1 hour (too strict) and RPO = 4 hours (too lenient), failing both the 4-hour recovery and 1-hour data loss tolerances.

Full explanation →

845

MCQeasy

Refer to the exhibit. A database administrator executes the DELETE statement, and it reports success. However, a subsequent SELECT still shows the row. Which is the most likely explanation?

A.The table is locked by another user.

B.The WHERE clause used the wrong value.

C.The command was not committed.

D.The user lacks DELETE privilege.

AnswerC

Without COMMIT, the deletion is not finalized and can be rolled back.

Why this answer

In SQL databases, a DELETE statement removes rows from a table only when the transaction is committed. If the database is using implicit transactions or the user has not issued a COMMIT command, the deletion is held in a pending transaction and remains visible to other sessions (or even the same session if read consistency is applied). The reported 'success' indicates the statement executed without error, but without a commit, the changes are not made permanent, so a subsequent SELECT still shows the row.

Exam trap

CompTIA often tests the distinction between statement execution success and transaction permanence, trapping candidates who assume 'success' means the data is immediately visible to all queries.

How to eliminate wrong answers

Option A is wrong because a table lock by another user would typically cause the DELETE to wait or fail, not report success while still showing the row; locks block conflicting operations, not hide committed changes. Option B is wrong because if the WHERE clause used the wrong value, the DELETE would still report success (0 rows affected) and the original row would remain, but the question states the DELETE 'reports success' and the row is still there—this could happen, but the most likely explanation in a database context is a missing commit, not a WHERE clause error, as the latter is a logic mistake not a transaction issue. Option D is wrong because lacking DELETE privilege would cause the statement to fail with an error (e.g., 'permission denied'), not report success.

Full explanation →

846

MCQmedium

A small business wants to set up a wireless network for employees and guests. The owners are concerned about unauthorized access. Which of the following security measures would be MOST effective to prevent outsiders from connecting?

A.Enable MAC address filtering

B.Disable SSID broadcast

C.Disable DHCP on the router

D.Use WPA2 encryption with a strong passphrase

AnswerD

WPA2 provides strong encryption and authentication.

Why this answer

WPA2 encryption with a strong passphrase is the most effective measure because it encrypts all wireless traffic and requires authentication before a device can join the network. Without the correct pre-shared key (PSK), an attacker cannot decrypt the data or gain access, even if they can see the network. This directly prevents unauthorized outsiders from connecting, unlike the other options which are easily bypassed.

Exam trap

The trap here is that candidates often think MAC filtering or hiding the SSID are strong security measures, but these are 'security through obscurity' techniques that provide no real protection against a determined attacker.

How to eliminate wrong answers

Option A is wrong because MAC address filtering can be easily circumvented by an attacker using packet sniffing to discover allowed MAC addresses and then spoofing one of them. Option B is wrong because disabling SSID broadcast only hides the network name from simple scans; an attacker can still discover the SSID using passive monitoring tools like Wireshark or airodump-ng. Option C is wrong because disabling DHCP does not prevent connection; an attacker can still associate with the wireless network and manually configure a static IP address within the subnet.

Full explanation →

847

Multi-Selecthard

A developer is debugging a program that is producing incorrect output. Which of the following are common debugging techniques? (Choose three.)

Select 3 answers

A.Using a debugger

B.Code review

C.Adding print statements

D.Reinstalling the operating system

E.Changing the program requirements

AnswersA, B, C

Debuggers allow stepping through code and inspecting state.

Why this answer

Common debugging techniques include adding print statements, using a debugger, and performing code reviews. Changing requirements or reinstalling the OS are not debugging techniques.

Full explanation →

848

MCQmedium

A user is trying to install software from an .msi file on a Windows computer. What is the most likely purpose of an .msi file?

A.It is a compressed archive like a .zip file.

B.It is a Microsoft Installer package that automates software installation.

C.It is a script that downloads software from the internet.

D.It is a configuration file for Windows settings.

AnswerB

Correct. .msi stands for Microsoft Installer, used for controlled installation.

Why this answer

An .msi file is a Windows Installer package used for the installation, maintenance, and removal of software. It contains installation instructions and files.

Full explanation →

849

Multi-Selecthard

A company is experiencing frequent application crashes. Which TWO troubleshooting steps should be performed first? (Choose TWO.)

Select 2 answers

A.Check the application event logs for error messages.

B.Update the application to the latest version.

C.Reformat the hard drive and reinstall the operating system.

D.Reinstall the application.

E.Replace the hard drive.

AnswersA, B

Event logs provide clues about the cause of crashes.

Why this answer

Checking the application event logs (Option A) is a critical first step because these logs record specific error codes, timestamps, and stack traces that directly indicate why the application is crashing. This diagnostic data allows you to identify the root cause—such as a missing dependency, memory leak, or permission issue—without making unnecessary changes. Updating the application (Option B) is also a priority because crashes are often caused by known bugs that have been patched in newer versions; applying the latest update can resolve the issue quickly without further troubleshooting.

Exam trap

CompTIA often tests the principle of 'least invasive first'—candidates mistakenly choose reinstallation or hardware replacement because they assume corruption or failure, but the correct first steps are always to gather diagnostic data (logs) and apply known fixes (updates) before escalating to destructive actions.

Full explanation →

850

MCQeasy

A help desk technician needs to retrieve the names and email addresses of all customers who live in 'Chicago'. Which SQL statement should the technician use?

A.UPDATE customers SET city = 'Chicago'

B.SELECT name, email FROM customers WHERE city = 'Chicago'

C.DELETE FROM customers WHERE city = 'Chicago'

D.INSERT INTO customers (name, email) VALUES (...)

AnswerB

This retrieves the desired columns filtered by city.

Why this answer

The SELECT statement is used to query data from a database. Option B correctly uses SELECT to retrieve the 'name' and 'email' columns from the 'customers' table, filtered by the WHERE clause to only include rows where the 'city' column equals 'Chicago'. This matches the technician's requirement to retrieve specific data without modifying or deleting it.

Exam trap

The trap here is that candidates may confuse data retrieval (SELECT) with data manipulation (UPDATE, DELETE, INSERT), especially when the question asks for 'retrieving' data but includes familiar keywords like 'city' and 'Chicago' in the wrong commands.

How to eliminate wrong answers

Option A is wrong because UPDATE modifies existing records by setting the city to 'Chicago' for all rows, which does not retrieve any data and would incorrectly change all customers' cities. Option C is wrong because DELETE removes all rows where city is 'Chicago', which destroys data instead of retrieving it. Option D is wrong because INSERT adds new rows to the table, which does not retrieve existing data and would require specifying values, not a condition.

Full explanation →

851

MCQmedium

An employee receives an email that appears to be from the CEO, urgently requesting a wire transfer to an external vendor. The email address looks slightly off. Which type of social engineering attack is this?

A.Pretexting

B.Spear phishing

C.Phishing

D.Vishing

AnswerB

Spear phishing targets a specific person or organization with a tailored message.

Why this answer

This is a phishing attack, specifically spear phishing because it targets a specific individual (the employee) and impersonates the CEO to steal money.

Full explanation →

852

Multi-Selecthard

A developer is writing a program that needs to handle text in multiple languages, including Chinese and Arabic. Which THREE character encoding systems should they consider? (Choose three.)

Select 3 answers

A.UTF-8

B.UTF-16

C.Base64

D.ASCII

E.EBCDIC

AnswersA, B, D

UTF-8 supports all languages.

Why this answer

Unicode (and its implementations UTF-8, UTF-16, UTF-32) and ASCII (though limited) are relevant. UTF-8 is variable-width and supports all languages. ASCII is 7-bit English.

UTF-16 is another Unicode form.

Full explanation →

853

MCQeasy

A technician installs a new network printer. It can communicate with other computers on the same network but no one outside the network can access it. What is the MOST likely cause?

A.Firewall blocking external traffic

B.Incorrect printer driver

C.No IP address configured

D.Faulty Ethernet cable

AnswerA

A firewall often blocks inbound connections from the internet to internal devices.

Why this answer

A firewall is designed to control incoming and outgoing network traffic based on predetermined security rules. If the printer can communicate locally but not with external networks, the most likely cause is that the firewall is blocking inbound traffic from outside the local subnet, preventing external devices from reaching the printer's IP address or port.

Exam trap

The trap here is that candidates may confuse a firewall blocking external traffic with a network connectivity issue, such as a faulty cable or missing IP address, but the key clue is that local communication works fine, isolating the problem to external access control.

How to eliminate wrong answers

Option B is wrong because an incorrect printer driver would affect print job formatting or functionality, not network connectivity or external access. Option C is wrong because if no IP address were configured, the printer would not be able to communicate with any computers on the same network, contradicting the scenario. Option D is wrong because a faulty Ethernet cable would cause a complete loss of network connectivity, not a selective inability to access the printer from outside the local network.

Full explanation →

854

MCQmedium

A graphic designer needs to create vector logos that can be scaled without losing quality. Which software category is most appropriate?

A.Vector graphics editor

B.Desktop publishing software

C.Raster graphics editor

D.Photo editing software

AnswerA

Vector editors use paths that scale without quality loss.

Why this answer

Vector graphics editors, such as Adobe Illustrator or Inkscape, use mathematical equations (paths) to define shapes, lines, and curves. This allows the image to be scaled to any size without pixelation or loss of quality, which is essential for professional logo design. Raster-based tools cannot achieve this because they rely on a fixed grid of pixels.

Exam trap

The trap here is that candidates confuse 'photo editing software' (like Photoshop) with the ability to create scalable graphics, not realizing that Photoshop's vector tools are limited and its primary rendering is raster-based, making it unsuitable for pure vector logo work.

How to eliminate wrong answers

Option B (Desktop publishing software) is wrong because it is designed for layout and typesetting of documents (e.g., Adobe InDesign), not for creating or editing vector artwork from scratch. Option C (Raster graphics editor) is wrong because it works with a fixed grid of pixels (e.g., Adobe Photoshop), so scaling up causes pixelation and loss of sharpness. Option D (Photo editing software) is wrong because it is a subset of raster graphics editors, focused on manipulating photographs, and similarly suffers from resolution-dependent scaling.

Full explanation →

855

MCQmedium

Which of the following is an example of a lossy compression format?

A.GIF

B.PNG

C.JPEG

D.ZIP

AnswerC

Correct.

Why this answer

JPEG is a lossy image compression format that discards some data to reduce file size.

Full explanation →

856

MCQhard

A medium-sized business has a policy that requires all employees to use two-factor authentication (2FA) when accessing the corporate email system. The authentication method uses a time-based one-time password (TOTP) app on employees' smartphones. Several employees have reported that they cannot log in because they recently changed phones and did not transfer the TOTP seed. The help desk has been resetting 2FA for these users, but management is concerned about the security of the reset process. Which of the following procedures should the help desk follow to securely reset 2FA for a user?

A.Disable 2FA for the user and allow password-only access.

B.Verify the user's identity through a separate out-of-band channel, then reset.

C.Reset the 2FA immediately upon user request via email.

D.Require the user to visit the IT department in person with a photo ID.

AnswerB

Out-of-band verification prevents unauthorized resets.

Why this answer

Option C is correct because verifying the user's identity through a separate out-of-band channel (e.g., phone call to known number) ensures the requester is legitimate. Option A is wrong because email can be spoofed. Option B is wrong because disabling 2FA reduces security.

Option D is wrong because while in-person verification is secure, it is not always practical; out-of-band is a better balance.

Full explanation →

857

MCQhard

What is the most likely reason PC1 cannot ping PC2?

A.The default gateway is incorrect on PC1

B.A firewall on PC2 is blocking ICMP echo requests

C.PC2's network interface is disabled

D.The switch port for PC2 is faulty

AnswerB

Firewalls often block ping by default while allowing other traffic.

Why this answer

Option C is correct because a firewall on PC2 can be configured to block ICMP echo requests (ping) while allowing other traffic. Option A is incorrect because if PC2's NIC were disabled, PC1 would not be able to communicate with PC2 at all, and the ping would fail, but it's not the most likely scenario given that PC1 can ping PC3 (indicating the switch and network are functioning). Option B is incorrect because a default gateway is only required for off-subnet communication; PC1 and PC2 are on the same subnet.

Option D is incorrect because if the switch port for PC2 were faulty, PC2 would have no network connectivity, and PC1 would fail to reach it for any service, not just ping.

Full explanation →

858

MCQmedium

A small business needs to allow multiple employees to use the same application on their individual computers while ensuring each user has their own settings. Which type of software license is best?

A.Open source

B.Freeware

C.Site license

D.Per-seat license

AnswerD

A per-seat license allows each user to have their own settings and is ideal for this scenario.

Why this answer

Option B is correct because a per-seat license allows installation on multiple computers with per-user tracking. Option A is wrong as it does not cover multiple users. Option C is wrong because it covers an entire site but may not track individual settings.

Option D is wrong because freeware may not support multi-user.

Full explanation →

859

Multi-Selectmedium

Which TWO of the following are examples of multi-factor authentication? (Choose TWO.)

Select 2 answers

A.Password and a security question

B.Username and password

C.Smart card and a PIN

D.Two different passwords

E.Password and a fingerprint scan

AnswersC, E

Smart card (possession) and PIN (knowledge) are two different factors.

Why this answer

MFA requires two or more factors from different categories. A password plus a fingerprint combines knowledge (password) and inherence (fingerprint). A smart card plus a PIN combines possession (card) and knowledge (PIN).

Full explanation →

860

MCQmedium

A user receives an email that appears to be from their bank, asking them to click a link and verify their account details. The user notices the sender's email address is slightly misspelled. Which type of threat is this?

A.Rootkit

B.Phishing

C.Tailgating

D.Ransomware

AnswerB

Correct. The email is a phishing attempt to steal credentials.

Why this answer

Phishing is a social engineering attack where attackers send fraudulent emails to steal sensitive information.

Full explanation →

861

Multi-Selecthard

Which THREE of the following are characteristics of a relational database?

Select 3 answers

A.Schema-less design allows flexible data structures

B.Data is stored in tables with rows and columns

C.Uses Structured Query Language (SQL) for queries

D.Uses a document-based model like JSON

E.Enforces referential integrity through foreign keys

AnswersB, C, E

Tables are the fundamental structure.

Why this answer

A relational database organizes data into tables, where each table consists of rows (records) and columns (attributes). This tabular structure enforces a fixed schema and allows relationships between tables to be defined and queried efficiently. Option B correctly identifies this fundamental characteristic.

Exam trap

The trap here is that candidates confuse the flexible, schema-less nature of NoSQL databases with the rigid, table-based structure of relational databases, leading them to incorrectly select Option A or D.

Full explanation →

862

MCQmedium

A database designer wants to split a table into two to reduce data redundancy and avoid update anomalies. This process is known as:

A.Normalization

B.Denormalization

C.Indexing

D.Partitioning

AnswerA

Normalization splits tables to eliminate redundancy.

Why this answer

Normalization is the process of organizing data to reduce redundancy and improve integrity.

Full explanation →

863

MCQeasy

A small office has 15 computers that need to be connected to share files and a printer. Which type of network is most appropriate for this local setup?

A.WAN

B.LAN

C.PAN

D.MAN

AnswerB

Correct for a local office network.

Why this answer

A LAN connects devices within a limited area like an office.

Full explanation →

864

Multi-Selecteasy

A user wants to retrieve all records from a table named 'Products' where the price is greater than 100. Which TWO SQL statements will work?

Select 2 answers

A.SELECT * FROM Products WHERE Price > 100 GROUP BY Category;

B.SELECT * FROM Products WHERE Price > 100;

C.SELECT ALL FROM Products WHERE Price > 100;

D.SELECT * FROM Products HAVING Price > 100;

E.SELECT * FROM Products WHERE Price > 100 ORDER BY Name;

AnswersB, E

Correct syntax and logic.

Why this answer

Option B is correct because it uses the standard SQL SELECT statement with a WHERE clause to filter records where the Price column is greater than 100, retrieving all columns with the asterisk (*). This is the fundamental and correct syntax for filtering rows in SQL.

Exam trap

The trap here is that candidates confuse WHERE with HAVING, thinking HAVING can replace WHERE for row-level filtering, or they mistakenly add GROUP BY without understanding its purpose for aggregation.

Full explanation →

865

Multi-Selecthard

Which TWO of the following are effective methods to help secure a wireless network from unauthorized access?

Select 2 answers

A.Enabling WPA2 encryption

B.Enabling WEP encryption

C.Disabling the firewall

D.Enabling MAC address filtering

E.Broadcasting the SSID

AnswersA, D

WPA2 provides strong encryption to protect data.

Why this answer

WPA2 (Wi-Fi Protected Access 2) uses AES-based encryption with a pre-shared key (PSK) or 802.1X authentication, providing strong confidentiality and integrity for wireless traffic. It is the minimum recommended standard for securing modern Wi-Fi networks against eavesdropping and unauthorized access.

Exam trap

The trap here is that candidates often think MAC address filtering is a strong security measure, but it is trivially bypassed by spoofing, and WEP is still mistakenly considered acceptable despite being deprecated for over a decade.

Full explanation →

866

MCQhard

A computer has 8 GB of RAM installed, but the operating system reports only 7.9 GB usable. What is the most likely reason for this discrepancy?

A.The operating system itself uses too much RAM

B.Some RAM is reserved for hardware devices

C.The operating system is 32-bit

D.The RAM is not installed in dual-channel mode

AnswerB

Integrated graphics or other hardware may reserve a portion of RAM.

Why this answer

The most likely reason is that some RAM is reserved for hardware devices. This is a standard behavior where system resources, such as memory-mapped I/O (MMIO), are allocated to hardware components like the GPU, network adapters, and PCIe devices. This reservation reduces the total usable RAM reported by the operating system, even though 8 GB is physically installed.

Exam trap

The trap here is that candidates often confuse OS overhead (Option A) with hardware reservation, or they incorrectly assume a 32-bit OS limitation (Option C) when the system clearly reports more than 4 GB of usable RAM.

How to eliminate wrong answers

Option A is wrong because the operating system's own memory usage is reported separately as 'in use' or 'cached' memory, not as a reduction in the total 'usable' amount; the discrepancy here is about hardware reservation, not OS overhead. Option C is wrong because a 32-bit operating system would limit total addressable RAM to 4 GB (or less with PAE), not show 7.9 GB usable; the system is clearly using more than 4 GB, so it must be 64-bit. Option D is wrong because dual-channel mode affects memory bandwidth and performance, not the total amount of RAM reported as usable; the discrepancy is a capacity issue, not a speed or configuration issue.

Full explanation →

867

MCQmedium

A company is setting up a new branch office. The network administrator needs to connect 20 computers and 2 network printers to the local network. The branch also needs a connection to the internet via a cable modem. The administrator has a 24-port switch and a wireless router. The cable modem is already provided by the ISP. Which configuration should the administrator use?

A.Connect the cable modem to the wireless router's WAN port, then connect the switch to one of the router's LAN ports, and connect all devices to the switch

B.Connect the cable modem to the switch, and then connect the wireless router to the switch using its WAN port

C.Connect the cable modem directly to the switch, then connect all devices to the switch

D.Connect the cable modem to one computer, then bridge that computer's network connection to the switch

AnswerA

This allows the router to handle internet sharing and local network management.

Why this answer

Option A is correct because the wireless router must be placed between the cable modem and the switch to perform Network Address Translation (NAT) and routing. The cable modem connects to the router's WAN port, which obtains a public IP from the ISP. The router then provides private IP addresses via DHCP to the switch and all connected devices, enabling internet access for the 20 computers and 2 printers through a single public IP.

Exam trap

The trap here is that candidates often confuse the roles of a switch and a router, assuming a switch can provide internet access to multiple devices directly from a modem, when in fact a router is required for NAT and IP address sharing.

How to eliminate wrong answers

Option B is wrong because connecting the cable modem directly to the switch would bypass the router's NAT and routing functions, meaning the switch would only forward the raw public IP traffic, which cannot be shared among multiple devices without a router. Option C is wrong because a switch operates at Layer 2 and cannot perform NAT or routing; connecting the cable modem directly to the switch would provide internet access to only one device (the one that obtains the public IP via DHCP), leaving the rest without connectivity. Option D is wrong because bridging a computer's connection to the switch creates a single point of failure, requires the computer to be always on, and introduces security and performance issues; it is not a standard or reliable method for a branch office network.

Full explanation →

868

MCQhard

Which security best practice is being demonstrated?

A.Using a public DNS server

B.Using a static IP address

C.Using a private DNS server

D.Using a dynamic IP address

AnswerC

A private DNS server provides internal resolution and can enforce security policies.

Why this answer

Using a private DNS server enhances security by allowing an organization to control DNS resolution internally, preventing external interception or manipulation of DNS queries. This practice helps protect against DNS spoofing and ensures that internal resources are resolved using trusted, local records rather than relying on potentially compromised public DNS servers.

Exam trap

The trap here is that candidates often confuse 'private DNS server' with 'static IP address' or 'dynamic IP address,' mistakenly thinking that IP address assignment methods are security controls, when in fact DNS server choice directly impacts query confidentiality and integrity.

How to eliminate wrong answers

Option A is wrong because using a public DNS server (e.g., Google's 8.8.8.8) exposes DNS queries to external networks, increasing the risk of eavesdropping, cache poisoning, or redirection to malicious sites. Option B is wrong because using a static IP address is a network configuration choice, not a security best practice; it can actually reduce security by making a device's address predictable and easier to target. Option D is wrong because using a dynamic IP address (via DHCP) is primarily for address management and does not inherently provide a security benefit; it may slightly obscure a device's identity but is not a recognized security best practice.

Full explanation →

869

MCQeasy

Which of the following software licenses allows users to modify and redistribute the source code, provided they keep the same license terms?

A.Apache License

B.Commercial License

C.MIT License

D.GNU General Public License (GPL)

AnswerD

GPL ensures that modified versions remain under GPL, protecting open-source nature.

Why this answer

The GNU General Public License (GPL) is a copyleft license that requires derivative works to be distributed under the same license. MIT and Apache are permissive licenses, and commercial licenses restrict modification and redistribution.

Full explanation →

870

Multi-Selecteasy

Which TWO of the following are types of malware? (Select TWO)

Select 2 answers

A.Firewall

B.Ransomware

C.Encryption

D.Phishing

E.Spyware

AnswersB, E

Correct. Ransomware is malware that encrypts files for ransom.

Why this answer

Ransomware and spyware are both types of malware. A firewall is a security tool, encryption is a protection method, and phishing is a social engineering attack.

Full explanation →

871

MCQhard

A user wants to install a 32-bit application on a 64-bit version of Windows 10. The application's installer runs but displays an error message stating that the application requires a 32-bit operating system. Which of the following is the most likely cause?

A.The user needs to run the installer in compatibility mode for 32-bit.

B.The installer is corrupted and needs to be re-downloaded.

C.The application requires drivers that are not available for 64-bit.

D.The application is designed to only run on a 32-bit operating system.

AnswerD

Some legacy applications explicitly check for 32-bit OS and refuse to run on 64-bit.

Why this answer

Option D is correct because the error message explicitly states that the application requires a 32-bit operating system. This indicates that the application's code is written to only run on a 32-bit OS, often due to reliance on 16-bit components or kernel-mode drivers that are not supported in the 64-bit Windows environment. Windows 10 64-bit includes WOW64 (Windows 32-bit on Windows 64-bit) to run most 32-bit applications, but some legacy applications are hard-coded to check for a 32-bit OS and will refuse to run on 64-bit.

Exam trap

The trap here is that candidates may assume all 32-bit applications run on 64-bit Windows via WOW64, but the question specifically tests the understanding that some legacy applications are hard-coded to require a 32-bit OS and will not install regardless of compatibility settings.

How to eliminate wrong answers

Option A is wrong because compatibility mode for 32-bit does not change the underlying 64-bit OS architecture; it only emulates an older Windows version, not a 32-bit CPU/OS. Option B is wrong because a corrupted installer would typically produce CRC errors or incomplete installation messages, not a specific requirement for a 32-bit OS. Option C is wrong because the error message is about the OS bitness, not about missing drivers; driver availability is a separate issue that would manifest as device or functionality failures, not an installer block.

Full explanation →

872

MCQhard

Which SQL statement would you use to retrieve the names of all products with a price greater than $50 from a table named 'Products'?

A.SELECT Name FROM Products WHERE Price > 50

B.SELECT Name FROM Products HAVING Price > 50

C.SELECT * FROM Products IF Price > 50

D.GET Name FROM Products WHERE Price > 50

AnswerA

This correctly retrieves product names with price > 50.

Why this answer

The SELECT statement is used to query data; the WHERE clause filters rows. The correct syntax is SELECT column FROM table WHERE condition.

Full explanation →

873

MCQhard

A company wants to implement a private network for devices within a single building. Which type of network should they use?

A.WAN

B.LAN

C.MAN

D.PAN

AnswerB

LAN is ideal for a single building.

Why this answer

A Local Area Network (LAN) connects devices within a limited area like a building or campus.

Full explanation →

874

MCQmedium

An employee wants to add a new customer record to the 'Customers' table with columns 'ID', 'Name', and 'Email'. Which SQL statement should be used?

A.ADD INTO Customers VALUES (1, 'John', 'john@example.com');

B.INSERT Customers VALUES (1, 'John', 'john@example.com');

C.UPDATE Customers SET Name='John' WHERE ID=1;

D.INSERT INTO Customers VALUES (1, 'John', 'john@example.com');

AnswerD

Correct. This inserts a new row with specified values.

Why this answer

The INSERT statement adds new rows to a table.

Full explanation →

875

Multi-Selectmedium

A system administrator is evaluating antivirus software for company computers. Which TWO features are most important for protecting against malware? (Select TWO.)

Select 2 answers

A.Virtual private network (VPN) support

B.Email spam filtering

C.Real-time scanning

D.Automatic signature updates

E.Built-in firewall

AnswersC, D

Real-time scanning detects threats immediately.

Why this answer

Real-time scanning checks files as they are accessed, preventing malware execution. Automatic updates ensure the antivirus can recognize new threats. Email filtering helps but is not as core.

Firewall is network security, VPN is for privacy.

Full explanation →

876

MCQmedium

A school's computer lab has 25 computers, each running a specific educational software suite. The IT department needs to update the software on all machines to the latest version. The update is a large file, and downloading it separately on each machine would consume too much bandwidth and time. The network has a server that can host the installation files locally. Which of the following is the MOST efficient method to update the software on all computers?

A.Install the update from a single USB flash drive on each computer.

B.Install the software from the original installation media on each computer.

C.Have each computer download the update directly from the internet at different times.

D.Download the update to the server and install it over the network to all computers.

AnswerD

Network deployment allows simultaneous or scheduled installation, saving time and bandwidth.

Why this answer

Option D is correct because it leverages a local server to host the update file, allowing all 25 computers to install the software over the local network. This approach minimizes internet bandwidth usage and speeds up the deployment by using a single download, then distributing the update via a network share or deployment tool (e.g., Group Policy, SCCM, or a simple file copy over SMB). It is the most efficient method for large-scale updates in a LAN environment.

Exam trap

The trap here is that candidates may think Option C (staggered internet downloads) is efficient because it avoids simultaneous bandwidth spikes, but they overlook that a local server eliminates redundant internet downloads entirely, which is the most efficient approach for a LAN with a dedicated server.

How to eliminate wrong answers

Option A is wrong because using a single USB flash drive to install the update on each computer requires manual intervention for every machine, which is time-consuming and inefficient for 25 computers, and does not leverage the network's capabilities. Option B is wrong because installing from the original installation media would not apply the latest update; it would install the old version, requiring additional updates, and is also a manual, slow process. Option C is wrong because having each computer download the update directly from the internet at different times still consumes significant internet bandwidth and time, and does not take advantage of the local server to reduce redundant downloads.

Full explanation →

877

MCQeasy

A user wants to edit a document collaboratively with multiple team members in real-time. Which type of application should they use?

A.Email client

B.Cloud-based office suite

C.Desktop word processor

D.Standalone spreadsheet

AnswerB

Cloud-based office suites allow multiple users to edit documents simultaneously in real-time.

Why this answer

A cloud-based office suite (e.g., Google Workspace, Microsoft 365) stores documents on remote servers and uses synchronization protocols (like WebDAV or proprietary APIs) to allow multiple users to edit the same file simultaneously, with changes reflected in real-time via operational transformation or conflict-free replicated data types (CRDTs). This enables collaborative editing without file locking or version conflicts.

Exam trap

The trap here is that candidates confuse 'collaboration' with 'sharing'—they may choose a desktop word processor because it can share files via email or network drive, but fail to recognize that real-time simultaneous editing requires cloud-based synchronization and conflict resolution, not just file access.

How to eliminate wrong answers

Option A is wrong because an email client is designed for asynchronous message exchange (SMTP/IMAP/POP3) and cannot support real-time collaborative editing of a single document. Option C is wrong because a desktop word processor (e.g., Microsoft Word locally) typically uses file-locking mechanisms and saves to local storage, requiring manual sharing and sequential editing, not real-time collaboration. Option D is wrong because a standalone spreadsheet (e.g., Excel .xlsx file on a local drive) lacks network-based synchronization and multi-user concurrency controls, making real-time co-editing impossible without a cloud backend.

Full explanation →

878

MCQmedium

A user reports that they cannot print to a network printer. Other users can print to the same printer. Which of the following should the technician check FIRST?

A.The printer's IP address

B.The printer driver on the user's computer

C.The network switch port

D.The printer's power cable

AnswerB

A misconfigured or missing driver can prevent printing.

Why this answer

Since other users can print to the same network printer, the printer itself, its network connectivity, and its IP address are all functioning correctly. The issue is isolated to the single user's computer, making the printer driver on that machine the most likely cause. A corrupted, missing, or incorrect driver would prevent that specific user from sending print jobs while others remain unaffected.

Exam trap

The trap here is that candidates often jump to network-level troubleshooting (IP address, switch port) because the issue involves a network printer, but the symptom of 'other users can print' immediately isolates the problem to the local client, making the driver the logical first check.

How to eliminate wrong answers

Option A is wrong because the printer's IP address is already working for other users; checking it first would be redundant and would not resolve a user-specific issue. Option C is wrong because the network switch port is functioning properly, as evidenced by other users successfully printing to the same printer through the same network path. Option D is wrong because the printer's power cable is clearly supplying power (the printer is online and accepting jobs from other users), so checking it would waste time.

Full explanation →

879

MCQeasy

In which phase of the Software Development Life Cycle (SDLC) are the system requirements gathered and analyzed?

A.Implementation

B.Analysis

C.Design

D.Planning

AnswerB

Analysis phase is for requirements gathering and analysis.

Why this answer

The analysis phase focuses on gathering and analyzing requirements to understand what the system must do.

Full explanation →

880

MCQeasy

Which file attribute prevents a file from being modified or deleted accidentally?

A.Archive

B.System

C.Hidden

D.Read-only

AnswerD

Read-only prevents modifications.

Why this answer

The read-only attribute allows viewing but not writing to the file.

Full explanation →

881

MCQeasy

A user inserts a software CD into their computer to install a new application. Which of the following is the most likely next step after the CD is inserted?

A.The user must open a web browser and download additional drivers.

B.The operating system automatically runs the installer or prompts the user.

C.The user must open File Explorer and double-click the setup.exe file.

D.The setup files are automatically copied to the desktop.

AnswerB

AutoPlay or AutoRun typically starts the installer or asks the user what to do.

Why this answer

When a software CD is inserted, modern operating systems like Windows use the AutoPlay feature to detect the disc's content. If the disc contains an autorun.inf file with a valid 'open=' directive, the OS automatically launches the installer or prompts the user with available actions, making B the correct answer.

Exam trap

The trap here is that candidates may think manually double-clicking setup.exe (Option C) is the standard next step, but the exam tests knowledge of AutoPlay as the default automated behavior in modern operating systems.

How to eliminate wrong answers

Option A is wrong because the CD should contain all necessary drivers for the application; downloading additional drivers is not the typical next step and would only be needed if the hardware requires them, which is unrelated to inserting a software CD. Option C is wrong because while manually browsing to setup.exe is possible, it is not the 'most likely' next step; AutoPlay typically handles this automatically unless disabled. Option D is wrong because setup files are not automatically copied to the desktop; the installer may copy files to the system during installation, but the desktop is not the default destination for setup files.

Full explanation →

882

Multi-Selecteasy

Which TWO of the following are examples of system software?

Select 2 answers

A.Word processor

B.Web browser

C.Device driver

D.Operating system

E.Photo editor

AnswersC, D

Device drivers are system software that communicate with hardware.

Why this answer

Device drivers are system software because they provide a low-level interface between the operating system and hardware components, translating generic OS commands into device-specific instructions. The operating system itself is the core system software that manages hardware resources, runs applications, and provides essential services. Both are fundamental to the computer's operation, not end-user productivity tasks.

Exam trap

CompTIA often tests the distinction between system software (which manages hardware and provides a platform) and application software (which performs specific user tasks), trapping candidates who confuse utility software or firmware with system software.

Full explanation →

883

MCQhard

A technician is troubleshooting a network where users in one department cannot reach a web server in another subnet. The technician confirms the server is running and the switch ports are up. Which of the following should be checked NEXT?

A.DHCP server scope

B.Firewall rules on the server

C.DNS server settings

D.Router configuration

AnswerD

The router routes between subnets; misconfiguration can block traffic.

Why this answer

Since the server is running and switch ports are up, the issue is likely at Layer 3 (network layer). The router is responsible for forwarding traffic between subnets, so a misconfigured router (e.g., missing static route, incorrect ACL, or routing protocol issue) would prevent inter-subnet communication. Checking the router configuration is the logical next step to verify that routing is properly set up for the destination subnet.

Exam trap

The trap here is that candidates often jump to DNS or firewall issues first, but the scenario explicitly describes a subnet-to-subnet reachability problem, which directly points to Layer 3 routing as the root cause.

How to eliminate wrong answers

Option A is wrong because the DHCP server scope only affects IP address assignment within a subnet; if users already have IP addresses and can reach other resources, DHCP is not the cause of a specific inter-subnet failure. Option B is wrong because firewall rules on the server would block all traffic to the server, but the technician already confirmed the server is running and reachable from its own subnet; the issue is routing between subnets, not server-level filtering. Option C is wrong because DNS server settings affect name resolution, not IP-level connectivity; if the users can ping the web server's IP address but not its hostname, DNS would be suspect, but the problem states they cannot reach the server at all, indicating a routing issue.

Full explanation →

884

MCQhard

A database administrator needs to remove all rows from the 'Log' table but keep the table structure for future use. The administrator also wants the operation to be irreversible (cannot be rolled back). Which SQL statement should be used?

A.DELETE FROM Log;

B.ALTER TABLE Log REMOVE ROWS;

C.TRUNCATE TABLE Log;

D.DROP TABLE Log;

AnswerC

TRUNCATE is DDL, removes all rows, and typically cannot be rolled back.

Why this answer

TRUNCATE TABLE Log; is correct because it removes all rows from the table while preserving the table structure (columns, constraints, indexes) for future use. Unlike DELETE, TRUNCATE is a DDL operation that does not generate individual row deletion logs, making it irreversible and cannot be rolled back in most database systems.

Exam trap

The trap here is that candidates often confuse TRUNCATE with DELETE, thinking both are reversible, or they mistakenly believe DROP TABLE preserves the structure, when in fact TRUNCATE is the only option that removes all rows irreversibly while keeping the table schema intact.

How to eliminate wrong answers

Option A is wrong because DELETE FROM Log; is a DML operation that removes rows one by one, logging each deletion, and can be rolled back within a transaction, so it is not irreversible. Option B is wrong because ALTER TABLE Log REMOVE ROWS; is not a valid SQL statement; ALTER TABLE is used to modify table structure (e.g., add/drop columns), not to remove rows. Option D is wrong because DROP TABLE Log; removes the entire table structure along with all data, which does not preserve the table for future use.

Full explanation →

885

Multi-Selectmedium

A project team is using Git for version control. Which TWO actions are typical Git operations? (Choose TWO.)

Select 2 answers

A.Compile

B.Increase

C.Branch

D.Commit

E.Push

AnswersD, E

Commit records changes to the local repository.

Why this answer

Commit saves changes to the local repository, and push uploads changes to a remote repository. Increase is not a Git command, and compile is not related to version control.

Full explanation →

886

MCQmedium

A database administrator needs to retrieve all customer names from a table named 'Customers' where the city is 'New York'. Which SQL statement should be used?

A.UPDATE Customers SET Name = 'New York' WHERE City = 'New York'

B.SELECT Name FROM Customers WHERE City = 'New York'

C.INSERT INTO Customers (Name) VALUES ('New York')

D.DELETE FROM Customers WHERE City = 'New York'

AnswerB

Correct. This query retrieves the Name column for rows where City is 'New York'.

Why this answer

The SELECT statement is used to query data. The correct syntax is SELECT column FROM table WHERE condition. Here, we need the Name column from Customers where City equals 'New York'.

Full explanation →

887

MCQmedium

A company wants to implement a backup solution that allows for quick restoration of individual files. Which backup type should be used?

A.System image backup

B.Differential backup

C.Full backup

D.Incremental backup

AnswerC

Full backup contains all files and allows individual file restoration.

Why this answer

A full backup creates a complete copy of all selected data, allowing any individual file to be restored directly from that single backup set without needing to process other backup sets. This makes it the simplest and fastest option for restoring specific files, as no additional dependencies or chain reconstructions are required.

Exam trap

The trap here is that candidates often choose differential or incremental backups because they are faster to create, but the question specifically asks for quick restoration of individual files, which is best achieved with a full backup due to its independence and simplicity.

How to eliminate wrong answers

Option A is wrong because a system image backup captures the entire operating system, boot files, and system state, which is designed for bare-metal recovery of the whole machine rather than quick restoration of individual files. Option B is wrong because a differential backup only stores changes made since the last full backup, so restoring a single file requires both the last full backup and the latest differential backup, adding complexity and time. Option D is wrong because an incremental backup stores only changes since the last backup (full or incremental), creating a chain of dependent backup sets that must be fully processed in order to restore a single file, which is slower and more error-prone for individual file recovery.

Full explanation →

888

MCQmedium

A company wants to ensure data redundancy in case of a single hard drive failure. Which RAID level should they use?

A.RAID 0

B.RAID 5

C.JBOD

D.RAID 1

AnswerD

RAID 1 mirrors data across two drives, providing fault tolerance for a single drive failure.

Why this answer

RAID 1 (mirroring) writes identical data to two or more drives simultaneously, providing full data redundancy. If one drive fails, the system continues to operate using the mirrored copy, ensuring no data loss and minimal downtime. This makes RAID 1 the correct choice for protecting against a single hard drive failure.

Exam trap

The trap here is that candidates often confuse RAID 5 as the 'standard' redundancy option due to its efficiency, but the question specifically asks for redundancy in case of a single drive failure with no mention of capacity optimization, making RAID 1 the simplest and most direct answer.

How to eliminate wrong answers

Option A (RAID 0) is wrong because it stripes data across drives without any parity or mirroring, offering no fault tolerance; a single drive failure results in complete data loss. Option B (RAID 5) is wrong because while it provides redundancy through distributed parity and can survive a single drive failure, it requires a minimum of three drives and uses parity calculations, making it more complex and slower for write operations than the simple mirroring of RAID 1. Option C (JBOD) is wrong because it simply concatenates disks into a single logical volume without any redundancy; failure of one drive causes loss of only that drive's data, but the array may still be partially functional, not providing the guaranteed redundancy the question asks for.

Full explanation →

889

MCQhard

An IT department is planning a new server deployment. They need to ensure that if one server fails, another can take over with minimal downtime. Which concept describes this requirement?

A.Disaster recovery

B.Scalability

C.High availability

D.Fault tolerance

AnswerD

Fault tolerance ensures continued operation despite failures, often through redundant components.

Why this answer

The requirement describes a system where a secondary server automatically takes over with minimal downtime upon failure of the primary server. This is the definition of fault tolerance, which uses redundant components (e.g., dual power supplies, RAID, or clustered servers) to ensure continuous operation without interruption. High availability (option C) is related but focuses on maximizing uptime through redundancy and failover, whereas fault tolerance specifically aims for zero or near-zero downtime by masking failures completely.

Exam trap

The trap here is that candidates confuse high availability with fault tolerance, but high availability typically allows for a short failover delay (seconds to minutes), while fault tolerance requires zero downtime by having redundant components operating in parallel, as implied by 'another can take over with minimal downtime.'

How to eliminate wrong answers

Option A is wrong because disaster recovery refers to restoring IT infrastructure and data after a catastrophic event (e.g., natural disaster, cyberattack) using backups and off-site recovery sites, not real-time failover with minimal downtime. Option B is wrong because scalability is the ability to handle increased load by adding resources (e.g., more servers or storage), not the ability to recover from a server failure with minimal downtime. Option C is wrong because high availability (HA) is a broader concept that uses redundancy and failover to achieve uptime (e.g., 99.999%), but it typically involves some downtime during failover (e.g., seconds to minutes), whereas the question specifies 'minimal downtime' and 'another can take over'—this aligns more precisely with fault tolerance, which aims for zero downtime by having redundant systems running in parallel (e.g., active-active clustering).

Full explanation →

890

MCQeasy

A small independent bookstore has been operating for several years using a single Microsoft Excel spreadsheet to manage its inventory, sales, and customer data. The spreadsheet contains over 10,000 rows and is shared among five employees. Recently, employees have noticed recurring data quality issues: the same book appears multiple times in the inventory list with different prices, some sales records reference book titles that do not exist in the inventory, and customer contact information is duplicated across rows. Because there are no constraints, employees can enter any value into any cell. The owner wants to implement a more robust system to eliminate data redundancy and ensure data integrity. The bookstore has a budget for new software and some technical support. The owner is not very technical but is willing to hire a consultant. Which action should be taken to best address these problems?

A.Use a single flat file for all data to simplify data entry

B.Implement a NoSQL database for flexibility

C.Migrate to a relational database with normalized tables and foreign key constraints

D.Continue using the spreadsheet but add data validation rules to restrict input

AnswerC

Normalization reduces redundancy, and foreign keys enforce referential integrity.

Why this answer

Option C is correct because migrating to a relational database with normalized tables and foreign key constraints directly addresses the data redundancy and integrity issues. Normalization splits data into separate tables (e.g., Books, Sales, Customers) to eliminate duplicate entries, while foreign key constraints ensure that every sales record references a valid book and that customer data is stored once. This approach enforces referential integrity and prevents the anomalies seen in the flat spreadsheet.

Exam trap

The trap here is that candidates often choose data validation (Option D) thinking it can enforce integrity, but they overlook that spreadsheets lack relational constraints and cannot prevent duplicate rows or cross-table inconsistencies across multiple users.

How to eliminate wrong answers

Option A is wrong because using a single flat file for all data would perpetuate the same redundancy and integrity problems—it offers no mechanism to enforce unique entries or relationships between data. Option B is wrong because a NoSQL database, while flexible, typically lacks built-in support for ACID transactions and foreign key constraints, making it less suitable for enforcing strict referential integrity in a small bookstore scenario with structured relational data. Option D is wrong because adding data validation rules to a spreadsheet cannot prevent duplicate rows or enforce cross-table relationships; spreadsheets lack the relational integrity features needed to eliminate redundancy and ensure consistency across 10,000+ rows shared by multiple users.

Full explanation →

891

MCQmedium

A technician is explaining the difference between lossy and lossless compression to a colleague. Which of the following file formats uses lossy compression?

A.GIF

B.PNG

C.JPEG

D.ZIP

AnswerC

JPEG uses lossy compression for images.

Why this answer

JPEG uses lossy compression, discarding some image data to reduce file size. ZIP, PNG, and GIF use lossless compression.

Full explanation →

892

MCQhard

A medium-sized company uses a customer relationship management (CRM) application that is accessed by 50 employees. The application is installed on a local server and uses a shared database. Recently, employees have reported that the application is becoming slow and sometimes times out. The IT staff has verified that there is no network congestion and the server has adequate resources. The application logs show that the database file has grown significantly over the past year. Which of the following is the MOST likely cause of the performance issue and the BEST solution?

A.The application needs to be reinstalled; reinstall it on the server.

B.The database is too large; archive old records to improve performance.

C.The server needs more RAM; add additional memory.

D.The network is the bottleneck; upgrade to a faster network switch.

AnswerB

Archiving reduces database size, speeding up queries.

Why this answer

The database file has grown significantly over the past year, which directly increases the time required for queries, indexing, and data retrieval. Archiving old records reduces the database size, improves query performance, and resolves timeouts without requiring hardware changes. This is a common database maintenance task for CRM systems that accumulate historical data.

Exam trap

The trap here is that candidates may assume performance issues are always hardware-related (RAM or network) and overlook the impact of database growth, even when resource utilization appears normal.

How to eliminate wrong answers

Option A is wrong because reinstalling the application does not address the root cause of database bloat; it would only reset application files without reducing the database size or improving query performance. Option C is wrong because the IT staff has already verified that the server has adequate resources, including RAM, so adding more memory would not solve a performance issue caused by an oversized database. Option D is wrong because the IT staff has confirmed there is no network congestion, so upgrading the network switch would not address the database size problem.

Full explanation →

893

Multi-Selectmedium

A user wants to protect their laptop in case it is stolen. Which THREE of the following measures would help protect the confidentiality of the data?

Select 2 answers

A.A strong password set in the BIOS

B.Full disk encryption

C.Using a VPN when connected to public Wi-Fi

D.Using a strong password for the user account

E.Enabling the screen lock with a password

AnswersB, D

Encryption renders data unreadable without the key.

Why this answer

Confidentiality measures prevent unauthorized access to data.

Full explanation →

894

MCQeasy

Which of the following is the correct file extension for a macOS installer package?

A..msi

B..pkg

C..exe

D..dmg

AnswerB

.pkg is an installer package on macOS.

Why this answer

.pkg is the standard macOS installer package format.

Full explanation →

895

MCQmedium

A company wants to deploy a new wireless network in its office. The network must support high device density and minimize interference from neighboring networks. Which Wi-Fi standard and frequency band combination is most suitable?

A.802.11n on 5GHz

B.802.11ax on 2.4GHz

C.802.11ax on 5GHz

D.802.11ac on 2.4GHz

AnswerC

Wi-Fi 6 on 5GHz is optimal for dense areas.

Why this answer

802.11ax (Wi-Fi 6) on 5GHz provides faster speeds, better efficiency in dense environments, and less interference than 2.4GHz.

Full explanation →

896

MCQeasy

A user wants to upgrade their desktop computer to faster storage. Which of the following storage interfaces provides the highest data transfer speeds?

A.NVMe M.2

B.USB 2.0 flash drive

C.SATA SSD

D.External HDD

AnswerA

NVMe M.2 drives can reach speeds over 3000 MB/s, much faster than SATA.

Why this answer

NVMe M.2 uses the PCIe bus and is significantly faster than SATA-based SSDs.

Full explanation →

897

MCQeasy

You are a support technician for a small company. An employee reports that their desktop computer will not turn on. You have verified that the power cable is securely connected to both the computer and the wall outlet. When you press the power button, you hear a faint clicking sound but the computer does not start. The power supply fan does not spin, and there are no lights on the motherboard. You have tested the wall outlet with a known working device and it provides power. What is the most likely cause of the issue?

A.The CPU is overheated.

B.The power button is not connected properly.

C.The power supply is faulty.

D.The motherboard has failed.

AnswerC

The clicking sound and no fan spin indicate a PSU issue.

Why this answer

The correct answer is C because the symptoms—faint clicking sound, no fan spin, no motherboard lights, and confirmed wall outlet power—strongly indicate a power supply failure. The clicking sound often comes from a relay or overload protection circuit inside the PSU attempting to start but failing due to internal component damage or short circuit. A faulty power supply cannot deliver the necessary voltages (e.g., +3.3V, +5V, +12V) to power the system, explaining the complete lack of activity.

Exam trap

The trap here is that candidates often confuse a clicking sound with a mechanical hard drive issue or a stuck fan, but in a no-power scenario, the clicking is a classic sign of a power supply's protection circuit cycling, not a component failure elsewhere.

How to eliminate wrong answers

Option A is wrong because an overheated CPU would typically cause the system to shut down or throttle after running, not prevent it from powering on at all; the CPU is not involved in the initial power-on sequence until the power supply delivers standby power. Option B is wrong because if the power button were not connected properly, pressing it would produce no electrical signal, so you would not hear any clicking sound from the PSU; the clicking indicates the PSU is receiving the power-on signal but failing. Option D is wrong because a failed motherboard could prevent boot, but the absence of any motherboard lights and the specific clicking sound from the PSU point to a primary power delivery issue rather than a motherboard fault; a motherboard failure would still typically show some standby power indicator if the PSU were functional.

Full explanation →

898

MCQmedium

A technician is deploying a software update to 200 computers in a domain. To avoid user interaction, which installation method should be used?

A.Silent installation

B.App store installation

C.Interactive installation

D.Manual installation

AnswerA

Silent installation runs without prompts, suitable for automated deployment.

Why this answer

Silent installation runs without requiring user input, ideal for automated deployments. Interactive installers require user clicks, and app stores usually involve user interaction.

Full explanation →

899

Matchingmedium

Match each database concept to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts

Matches

Uniquely identifies each record

Links two tables together

Speeds up data retrieval

Requests data from a database

Why these pairings

These are fundamental database concepts.

Full explanation →

900

MCQmedium

A network administrator is setting up a small office network for a new startup. The office has five computers, two printers, and one server. The administrator wants to ensure that all devices can communicate with each other and access the internet. The administrator has decided to use a switch and a router. Which of the following configurations is the MOST appropriate?

A.Connect all devices to the switch, then connect the switch to the router

B.Connect the server and printers to the switch, computers to the router

C.Use a hub instead of a switch

D.Connect all devices directly to the router

AnswerA

This allows all devices to communicate locally and access the internet via the router.

Why this answer

A switch creates a local area network (LAN) by forwarding frames based on MAC addresses, allowing all five computers, two printers, and one server to communicate directly. The router provides network address translation (NAT) and a default gateway for internet access, so connecting the switch to the router enables all devices on the switch to reach the internet. This is the standard small office topology because the switch handles internal traffic efficiently at Layer 2, while the router handles Layer 3 routing and internet connectivity.

Exam trap

The trap here is that candidates assume a router can handle all device connections directly, ignoring the practical port count limitation and the fact that a switch is required to scale the LAN beyond the router's built-in ports.

How to eliminate wrong answers

Option B is wrong because connecting computers directly to the router would likely exceed the limited number of LAN ports on a typical consumer or SOHO router (usually 4), and it would force all computer traffic through the router's slower switching fabric, creating a bottleneck and wasting the switch's high-speed backplane. Option C is wrong because a hub operates at Layer 1, repeating all traffic to every port, which causes collisions, halves effective bandwidth, and is unsuitable for a modern network with five computers, printers, and a server; switches are the correct choice for dedicated bandwidth and collision domains. Option D is wrong because most routers have only 4 LAN ports, insufficient for seven devices (five computers, two printers, and one server), and connecting all devices directly to the router would bypass the switch's ability to handle local traffic efficiently, overloading the router's CPU with Layer 2 forwarding.

Full explanation →

Page 12 of 14

All pages

1 2 3 4 5 6 7 8 9 10 11 12 13 14

Practice FC0-U61 by domain

Target a specific domain to shore up weak areas.

IT Concepts and Terminology Infrastructure Applications and Software Software Development Database Fundamentals Security Software Development Concepts

See all domains with question counts →