Courseiva

CompTIA Tech+ (FC0-U71) (FC0-U71) — Questions 226–300

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

Take a mock examExam hub
Page 3

Page 4 of 14

Page 5
226
MCQhard

An IT administrator needs to deploy a new application to 50 company-owned smartphones. The devices are managed by a central console that can enforce policies, install apps, and wipe data remotely. Which technology is being used?

A.Mobile Device Management (MDM)
B.Google Account Sync
C.Synchronisation
D.iCloud
AnswerA

MDM provides central management for mobile devices.

Why this answer

Mobile Device Management (MDM) is a solution that allows administrators to manage, secure, and enforce policies on mobile devices from a central console.

Full explanation →
227
Multi-Selectmedium

Which TWO of the following are examples of system software?

Select 2 answers
A.Device drivers
B.Database management system
C.Operating system
D.Spreadsheet
E.Web browser
AnswersA, C

Drivers are system software that enable communication 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. Without device drivers, the OS cannot communicate with hardware like graphics cards, network adapters, or storage controllers.

Exam trap

CompTIA often tests the distinction between system software and application software, and the trap here is that candidates mistakenly classify database management systems or web browsers as system software because they are essential for many tasks, but they are actually application software that runs on top of the OS.

Full explanation →
228
MCQeasy

A company wants to prevent unauthorized physical access to its server room. Which control is best?

A.Firewall
B.Antivirus
C.Biometric lock
D.Encryption
AnswerC

Biometrics verify identity based on physical characteristics, restricting entry to authorized personnel.

Why this answer

A biometric lock is the best control for preventing unauthorized physical access to a server room because it authenticates individuals based on unique physiological traits (e.g., fingerprint, iris scan), directly securing the physical entry point. Unlike logical or data-level controls, it addresses the physical security domain by restricting who can enter the room, not what data they can access.

Exam trap

The trap here is that candidates confuse logical security controls (firewall, antivirus, encryption) with physical security controls, incorrectly assuming any security technology can prevent physical access, when only a physical access control mechanism like a biometric lock directly addresses the scenario.

How to eliminate wrong answers

Option A is wrong because a firewall is a network security device that filters traffic based on rules (e.g., ACLs, stateful inspection), and it does not prevent physical entry to a room. Option B is wrong because antivirus software detects and removes malware on endpoints, but it has no mechanism to control physical access to a location. Option D is wrong because encryption protects data at rest or in transit by converting it into ciphertext (e.g., AES-256), but it does not prevent someone from physically walking into a server room.

Full explanation →
229
MCQmedium

Refer to the exhibit. A user runs the "where python" command and sees two paths. What does this indicate?

A.Python is not installed
B.The user has two versions of Python installed
C.The PATH variable contains two entries for Python
D.Python is installed in two locations
AnswerC

The output shows two paths, meaning both are listed in the PATH.

Why this answer

The 'where python' command on Windows displays all locations in the system's PATH environment variable that contain an executable named 'python'. When two paths are shown, it indicates that the PATH variable has two separate directory entries, each pointing to a different location where a 'python.exe' (or 'python') file is found. This does not necessarily mean two different versions are installed; it simply means the PATH contains multiple entries that resolve to a Python executable.

Exam trap

The trap here is that candidates often assume two paths automatically mean two different versions (Option B), but the FC0-U61 exam tests the understanding that the 'where' command reflects PATH entries, not version differences.

How to eliminate wrong answers

Option A is wrong because if Python were not installed, the 'where python' command would return a message like 'INFO: Could not find files for the given pattern(s)', not two paths. Option B is wrong because while two versions could be installed, the 'where python' command only shows paths in the PATH variable; having two paths does not confirm different versions—they could be the same version in two directories, or one could be a duplicate. Option D is wrong because the command shows paths where Python executables are found, but Python itself is installed only once (or in one primary location); the second path might be a copy, a symlink, or a different executable, not necessarily a separate installation.

Full explanation →
230
MCQeasy

Refer to the exhibit. The following SQL statement is executed. The result message is: '0 rows affected'. What is the most likely reason?

A.The table 'Employees' does not exist
B.The UPDATE privilege has been revoked
C.The table 'Employees' is empty
D.The statement lacks a WHERE clause
AnswerC

No rows to update.

Why this answer

The SQL statement executed successfully (no syntax error) but affected zero rows because the target table 'Employees' is empty. An UPDATE statement modifies existing rows; if no rows exist, zero rows are affected regardless of the SET or WHERE clause. The message '0 rows affected' indicates the statement parsed and executed without error, but no data matched the condition (or there was no data to update).

Exam trap

CompTIA often tests the distinction between a successful but zero-row operation and an error condition, trapping candidates who assume '0 rows affected' implies a missing WHERE clause or a nonexistent table.

How to eliminate wrong answers

Option A is wrong because if the table 'Employees' did not exist, the database would return an error like 'Table does not exist' or 'Invalid object name', not a success message with '0 rows affected'. Option B is wrong because if the UPDATE privilege had been revoked, the database would return a permission denied error, not a successful execution message. Option D is wrong because an UPDATE statement without a WHERE clause updates all rows in the table; if the table were not empty, it would affect all rows, not zero.

The absence of a WHERE clause does not cause zero rows affected unless the table itself is empty.

Full explanation →
231
MCQmedium

Refer to the exhibit. A user reports that they cannot access the internet. Based on the output, which of the following is the MOST likely issue?

A.The router at 192.168.1.1 is down
B.The subnet mask is incorrect
C.The IP address is invalid
D.The DNS suffix is missing
AnswerA

Default gateway unreachable would cause no internet.

Why this answer

The default gateway 192.168.1.1 is unreachable, as shown by the 100% packet loss in the ping output. Without a functional gateway, traffic cannot be routed from the local subnet to external networks, so internet access fails even if the local IP configuration is valid.

Exam trap

The FC0-U61 exam often tests the distinction between local connectivity (IP/subnet valid) and gateway reachability; the trap here is that candidates see a valid IP and subnet and assume the problem is DNS-related, ignoring the failed ping to the default gateway.

How to eliminate wrong answers

Option B is wrong because the subnet mask 255.255.255.0 is standard for a /24 network and matches the IP address 192.168.1.100, so it is not incorrect. Option C is wrong because 192.168.1.100 is a valid private IP address within the 192.168.1.0/24 range and is not invalid. Option D is wrong because a missing DNS suffix would prevent name resolution but would not block internet access if the user uses an IP address; the ping to the gateway fails, indicating a connectivity issue, not a DNS problem.

Full explanation →
232
MCQeasy

A user wants to connect a laptop to a corporate wireless network. What internal component must be present in the laptop?

A.Wireless NIC
B.Cellular modem
C.Infrared port
D.Bluetooth adapter
AnswerA

A wireless NIC enables the laptop to connect to Wi-Fi networks.

Why this answer

A Wireless NIC (Network Interface Card) is the internal component required for a laptop to connect to a corporate wireless network. It contains a radio transceiver that communicates with wireless access points using IEEE 802.11 standards (e.g., 802.11ax), handling frame encapsulation, authentication, and encryption such as WPA3. Without a wireless NIC, the laptop has no physical layer capability to transmit or receive Wi-Fi signals.

Exam trap

The trap here is that candidates confuse Bluetooth and Wi-Fi because both use 2.4 GHz radio frequencies, but Bluetooth is designed for short-range device pairing (e.g., keyboards, mice) and cannot authenticate to a corporate wireless network using 802.1X or WPA3-Enterprise.

How to eliminate wrong answers

Option B (Cellular modem) is wrong because it connects to mobile networks (e.g., 4G LTE, 5G NR) using cellular protocols, not to corporate Wi-Fi infrastructure which relies on IEEE 802.11 standards. Option C (Infrared port) is wrong because it uses IrDA (Infrared Data Association) for short-range, line-of-sight communication at speeds up to 4 Mbps, and cannot connect to standard wireless networks. Option D (Bluetooth adapter) is wrong because it operates on the 2.4 GHz ISM band using Bluetooth protocols (e.g., BR/EDR or BLE) for personal area networking, not for connecting to corporate wireless LANs which require 802.11-compliant hardware.

Full explanation →
233
MCQhard

An IT technician is setting up a virtualized server environment. The server will host multiple virtual machines for different departments. Which type of hypervisor should the technician install directly on the server hardware to maximize performance and resource efficiency?

A.Containerization platform
B.Dual-boot configuration
C.Type 1 hypervisor
D.Type 2 hypervisor
AnswerC

Type 1 is bare-metal, ideal for server virtualization.

Why this answer

A Type 1 hypervisor runs directly on the hardware without an underlying OS, providing better performance and resource allocation for VMs.

Full explanation →
234
MCQeasy

Refer to the exhibit. Which of the following components would be used to physically connect the desktop computer to the network?

A.Laptop
B.Network printer
C.Switch
D.Router
AnswerC

Switch connects wired devices in a LAN.

Why this answer

A switch is the correct component because it operates at Layer 2 of the OSI model, using MAC addresses to forward frames between devices on the same local area network (LAN). The desktop computer's Ethernet NIC connects via a twisted-pair cable to a switch port, which provides the physical and data-link layer connectivity required for network communication.

Exam trap

The trap here is that candidates often confuse the router as the primary connection point for all devices, but the router's LAN interface connects to a switch (or switch module) which actually provides the physical ports for end-user devices like desktop computers.

How to eliminate wrong answers

Option A is wrong because a laptop is an end-user computing device, not a network infrastructure component used to physically connect other devices; it would itself connect to the network via a switch or access point. Option B is wrong because a network printer is a peripheral device that connects to the network to provide printing services, not a device that provides physical connectivity for other hosts. Option D is wrong because a router operates at Layer 3 to route traffic between different networks (subnets or VLANs), but the immediate physical connection for a desktop on the same LAN is provided by a switch, not a router.

Full explanation →
235
MCQmedium

A programmer writes code to run a block of instructions repeatedly until a condition is met. Which programming concept is being used?

A.Conditional
B.Loop
C.Function
D.Variable
AnswerB

Loops repeat code until a condition is met.

Why this answer

A loop (for, while) repeats code. Functions are reusable blocks, conditionals make decisions, variables store data.

Full explanation →
236
MCQmedium

A company stores sensitive data and wants to ensure that if a hard drive is stolen, the data cannot be read. Which security measure should be implemented?

A.RAID 1
B.Full disk encryption
C.Antivirus software
D.Strong passwords
AnswerB

Encryption scrambles data so it cannot be read without the key.

Why this answer

Full disk encryption (FDE) encrypts the entire contents of a hard drive, including the operating system, applications, and all data, using algorithms such as AES-256. If the drive is stolen, the data remains unreadable without the decryption key or passphrase, even if the drive is physically removed and attached to another system. This directly addresses the requirement of protecting data at rest on a stolen drive.

Exam trap

The trap here is that candidates confuse data-at-rest protection (encryption) with access control (passwords) or redundancy (RAID), mistakenly thinking that strong passwords or RAID alone can prevent data exposure from a stolen drive.

How to eliminate wrong answers

Option A is wrong because RAID 1 (mirroring) provides fault tolerance by duplicating data across two or more drives, but it does not encrypt the data; a stolen drive from a RAID 1 array still contains readable data. Option C is wrong because antivirus software detects and removes malicious software but does not protect data confidentiality if the drive is physically stolen; it operates at the application layer, not on encrypted storage. Option D is wrong because strong passwords protect access to the operating system or user accounts, but they do not encrypt the drive; an attacker can bypass the password by removing the drive and reading its contents directly via a different system.

Full explanation →
237
Multi-Selectmedium

An online store uses a relational database with tables: Customers, Orders, and Products. Which of the following are valid ways to query the database structure? (Select THREE.)

Select 3 answers
A.DESCRIBE Customers
B.SELECT * FROM Customers
C.INSERT INTO Customers VALUES (...)
D.SHOW TABLES
E.SELECT * FROM information_schema.tables WHERE table_schema = 'store'
AnswersA, D, E

Correct; shows columns of the Customers table.

Why this answer

SELECT retrieves data, SHOW TABLES lists tables in MySQL, and DESCRIBE shows column info. INSERT adds data, not structure.

Full explanation →
238
MCQhard

An IT administrator needs to deploy a virtual machine (VM) on a server that will host multiple operating systems. The administrator wants the VM to have dedicated resources and minimal overhead. Which type of hypervisor should be installed on the server?

A.Container engine
B.Hosted hypervisor
C.Type 2 hypervisor
D.Type 1 hypervisor
AnswerD

Type 1 runs on bare metal for efficiency.

Why this answer

Type 1 hypervisor runs directly on hardware, providing better performance and resource allocation.

Full explanation →
239
Multi-Selecteasy

Which TWO of the following are core phases of the Software Development Life Cycle (SDLC)?

Select 2 answers
A.Algorithm design
B.Flowcharting
C.Testing
D.Debugging
E.Implementation
AnswersC, E

Testing is a key SDLC phase.

Why this answer

The SDLC includes phases like planning, analysis, design, implementation, testing, deployment, and maintenance. A flowchart is not an SDLC phase, and debugging is an activity within testing/implementation.

Full explanation →
240
MCQhard

A company stores product data in a MongoDB database. Each product document contains fields like 'name', 'price', and 'tags' (an array). What type of NoSQL database is MongoDB?

A.Document store
B.Wide-column store
C.Graph database
D.Key-value store
AnswerA

MongoDB stores documents (JSON-like objects) with flexible schemas.

Why this answer

MongoDB is a document-oriented NoSQL database that stores data in JSON-like documents.

Full explanation →
241
MCQhard

An organization uses a security model where users are granted the minimum permissions necessary to perform their job functions. This model is known as:

A.Role-based access control
B.Principle of least privilege
C.Mandatory access control
D.Discretionary access control
AnswerB

This is the definition of least privilege.

Why this answer

The principle of least privilege ensures users have only the access they need, reducing risk of misuse.

Full explanation →
242
MCQmedium

Which network topology connects all devices to a single central cable?

A.Mesh
B.Ring
C.Bus
D.Star
AnswerC

Bus uses a single cable to connect all nodes.

Why this answer

In a bus topology, all devices are connected to a single backbone cable. However, star topology is more common today.

Full explanation →
243
MCQeasy

A small business with 50 employees currently hosts its email and file-sharing server on-premises on a single physical server. The server is experiencing frequent hardware failures, causing downtime and data loss. The owner wants a solution that improves reliability, scalability, and reduces the need for in-house maintenance. The company has a limited IT budget and wants to avoid large upfront hardware costs. The owner is concerned about data security and compliance but is open to cloud solutions. As an IT consultant, which of the following would be the best recommendation?

A.Implement a regular backup strategy
B.Migrate to a public cloud IaaS solution
C.Purchase a more powerful on-premises server
D.Move to a peer-to-peer network
AnswerB

IaaS offers scalable, reliable infrastructure with pay-as-you-go pricing, reducing the need for in-house hardware maintenance.

Why this answer

(Migrate to a public cloud IaaS solution) is correct because it provides scalability, high availability, and reduces maintenance overhead without large upfront costs. Cloud providers offer robust security and compliance features, addressing the owner's concerns. Option A (regular backup) is incorrect because backup alone does not prevent downtime; it only enables recovery after a failure.

Option C (more powerful server) is incorrect because it still relies on a single physical server and does not eliminate hardware failure risk. Option D (peer-to-peer network) is incorrect because it lacks centralized management and reliability, making it unsuitable for a 50-user business.

Full explanation →
244
Multi-Selecteasy

Which TWO of the following are best practices for creating and managing passwords?

Select 2 answers
A.Share passwords with colleagues in the same department to improve collaboration
B.Reuse passwords every 90 days
C.Enable multi-factor authentication where available
D.Use a unique password for each online account
E.Write down passwords on a sticky note and keep it near the computer
AnswersC, D

MFA provides an additional security layer.

Why this answer

Options C and D are correct. Enabling multi-factor authentication adds an extra layer of security beyond just a password, making it much harder for attackers to gain access. Using a unique password for each online account prevents a single breach from compromising multiple accounts.

Option A is wrong because sharing passwords undermines accountability and security. Option B is wrong because reusing passwords, even if changed every 90 days, is still poor practice; the best practice is to use unique passwords and not reuse them. Option E is wrong because writing down passwords near the computer exposes them to theft.

Full explanation →
245
Multi-Selectmedium

Which THREE of the following are common phases in the software development life cycle (SDLC)?

Select 3 answers
A.Requirements gathering
B.Release
C.Coding
D.Design
E.Testing
AnswersA, D, E

Requirements gathering is a key phase in SDLC.

Why this answer

Requirements gathering is the foundational phase in the SDLC where stakeholders and developers define what the software must accomplish. This phase produces a Software Requirements Specification (SRS) document that guides all subsequent phases. Without accurate requirements, the entire project risks building the wrong product, leading to costly rework.

Exam trap

A common pitfall is confusing phases with tasks: requirements gathering, design, and testing are phases, whereas coding and release are tasks within phases.

Full explanation →
246
MCQmedium

A user wants to transfer files from a smartphone to a laptop. The smartphone supports USB-C with USB 3.0, and the laptop has both USB-A and USB-C ports. Which cable type is most appropriate for maximum transfer speed?

A.USB-A to USB-C cable
B.USB-C to Thunderbolt cable
C.USB-C to USB-C cable
D.USB-A to USB-A cable
AnswerC

Both devices have USB-C ports supporting USB 3.0 for maximum speed.

Why this answer

USB-C to USB-C cable ensures both ends support USB 3.0 speeds. USB-A might be limited if the port is older. Direct USB-C connection avoids speed bottlenecks.

Full explanation →
247
MCQhard

A company's IT department received multiple complaints from employees working on the third floor of an office building. They report that their wireless connections drop frequently and internet access is very slow. The network administrator performs a site survey and discovers that there are over 20 wireless access points (APs) in the vicinity, most operating on channels 1, 6, and 11. The company's AP is a dual-band 802.11ac device currently configured to use the 2.4 GHz band on channel 6. The administrator also notes that the company's AP is placed on a metal shelf near an elevator shaft. Which of the following actions should the administrator take to most significantly improve the wireless performance?

A.Change the AP to use the 5 GHz band
B.Relocate the AP away from the metal shelf and elevator
C.Increase the AP's transmission power
D.Change the AP channel to 1
AnswerA

The 5 GHz band has more channels and less congestion, significantly improving performance.

Why this answer

The 2.4 GHz band is heavily congested with over 20 APs on channels 1, 6, and 11, causing co-channel interference and frequent drops. Switching to the 5 GHz band on the dual-band 802.11ac AP provides many more non-overlapping channels (up to 23 with DFS) and significantly less interference, directly addressing the root cause of the slow and unreliable connections.

Exam trap

The trap here is that candidates often focus on physical placement or channel changes within the 2.4 GHz band, overlooking that the fundamental solution in a high-density, interference-saturated environment is to shift to the 5 GHz band, which offers far more spectrum and less congestion.

How to eliminate wrong answers

Option B is wrong because while relocating away from metal and an elevator shaft reduces physical obstructions and multipath interference, it does not solve the primary issue of extreme co-channel interference from 20+ APs on the 2.4 GHz band. Option C is wrong because increasing transmission power on a congested channel (6) would actually worsen interference for other APs and could cause more collisions and retransmissions, degrading performance further. Option D is wrong because changing to channel 1 still keeps the AP in the crowded 2.4 GHz band where all three non-overlapping channels (1, 6, 11) are saturated with over 20 APs, providing no meaningful relief from co-channel interference.

Full explanation →
248
MCQmedium

A company decides to deploy a new accounting application. The vendor offers a subscription model where users pay monthly. This is an example of:

A.Shareware
B.Software as a Service (SaaS)
C.Freeware
D.Open source
AnswerB

SaaS is a subscription model where the vendor hosts the application.

Why this answer

Software as a Service (SaaS) is a subscription-based model where users pay a recurring fee (e.g., monthly) to access the application hosted by the vendor over the internet. Option A (Shareware) is typically free for a trial period but may require a one-time purchase after trial, not a monthly subscription. Option C (Freeware) is free to use with no payment required.

Option D (Open source) refers to software with freely available source code and does not inherently involve a subscription model.

Full explanation →
249
MCQhard

A company is deploying a new customer relationship management (CRM) software. The software requires each user to have a unique login. Which of the following best describes this type of licensing?

A.Site license.
B.Subscription license.
C.Volume license.
D.Perpetual license.
AnswerB

Subscription licenses are often per-user and require unique credentials for access.

Why this answer

A subscription license grants the right to use software for a specific period, typically requiring recurring payments. In this scenario, each user needs a unique login, which aligns with a per-user subscription model where access is tied to individual accounts and renewed periodically. This is distinct from other licensing types that do not enforce per-user uniqueness or time-limited access.

Exam trap

The trap here is confusing a subscription license with a volume license, as both involve multiple users, but only subscription models enforce per-user unique logins and time-limited access.

How to eliminate wrong answers

Option A is wrong because a site license allows unlimited users within a single physical location or organization, not requiring unique logins per user. Option C is wrong because a volume license provides a bulk discount for multiple copies but does not inherently require unique user logins or subscription-based access. Option D is wrong because a perpetual license grants indefinite use after a one-time purchase, typically without per-user login requirements or recurring fees.

Full explanation →
250
MCQeasy

Which of the following describes a nibble?

A.4 bits
B.8 bits
C.16 bits
D.2 bytes
AnswerA

Correct: a nibble is 4 bits.

Why this answer

A nibble is half a byte, or 4 bits.

Full explanation →
251
MCQmedium

A technician is configuring a new workstation for video editing. Which of the following expansion cards would be MOST beneficial for improving video rendering performance?

A.TV tuner card
B.Network Interface Card (NIC)
C.Graphics processing unit (GPU)
D.Sound card
AnswerC

A dedicated GPU offloads rendering tasks from the CPU, significantly improving performance.

Why this answer

A dedicated GPU accelerates video rendering and processing, especially for professional video editing.

Full explanation →
252
MCQmedium

Refer to the exhibit. A technician is investigating a computer that randomly restarts. Based on the log, what should the technician check?

A.Power supply and connections
B.CPU cooling fan for proper operation
C.Recently installed device drivers
D.Memory modules for errors
AnswerA

Unexpected shutdowns often indicate power issues.

Why this answer

The log shows a 'Kernel-Power' event (ID 41) with no clear error before the restart, which typically indicates an unexpected loss of power. This points directly to a failing power supply or loose connections, as the system cannot maintain stable voltage under load. Checking the power supply and its connections is the first step in diagnosing random restarts caused by power instability.

Exam trap

The trap here is that candidates see 'random restarts' and immediately suspect overheating or drivers, but the Kernel-Power event 41 with no preceding error is the classic signature of a power supply issue, not a thermal or software problem.

How to eliminate wrong answers

Option B is wrong because a failing CPU cooling fan usually causes thermal throttling or shutdowns under load, not random restarts without a preceding thermal event in the log. Option C is wrong because recently installed device drivers typically cause blue screen errors (BSOD) with specific stop codes, not a clean Kernel-Power event 41. Option D is wrong because memory errors usually produce specific error codes like MEMORY_MANAGEMENT or cause crashes during memory-intensive tasks, not random restarts without any preceding error.

Full explanation →
253
MCQmedium

A technician is troubleshooting a network issue and needs to view the MAC address of a device. Which notational system is the MAC address most likely represented in?

A.Octal
B.Decimal
C.Binary
D.Hexadecimal
AnswerD

Correct.

Why this answer

MAC addresses are typically represented in hexadecimal (base-16) format, e.g., 00:1A:2B:3C:4D:5E.

Full explanation →
254
MCQmedium

A programmer writes a script that automates the backup of files every night. Which type of programming paradigm is this script likely using?

A.Event-driven programming
B.Procedural programming
C.Object-oriented programming
D.Functional programming
AnswerB

Procedural programming is based on a sequence of instructions, suitable for automation tasks.

Why this answer

The script automates a fixed sequence of steps (e.g., copy files, verify integrity, log results) executed in order every night. This is the hallmark of procedural programming, which structures code as a linear series of instructions or procedures. The task does not require reacting to events, modeling objects, or avoiding side effects, making procedural the natural fit.

Exam trap

The trap here is that candidates confuse the trigger mechanism (scheduled event) with event-driven programming, but the script's internal logic is procedural, not reactive to events.

How to eliminate wrong answers

Option A is wrong because event-driven programming relies on triggers like user clicks or sensor inputs, not a scheduled nightly routine. Option C is wrong because object-oriented programming organizes code around objects and classes, which is unnecessary for a simple sequential backup script. Option D is wrong because functional programming emphasizes pure functions and immutable data, which would be overkill and impractical for a file-copying task that inherently involves side effects (reading/writing files).

Full explanation →
255
MCQmedium

A user cannot connect to the internet. The network uses DHCP. Based on the exhibit, what is the most likely cause?

A.IP address conflict
B.Incorrect subnet mask
C.No default gateway configured
D.DHCP server is not responding
AnswerD

APIPA occurs when a DHCP server is unavailable, so the DHCP server is likely not responding.

Why this answer

The exhibit shows an APIPA address (169.254.x.x), which indicates that the client failed to obtain a DHCP lease. Since the network uses DHCP, the most likely cause is that the DHCP server is not responding, preventing the client from receiving a valid IP configuration.

Exam trap

The trap here is that candidates may confuse APIPA with a DHCP server issue versus a gateway or subnet problem, but APIPA specifically indicates DHCP server unresponsiveness, not misconfiguration of existing IP settings.

How to eliminate wrong answers

Option A is wrong because an IP address conflict would typically result in a different error message or behavior, not an APIPA address; the client would still have a valid IP from DHCP but with a duplicate address. Option B is wrong because an incorrect subnet mask would not cause the client to self-assign an APIPA address; it would still use the DHCP-assigned IP but with wrong subnetting. Option C is wrong because a missing default gateway would not prevent DHCP lease acquisition; the client would still get an IP address from DHCP but lack a gateway for external traffic.

Full explanation →
256
MCQmedium

A database administrator needs to ensure that a transaction either completes fully or not at all. Which property of database transactions is this?

A.Atomicity
B.Isolation
C.Consistency
D.Durability
AnswerA

Atomicity guarantees that a transaction is treated as a single unit, which either completes fully or not at all.

Why this answer

Atomicity ensures that a transaction is treated as a single, indivisible unit of work: either all of its operations are committed successfully, or none are applied. This is the 'all-or-nothing' property described in the ACID model. If any part of the transaction fails, the database management system (DBMS) rolls back the entire transaction, leaving the database unchanged.

Exam trap

The trap here is that candidates often confuse 'Atomicity' with 'Consistency' because both sound like 'completeness' or 'correctness,' but Atomicity strictly refers to the indivisible execution unit, not the validity of data.

How to eliminate wrong answers

Option B (Isolation) is wrong because it governs how concurrent transactions are invisible to each other until committed, not the all-or-nothing completion. Option C (Consistency) is wrong because it ensures that a transaction brings the database from one valid state to another, preserving integrity constraints, not the atomic execution. Option D (Durability) is wrong because it guarantees that once a transaction is committed, its changes persist even after a system failure, not the indivisible execution.

Full explanation →
257
Multi-Selecthard

A quality assurance team is executing system testing on a new banking application. They need to verify that the entire application works correctly from start to finish. Which THREE of the following testing types would be included in system testing?

Select 3 answers
A.Security testing
B.Integration testing
C.Functional testing
D.Unit testing
E.Performance testing
AnswersA, C, E

Security testing identifies vulnerabilities in the system.

Why this answer

System testing is end-to-end and includes functional testing to verify features, performance testing to check responsiveness, and security testing to ensure data protection. Unit testing and integration testing are earlier phases.

Full explanation →
258
MCQhard

During debugging, a developer sets a breakpoint and steps through the code line by line. Which debugging tool feature is being used to execute one line of code at a time?

A.Step execution
B.Breakpoint
C.Variable inspection
D.Logging
AnswerA

Step execution moves through code line by line.

Why this answer

Step-through execution (or step into/over) allows executing code one line at a time to observe behavior.

Full explanation →
259
MCQeasy

Which of the following is the decimal equivalent of the binary number 1101?

A.13
B.10
C.14
D.11
AnswerA

Binary 1101 equals decimal 13.

Why this answer

Binary 1101 = 1*8 + 1*4 + 0*2 + 1*1 = 13.

Full explanation →
260
MCQmedium

A user's laptop has a SATA SSD, and they want to upgrade to a faster storage solution. Which interface technology would provide the most significant performance improvement?

A.Hybrid drive (SSHD)
B.NVMe M.2
C.External USB 3.0 SSD
D.SATA M.2
AnswerB

NVMe uses PCIe lanes, providing significantly faster data transfer rates.

Why this answer

NVMe M.2 drives connect via PCIe, offering much higher speeds than SATA, which is limited to about 550 MB/s. NVMe can reach several GB/s.

Full explanation →
261
MCQhard

A project has frequent requirement changes and the team needs to deliver working software in short cycles. Which software development methodology is most appropriate?

A.Waterfall
B.Agile
C.DevOps
D.Spiral
AnswerB

Agile embraces change and delivers working software in short iterations, making it ideal for projects with frequent requirement changes.

Why this answer

Agile methodology is the most appropriate because it explicitly supports iterative development, frequent requirement changes, and short delivery cycles through practices like sprints and continuous feedback. Unlike rigid sequential models, Agile embraces change even late in development, making it ideal for projects where requirements evolve rapidly.

Exam trap

CompTIA often tests the distinction between Agile (a development methodology) and DevOps (a deployment/operations practice), leading candidates to confuse the two when the question focuses on requirement changes and short delivery cycles.

How to eliminate wrong answers

Option A is wrong because Waterfall is a linear, sequential model that requires complete requirements upfront and does not accommodate frequent changes; once a phase is completed, revisiting it is costly and disruptive. Option C is wrong because DevOps is a cultural and technical practice focused on integrating development and operations to automate deployment and infrastructure, not a software development methodology for managing requirement changes and iterative delivery. Option D is wrong because Spiral is a risk-driven model that combines prototyping and waterfall elements, but its emphasis on risk analysis and longer cycles makes it less suitable for delivering working software in very short, frequent iterations compared to Agile.

Full explanation →
262
Multi-Selectmedium

Which TWO of the following are benefits of using virtual machines? (Choose two.)

Select 2 answers
A.They require less software to operate
B.They can be easily migrated between host systems
C.Multiple operating systems can run on a single physical machine
D.They provide inherent security from all threats
E.Virtual machines always run faster than physical machines
AnswersB, C

Migration is a benefit.

Why this answer

Virtual machines are encapsulated into files (such as .vmdk or .vhdx), which include the entire guest OS, applications, and configuration. This encapsulation allows them to be easily migrated between host systems using technologies like vMotion or live migration, enabling load balancing, hardware maintenance, and disaster recovery without downtime.

Exam trap

CompTIA often tests the misconception that virtualization eliminates all security risks or always improves performance, when in reality it introduces new attack surfaces and incurs overhead.

Full explanation →
263
MCQeasy

A user wants to install a free text editor on their Windows computer. Which file extension is most likely used for the installer?

A..deb
B..exe
C..dmg
D..pkg
AnswerB

Windows executable installer files typically have .exe extension.

Why this answer

Windows installers commonly use .exe or .msi. .exe is the most common for executable installers.

Full explanation →
264
MCQmedium

A company uses a software license that allows anyone to view, modify, and distribute the source code, provided that any distributed modifications are also made available under the same license. Which type of license is this?

A.MIT License
B.GNU General Public License (GPL)
C.Freeware
D.Shareware
AnswerB

Correct. The GPL is a copyleft license requiring derivative works to be licensed under the same terms.

Why this answer

This describes a copyleft open-source license, such as the GNU General Public License (GPL), which requires derivative works to be distributed under the same license.

Full explanation →
265
MCQhard

Refer to the exhibit. A technician is troubleshooting connectivity from a PC connected to the 192.168.1.0/24 network. The PC cannot reach the 10.0.0.0/24 network. What is the most likely cause?

A.Incorrect subnet mask on the PC
B.Missing route to 10.0.0.0/24
C.Faulty cable on GigabitEthernet0/1
D.GigabitEthernet0/0 is disabled
AnswerD

The interface is administratively down.

Why this answer

The PC on 192.168.1.0/24 cannot reach 10.0.0.0/24 because GigabitEthernet0/0 is disabled, which is the interface that provides the default gateway or the path to the router. Without an active interface on the local subnet, the PC cannot send any frames to the router, and no traffic can leave the local network. Even if routes exist, a disabled interface prevents all Layer 1 and Layer 2 communication, making connectivity impossible.

Exam trap

CompTIA often tests the concept that a disabled interface on the local subnet is the most fundamental cause of connectivity failure, tricking candidates into focusing on routing or cabling issues on the remote side instead of verifying the local interface status first.

How to eliminate wrong answers

Option A is wrong because an incorrect subnet mask on the PC would affect communication within the 192.168.1.0/24 network or to other subnets, but it would not prevent the PC from sending traffic to its default gateway; the PC would still attempt to forward frames to the router's MAC address. Option B is wrong because a missing route to 10.0.0.0/24 on the router would prevent traffic from being forwarded beyond the router, but the PC could still reach the router's local interface; the issue here is that the PC cannot even send traffic to the router. Option C is wrong because a faulty cable on GigabitEthernet0/1 would affect connectivity to the 10.0.0.0/24 network from the router's perspective, but the PC's inability to reach the router is not caused by a problem on a remote interface; the PC's first hop is through GigabitEthernet0/0.

Full explanation →
266
MCQhard

A company wants to run a Linux virtual machine on a Windows host without dual-booting. Which type of software is needed to create and manage the virtual machine?

A.A compiler
B.A device driver
C.An emulator
D.A hypervisor
AnswerD

Correct: a hypervisor manages virtual machines.

Why this answer

A hypervisor (or virtual machine monitor) enables running VMs on a host OS.

Full explanation →
267
MCQmedium

A user is looking for a cloud-based suite of applications that includes word processing, spreadsheets, and email, and allows real-time collaboration with colleagues. Which of the following best meets these requirements?

A.Slack
B.Microsoft 365
C.Zoom
D.Google Workspace
AnswerD

Google Workspace is a cloud-based suite with real-time collaboration features.

Why this answer

Google Workspace (formerly G Suite) is a cloud-based productivity suite that includes Docs, Sheets, Gmail, and real-time collaboration features. Microsoft 365 is also cloud-based but includes locally installed applications; however, the question emphasizes cloud-based and real-time collaboration, both of which Google Workspace is known for. Microsoft 365 also offers these features, but Google Workspace is often more strongly associated with real-time collaboration.

Full explanation →
268
MCQeasy

A developer creates a new branch in a version control system to work on a new feature. After completing the feature, the developer wants to combine the changes from the feature branch back into the main branch. What is this process called?

A.Committing
B.Forking
C.Branching
D.Merging
AnswerD

Merging integrates changes from one branch into another.

Why this answer

Merging combines changes from one branch into another.

Full explanation →
269
MCQmedium

Which of the following is an example of an absolute file path?

A.C:\Users\John\Documents\file.txt
B.file.txt
C.Folder\file.txt
D...\Folder\file.txt
AnswerA

Starts from drive root.

Why this answer

An absolute path starts from the root directory, e.g., C:\Users\John\doc.txt.

Full explanation →
270
Multi-Selectmedium

Which THREE of the following are primary functions of a network router?

Select 3 answers
A.Providing wireless access to clients
B.Forwarding packets based on IP addresses
C.Connecting devices within the same local network
D.Performing Network Address Translation (NAT)
E.Assigning IP addresses via DHCP
AnswersB, D, E

Routers make forwarding decisions based on destination IP.

Why this answer

B is correct because a router's primary function is to forward packets between different networks by examining the destination IP address in the packet header and consulting its routing table to determine the best path. This Layer 3 (Network Layer) operation is fundamental to routing, distinguishing it from switches that operate at Layer 2.

Exam trap

CompTIA often tests the distinction between a router's core function (IP forwarding) and its optional features (like NAT, DHCP, or wireless), leading candidates to incorrectly include or exclude options based on common all-in-one device assumptions.

Full explanation →
271
MCQeasy

Which of the following devices is used to connect multiple computers in a local area network and forwards data based on MAC addresses?

A.Router
B.Switch
C.Hub
D.Modem
AnswerB

Switch forwards frames based on MAC addresses.

Why this answer

A switch operates at Layer 2 (Data Link Layer) of the OSI model and uses MAC addresses to make forwarding decisions. It maintains a MAC address table (CAM table) to learn which port each device is connected to, allowing it to forward frames only to the specific destination port, reducing collisions and improving network efficiency.

Exam trap

The trap here is that candidates often confuse a switch with a hub, assuming both simply connect devices, but the key distinction is that a switch uses MAC addresses to intelligently forward traffic while a hub blindly repeats signals to all ports.

How to eliminate wrong answers

Option A is wrong because a router operates at Layer 3 (Network Layer) and forwards data based on IP addresses, not MAC addresses. Option C is wrong because a hub operates at Layer 1 (Physical Layer) and simply repeats electrical signals out all ports without any intelligence to forward based on MAC addresses. Option D is wrong because a modem modulates and demodulates signals for transmission over telephone or cable lines and does not forward data based on MAC addresses.

Full explanation →
272
MCQeasy

A development team is building a new mobile app. The project has a fixed budget and scope, and the requirements are well-understood from the start. Which software development methodology would be most appropriate for this project?

A.Spiral
B.Scrum
C.Waterfall
D.Agile
AnswerC

Waterfall is sequential and suited for predictable, fixed-scope projects.

Why this answer

The waterfall methodology is best for projects with fixed scope and well-understood requirements because it follows sequential phases and is not designed to handle changes easily.

Full explanation →
273
MCQmedium

A database administrator is troubleshooting a slow query on a large table. Which index type would improve performance for an exact match search on a single column?

A.Clustered index
B.B-tree index
C.Bitmap index
D.Hash index
AnswerB

B-tree indexes are ideal for exact match and range queries, providing fast lookup.

Why this answer

A B-tree index is the correct choice for an exact match search on a single column because it organizes data in a balanced tree structure that allows O(log n) lookups, making it highly efficient for equality searches. In a large table, the B-tree index reduces the number of disk I/O operations by quickly navigating to the leaf node containing the exact key value.

Exam trap

The trap here is that candidates often confuse clustered indexes with performance gains for all query types, not realizing that a clustered index primarily optimizes data retrieval order and can slow down writes, while a B-tree index is the standard choice for exact match searches in most relational databases.

How to eliminate wrong answers

Option A is wrong because a clustered index physically reorders the table data based on the index key, which is beneficial for range queries but does not inherently improve exact match performance beyond what a B-tree index provides, and it can cause overhead during inserts and updates. Option C is wrong because a bitmap index is optimized for columns with low cardinality (few distinct values) and is typically used in data warehousing for complex queries involving multiple conditions, not for exact match searches on a single column in a transactional database. Option D is wrong because a hash index is designed for exact match lookups using a hash function, but it does not support ordered retrieval and is not the default or most common index type in relational databases like MySQL or SQL Server; B-tree indexes are the standard for general-purpose exact match queries.

Full explanation →
274
MCQeasy

Which tool is commonly used for automated testing in software development?

A.Jenkins
B.Git
C.Visual Studio
D.Docker
AnswerA

Jenkins automates testing and build processes.

Why this answer

Jenkins. Jenkins is a continuous integration tool that automates testing. Docker (D) is for containerization.

Git (B) is for version control. Visual Studio (C) is an IDE, but not specifically for automated testing.

Full explanation →
275
Multi-Selectmedium

Which TWO of the following are characteristics of ransomware?

Select 2 answers
A.It collects user information without consent.
B.It self-replicates to other systems without user interaction.
C.It encrypts the victim's files.
D.It demands payment in exchange for decryption.
E.It disguises itself as legitimate software.
AnswersC, D

Ransomware encrypts files to prevent access.

Why this answer

Ransomware encrypts files and demands payment for decryption.

Full explanation →
276
Multi-Selecthard

Which THREE of the following are effective methods to protect against malware infections? (Select THREE.)

Select 3 answers
A.Open all email attachments regardless of sender
B.Install and maintain antivirus software
C.Use a firewall to filter incoming and outgoing traffic
D.Disable automatic software updates to avoid changes
E.Keep operating systems and applications up to date
AnswersB, C, E

Antivirus software is a primary defense against malware.

Why this answer

Antivirus software detects and removes malware; keeping software updated patches vulnerabilities; using a firewall blocks malicious traffic. Disabling software updates would increase risk, and opening all email attachments is dangerous.

Full explanation →
277
MCQmedium

A small business uses a legacy inventory management application that runs on a Windows 10 workstation. The application stores data in a local Microsoft Access database. Recently, the application has started crashing intermittently when users attempt to generate reports. The error message indicates a 'database connection lost' error. The IT technician has verified that the network is stable and the workstation has sufficient disk space. The technician suspects the issue is related to software compatibility. Which of the following is the BEST course of action to resolve the issue while minimizing disruption to daily operations?

A.Upgrade the application to a cloud-based subscription version.
B.Repair the Microsoft Access database using the built-in repair tool.
C.Configure the application to run in compatibility mode for Windows 7.
D.Disable the antivirus software temporarily to test if it is interfering.
AnswerC

Compatibility mode can emulate older Windows environments, resolving issues with legacy applications.

Why this answer

Running the application in compatibility mode for an earlier Windows version often resolves crashes in legacy software that expects older system behaviors. Upgrading to a subscription-based cloud application would be costly and disruptive. Repairing the database might help if the database were corrupt, but the error is about connection loss, not data integrity.

Disabling the antivirus is a security risk and unlikely to fix a database connection issue.

Full explanation →
278
MCQhard

A help desk technician receives a call from a user who cannot connect to a network share. The user's computer shows a network icon with a red X. The technician asks the user to check the network cable connection. The user reports that the cable is securely connected. The technician then pings the default gateway from their own computer and the ping is successful. Which of the following is the NEXT step the technician should take?

A.Check the IP configuration on the user's computer
B.Replace the network cable
C.Restart the network share server
D.Disable the firewall on the user's computer
AnswerA

The red X and connectivity issue suggest a problem with the user's IP settings or DHCP.

Why this answer

The user's computer shows a network icon with a red X, indicating a physical or data-link layer issue, but the cable is reported as securely connected. The technician successfully pings the default gateway from their own computer, proving the network infrastructure (router, switch, cabling) is functional. The next logical step is to check the IP configuration on the user's computer, as a missing or misconfigured IP address (e.g., APIPA 169.254.x.x due to DHCP failure) could prevent connectivity even with a good cable.

This isolates the problem to the user's device rather than the network.

Exam trap

The trap here is that candidates assume a red X always means a bad cable or physical disconnection, but the question explicitly states the cable is secure, so the next step is to verify the logical configuration (IP address) rather than blindly replacing hardware or restarting servers.

How to eliminate wrong answers

Option B is wrong because replacing the network cable is premature; the user already confirmed it is securely connected, and the technician's successful ping indicates the cabling and switch port are likely fine. Option C is wrong because restarting the network share server is a drastic step that assumes the server is down, but the technician's successful ping to the default gateway only verifies local network reachability, not the server's status, and the issue is isolated to the user's computer. Option D is wrong because disabling the firewall is a security risk and should only be considered after verifying IP configuration and basic connectivity; a firewall typically blocks specific traffic, not all network access, and the red X icon suggests a lower-layer problem.

Full explanation →
279
MCQhard

An employee calls the help desk claiming to be a manager from another department and requests a password reset. This is an example of which social engineering technique?

A.Baiting
B.Pretexting
C.Tailgating
D.Phishing
AnswerB

Correct. The attacker creates a false identity to gain information.

Why this answer

Pretexting involves creating a fabricated scenario (pretext) to obtain information.

Full explanation →
280
Matchingmedium

Match each operating system to its common environment.

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

Concepts
Matches

Desktop and server

Server and embedded systems

Apple desktop computers

Web-based laptops

Why these pairings

Common environments: Windows (personal computing/gaming), Linux (servers/development), macOS (creative work). Android is for mobile, Chrome OS for web-based tasks.

Full explanation →
281
MCQmedium

A company uses a relational database with a 'Customers' table and an 'Orders' table. Each order must be linked to exactly one customer. Which type of relationship exists between Customers and Orders?

A.No relationship
B.One-to-many
C.Many-to-many
D.One-to-one
AnswerB

Each customer can have multiple orders, but each order links to one customer.

Why this answer

One customer can have many orders, but each order belongs to one customer, which is a one-to-many relationship.

Full explanation →
282
Multi-Selecthard

Which THREE of the following are components typically found inside a CPU?

Select 3 answers
A.Cache
B.RAM
C.Control Unit
D.Arithmetic Logic Unit (ALU)
E.Hard Drive
AnswersA, C, D

Cache is high-speed memory built into the CPU.

Why this answer

Cache is a small, high-speed memory located directly on the CPU die that stores frequently accessed data and instructions, reducing the time needed to fetch data from main memory (RAM). It is an integral part of the CPU's architecture, typically organized in multiple levels (L1, L2, L3) to balance speed and capacity.

Exam trap

The trap here is that candidates confuse external memory components (RAM, hard drive) with internal CPU components, or they mistakenly think the Control Unit and ALU are not part of the CPU, when in fact they are the core processing units.

Full explanation →
283
Multi-Selectmedium

Which THREE of the following are best practices for password security?

Select 3 answers
A.Sharing passwords with trusted coworkers when necessary
B.Enabling two-factor authentication where possible
C.Using a password manager to generate and store passwords
D.Reusing the same password across multiple sites
E.Using a password with at least 12 characters including uppercase, lowercase, numbers, and symbols
AnswersB, C, E

2FA adds an extra layer of security beyond the password.

Why this answer

Strong passwords are long, complex, unique, and not shared.

Full explanation →
284
MCQmedium

A company has a server room with two UPS units, each connected to a separate power circuit. The server room contains 10 servers, each with dual power supplies. One UPS fails and stops providing power. The administrator notices that half of the servers shut down, while the other half remain on. The servers that shut down were all connected to the failed UPS. However, the servers that remained on were also connected to the same UPS via their second power supply. Why did those servers not fail?

A.The servers that shut down were not connected to the working UPS
B.The servers that remained on had both power supplies connected to different UPS units
C.The failed UPS was overloaded and only some servers lost power
D.The servers that remained on had only one power supply connected
AnswerB

Dual power supplies connected to separate UPS units provide redundancy.

Why this answer

The servers that remained on had each of their dual power supplies connected to different UPS units (one to the failed UPS and one to the working UPS). When one UPS failed, the working UPS continued to supply power through the second power supply, allowing those servers to stay operational. The servers that shut down were only connected to the failed UPS via both power supplies or had their second power supply connected to the same failed UPS, providing no redundancy.

Exam trap

The trap here is that candidates assume all dual-power-supply servers automatically have redundancy, but the question tests the understanding that redundancy only exists if each power supply is connected to a separate, independent power source.

How to eliminate wrong answers

Option A is wrong because the servers that shut down were indeed connected to the working UPS via their second power supply, but the question states they were all connected to the failed UPS, implying they lacked a connection to the working UPS, which is why they failed. Option C is wrong because the scenario describes a UPS failure, not an overload; an overload would cause the UPS to shut down or trip a breaker, but the working UPS continued to power half the servers, indicating no overload condition. Option D is wrong because if the servers that remained on had only one power supply connected, they would have shut down when the UPS they were connected to failed, but they remained on, proving they had both power supplies connected to different UPS units.

Full explanation →
285
Multi-Selecthard

A database administrator needs to perform CRUD operations on a database. Which THREE SQL commands correspond to the 'Create', 'Read', and 'Update' operations?

Select 3 answers
A.CREATE
B.INSERT
C.DELETE
D.UPDATE
E.SELECT
AnswersB, D, E

INSERT creates new records.

Why this answer

CRUD stands for Create (INSERT), Read (SELECT), Update (UPDATE), Delete (DELETE).

Full explanation →
286
MCQmedium

A user is experiencing slow Wi-Fi performance at home. The router supports both 2.4GHz and 5GHz bands. Which frequency band would provide faster speeds but shorter range?

A.NFC
B.2.4GHz
C.Bluetooth
D.5GHz
AnswerD

5GHz provides faster speeds with shorter range and less interference.

Why this answer

The 5GHz band offers higher speeds but has shorter range and is less prone to interference compared to 2.4GHz.

Full explanation →
287
MCQeasy

A user at a small design company calls the help desk because their computer is running very slowly when opening large image files. The computer has 8 GB of RAM, a 500 GB HDD, and an integrated graphics card. The technician suspects the slow performance is due to insufficient RAM. Which of the following is the BEST course of action?

A.Increase the size of the page file
B.Add more RAM
C.Upgrade the HDD to an SSD
D.Reduce the image resolution
AnswerB

Adding RAM directly increases available memory for large files.

Why this answer

The computer has only 8 GB of RAM and an integrated graphics card, which shares system RAM for video memory. When opening large image files, the system runs out of physical RAM and must use the much slower page file on the HDD, causing severe slowdowns. Adding more RAM directly addresses the bottleneck by providing sufficient physical memory to hold the image data and reduce reliance on disk swapping.

Exam trap

The trap here is that candidates often confuse a symptom (slow disk access) with the root cause (insufficient RAM), leading them to choose an SSD upgrade (Option C) instead of addressing the primary memory shortage.

How to eliminate wrong answers

Option A is wrong because increasing the page file size only expands the amount of slow disk space used as virtual memory, which does not solve the underlying RAM shortage and can actually worsen performance due to increased disk thrashing. Option C is wrong because while upgrading the HDD to an SSD would improve overall disk I/O, it does not address the core issue of insufficient RAM; the system would still swap heavily, and the bottleneck would shift from disk speed to the lack of physical memory. Option D is wrong because reducing the image resolution is a workaround that changes the user's workflow and data quality, not a hardware or system-level fix for the insufficient RAM causing the slow performance.

Full explanation →
288
Multi-Selectmedium

Which TWO of the following are characteristics of object-oriented programming (OOP)?

Select 2 answers
A.Polymorphism
B.Inheritance
C.Top-down design
D.Encapsulation
E.Use of functions and procedures
AnswersB, D

Inheritance allows a class to derive from another class.

Why this answer

Inheritance (B) is a core characteristic of OOP because it allows a class to derive properties and behaviors from a parent class, promoting code reuse and establishing a hierarchical relationship. This is fundamental to OOP as defined in languages like Java, C++, and Python.

Exam trap

CompTIA often tests the distinction between OOP characteristics and general programming concepts, so candidates may mistakenly select 'Use of functions and procedures' (E) because they associate it with methods, but OOP's defining traits are encapsulation, inheritance, and polymorphism, not mere function usage.

Full explanation →
289
MCQeasy

Which of the following best describes the difference between a compiler and an interpreter?

A.Compiled programs run slower than interpreted programs.
B.A compiler executes code line by line; an interpreter translates the entire program at once.
C.A compiler translates the entire source code into machine code before execution; an interpreter executes code line by line.
D.A compiler checks for syntax errors at runtime; an interpreter checks at compile time.
AnswerC

Incorrect. While the description of compiler translation is accurate, interpreters do not need to wait for a full translation step; they can immediately start executing, making the overall process quicker for development.

Why this answer

A compiler translates the entire source code into machine code before execution, producing a separate executable. An interpreter translates and executes source code line by line at runtime. Compiled programs generally run faster at execution because translation is done ahead of time.

Therefore, option C is correct. Option A confuses development speed (no separate compile step) with execution speed. Option B reverses the two definitions, and option D incorrectly describes when syntax checking occurs.

Exam trap

CompTIA often tests the common misconception that interpreters are faster because they skip the compilation step, but the trap here is confusing the order of translation and execution, leading candidates to reverse the definitions of compiler and interpreter.

How to eliminate wrong answers

Option A is wrong because compiled programs typically run faster than interpreted programs, as the translation to machine code is done ahead of time, eliminating the overhead of per-line translation during execution. Option B is wrong because it reverses the definitions: a compiler translates the entire program at once, while an interpreter executes code line by line. Option D is wrong because a compiler checks for syntax errors at compile time (before execution), not at runtime; an interpreter checks for syntax errors at runtime as it processes each line.

Full explanation →
290
MCQeasy

A security guard notices an individual following closely behind an employee through a secured door without swiping a badge. This scenario is an example of which type of security threat?

A.Shoulder surfing
B.Phishing
C.Tailgating
D.Malware
AnswerC

Tailgating is unauthorized physical access by following someone.

Why this answer

Tailgating occurs when an unauthorized person follows an authorized person into a restricted area. Option A is wrong because shoulder surfing involves looking at someone's screen or keystrokes. Option B is wrong because phishing is a deceptive message or email.

Option D is wrong because malware is malicious software.

Full explanation →
291
Multi-Selecthard

Which TWO of the following are common causes of errors when executing a SELECT query? (Choose two.)

Select 2 answers
A.Table is too large
B.Incorrect column name
C.Index is missing
D.Missing table name
E.Network is slow
AnswersB, D

A misspelled or invalid column name causes an error.

Why this answer

A SELECT query references specific columns in the WHERE clause or SELECT list; if the column name is misspelled or does not exist in the table schema, the database returns an error (e.g., 'Unknown column' in MySQL or 'Invalid column name' in SQL Server). This is a fundamental syntax error that prevents query execution.

Exam trap

The trap here is that candidates confuse performance issues (large table, missing index, slow network) with actual query execution errors, but only syntax or schema mismatches (incorrect column name, missing table name) cause the query to fail.

Full explanation →
292
Multi-Selecteasy

Which TWO of the following are examples of cloud computing service models?

Select 2 answers
A.PaaS
B.IaaS
C.LAN
D.SAR
E.WAN
AnswersA, B

PaaS provides a platform for developing and deploying applications.

Why this answer

PaaS (Platform as a Service) is a cloud computing service model that provides a platform allowing customers to develop, run, and manage applications without the complexity of building and maintaining the underlying infrastructure. It includes operating systems, middleware, development tools, and database management, making it a core cloud service model alongside IaaS and SaaS.

Exam trap

The trap here is that candidates may confuse network types (LAN, WAN) or unfamiliar acronyms (SAR) with cloud service models, especially since the exam often includes plausible-sounding but incorrect options to test recognition of the standard NIST-defined models.

Full explanation →
293
MCQeasy

Which software license allows a user to install the software on multiple computers for personal use?

A.Trial version
B.Enterprise license
C.Open source license
D.Personal license
AnswerD

Personal licenses are designed for individual use on multiple devices.

Why this answer

A personal license grants a single user the right to install the software on multiple devices they own or control, typically for non-commercial use. This is distinct from a per-seat license, which limits installation to one computer per license key. The key differentiator is that the license is tied to the user, not the machine count.

Exam trap

The trap here is confusing a 'personal license' with a 'single-user, single-device' model, leading candidates to incorrectly choose an enterprise license for multi-computer use, when in fact enterprise licenses are for organizational scale, not personal multi-device rights.

How to eliminate wrong answers

Option A is wrong because a trial version is time-limited or feature-restricted and does not grant permanent multi-install rights; it is intended for evaluation only. Option B is wrong because an enterprise license is a volume licensing agreement for organizations, allowing deployment across many corporate devices, not for an individual's personal use. Option C is wrong because an open source license (e.g., GPL, MIT) grants rights to use, modify, and distribute the source code, but it does not specifically define a personal multi-computer installation allowance; the focus is on software freedom, not user-centric device limits.

Full explanation →
294
MCQeasy

Refer to the exhibit. A user executes: SELECT AVG(Salary) FROM Employees; What is the result?

A.55000
B.50000
C.165000
D.60000
AnswerA

The average is (50000+60000+55000)/3 = 55000.

Why this answer

The AVG function calculates the arithmetic mean of the Salary column across all rows in the Employees table. Given the salaries 50000, 60000, and 55000, the average is (50000 + 60000 + 55000) / 3 = 55000. Therefore, option A is correct.

Exam trap

The trap here is that candidates often confuse AVG with SUM or MIN/MAX, leading them to pick the sum (165000) or an extreme value (50000 or 60000) instead of correctly computing the mean.

How to eliminate wrong answers

Option B (50000) is wrong because it represents the minimum salary, not the average. Option C (165000) is wrong because it is the sum of all salaries (50000 + 60000 + 55000), not the average. Option D (60000) is wrong because it represents the maximum salary, not the average.

Full explanation →
295
MCQmedium

A database must be restored to the exact state at 11:00 AM. The last full backup was at 10:00 PM previous day, and transaction log backups were taken every hour. What is the minimum to restore?

A.Full backup plus all transaction log backups from after full backup
B.Transaction log backup only
C.Full backup only
D.Full backup plus differential backup
AnswerA

Enables restoration to any point in time.

Why this answer

To restore a database to a specific point in time (11:00 AM) when only full and transaction log backups exist, you must restore the most recent full backup (from 10:00 PM previous day) and then apply all subsequent transaction log backups in sequence. Transaction log backups contain all committed transactions up to the time of the backup, so applying them in order after the full backup brings the database to the exact state at the time of the last log backup (which would be 11:00 AM if the hourly log backup was taken at that time). Option A is correct because it includes the full backup and all transaction log backups taken after it, which is the minimum required for point-in-time recovery.

Exam trap

The trap here is that candidates often think a differential backup can achieve point-in-time recovery, but differentials only capture changes up to a point, not the granular transaction-level detail needed to restore to an exact time like 11:00 AM.

How to eliminate wrong answers

Option B is wrong because a transaction log backup alone cannot restore a database without a prior full backup to provide the base data structure and pages. Option C is wrong because a full backup alone only restores the database to the state at the time of that backup (10:00 PM previous day), not to the later point-in-time of 11:00 AM. Option D is wrong because a differential backup captures changes since the last full backup but does not provide point-in-time granularity to a specific hour; transaction log backups are required for that precision.

Full explanation →
296
MCQeasy

Which of the following is an example of an output device?

A.Scanner
B.Mouse
C.Keyboard
D.Monitor
AnswerD

Monitor is an output device.

Why this answer

A monitor displays visual output from the computer.

Full explanation →
297
Multi-Selecthard

Which THREE of the following are valid SQL statements?

Select 3 answers
A.REMOVE TABLE Employees
B.SELECT * FROM Employees WHERE Department = 'Sales'
C.MODIFY Employees SET Salary = 60000 WHERE ID = 1
D.DELETE FROM Employees WHERE ID = 5
E.INSERT INTO Employees VALUES ('John', 50000)
AnswersB, D, E

Valid SELECT query.

Why this answer

SELECT, INSERT, UPDATE, DELETE are core DML statements. CREATE is DDL but also valid SQL.

Full explanation →
298
MCQeasy

Which of the following best describes the 'Confidentiality' component of the CIA triad?

A.Systems are operational when needed
B.Data is accessible only to authorized users
C.Data is encrypted at rest
D.Data is not modified without authorization
AnswerB

Confidentiality prevents unauthorized access.

Why this answer

Confidentiality ensures that data is not accessed by unauthorized individuals. Integrity protects data from unauthorized modification, and availability ensures data is accessible when needed.

Full explanation →
299
MCQmedium

A company uses a web-based application that runs in a browser and stores data on a remote server. Which of the following best describes this type of application?

A.Desktop application
B.Mobile app
C.Hybrid app
D.Web application
AnswerD

Web applications run in a browser with server-side processing and storage.

Why this answer

Web applications are accessed via a browser and have server-side processing and storage. Desktop applications are installed locally, mobile apps run on mobile devices, and hybrid apps combine web and native elements but are not purely browser-based.

Full explanation →
300
MCQeasy

A company needs to store customer orders, where each order can contain multiple items. Which database design is most appropriate?

A.Three tables: Orders, Customers, and Items, with no direct link.
B.Two tables: Orders and OrderItems, linked by an OrderID foreign key.
C.A single table storing all data in a JSON column.
D.A single table with columns for order details and repeated item information.
AnswerB

This normalized design efficiently handles one-to-many relationships.

Why this answer

It uses a normalized relational design with two tables: Orders (holding order-level data) and OrderItems (holding individual item details per order). The OrderID foreign key in OrderItems creates a one-to-many relationship, allowing each order to contain multiple items without data redundancy or update anomalies. This design ensures referential integrity and efficient querying, which is the standard approach for transactional order systems.

Exam trap

The trap here is that candidates often choose Option D (single table with repeated columns) because it seems simpler, but they overlook the violation of first normal form and the practical limitations of fixed-width schemas for variable-length data.

How to eliminate wrong answers

Option A is wrong because three tables with no direct link fail to establish any relationship between orders, customers, and items, making it impossible to associate a customer with their orders or items with specific orders. Option C is wrong because storing all data in a single JSON column violates first normal form (1NF), prevents efficient indexing and querying of individual fields, and makes it difficult to enforce data integrity or perform relational operations like joins. Option D is wrong because a single table with repeated item information (e.g., multiple columns for item1, item2) violates atomicity and leads to a fixed maximum number of items per order, causing data redundancy and update anomalies when item details change.

Full explanation →
Page 3

Page 4 of 14

Page 5

All pages

1234567891011121314

Practice FC0-U71 by domain

Target a specific domain to shore up weak areas.

Tech Concepts and TerminologyInfrastructureApplications and SoftwareSoftware Development ConceptsData and Database FundamentalsSecurity
See all domains with question counts →