CCNA Applications and Software Questions

A web browser qualifies as a desktop application because it installs locally and executes natively on the endpoint's operating system, rather than running solely within a remote server session. This satisfies the stem's requirement for locally installed desktop software, distinguishing it from purely cloud-hosted or web-delivered alternatives.

.csv stands for comma-separated values and stores tabular data as plain text, with each line representing a row and commas separating fields. Spreadsheet applications open .csv files directly, and the format is widely used for importing and exporting data between spreadsheet and database tools. It is therefore a correct spreadsheet-related extension here.

A word processor like Microsoft Word or Google Docs supports equation editors, automatic table of contents generation, and collaborative features such as track changes and comments. These tools are designed for creating and formatting text-heavy documents with advanced layout requirements, making it the correct choice for this scenario.

INSERT INTO appends new rows to an existing table, specifying the target table and the column values to populate. It is the only statement among the standard DML verbs that creates records, whereas UPDATE modifies existing rows and SELECT merely retrieves them.

DELETE removes rows from a table while preserving the table structure, satisfying the requirement to remove a record without dropping the table itself. Unlike TRUNCATE, which clears all rows, DELETE supports a WHERE clause to target the specific record, and it is a DML operation rather than DDL.

SaaS delivers the CRM application over the internet, hosted by the vendor. The business pays a subscription fee, avoiding upfront hardware and software costs. Users can access the CRM via a web browser from any device, and the vendor manages updates, security, and availability. This matches the need for low upfront cost, no in-house IT, and anywhere access.

The /quiet switch suppresses the setup wizard's user interface and prompts, letting the installer run unattended across many workstations. This directly satisfies the stem's constraint of deployment without user interaction, making it a genuine silent installation method.

Silent installation runs the installer with command-line switches such as /quiet or /qn, suppressing all dialogue boxes and prompts. This directly satisfies the stem's constraint of no user interaction across 50 machines, allowing the technician to deploy the software unattended, typically via a script or management tool.

A web application executes its interface inside a browser while business logic and data processing occur on a remote server, satisfying both halves of the stem's definition. This client–server split distinguishes it from native desktop software, which processes locally, and from static websites, which serve content without server-side processing.

A .exe file is a Windows Portable Executable containing machine code that the operating system loads and runs directly, so an official installer packaged this way executes natively without any interpreter or runtime. This satisfies the stem's requirement for a Windows executable installer, unlike document, archive or script extensions.

Grouping worksheets lets a single edit, such as typing header text or setting column width, apply simultaneously to every selected sheet. Because the sheets remain linked only while grouped, the user can make all twelve monthly sheets consistent in one pass, and later edits made while grouped propagate the new header text across all of them.

A text editor opens and modifies plain text files such as configuration files, preserving their raw character content without formatting or binary encoding. Word processors and other application types would corrupt or reformat the file, so a text editor is the appropriate application for this task.

A .dmg is a disk image, not an installer itself; double-clicking mounts it as a virtual volume in Finder. The user then opens that mounted volume and runs the .app or .pkg inside, which performs the actual installation.

An incremental backup copies only the files that changed since the most recent backup of any type. Each nightly run captures just the newly modified data, which directly satisfies both requirements: automatically capturing changes and avoiding re-copying files that were untouched since the previous run, while keeping each job small and fast.

The .zip extension denotes a compressed archive, satisfying the stem's requirement for a file format that bundles and compresses one or more files. Unlike .txt or .exe, which hold plain text or executable code respectively, .zip uses lossless compression to reduce size, making it the standard archive format.

INSERT INTO ... VALUES adds new rows to a table, matching the requirement to add a customer record. It is the only DML statement here that creates data rather than retrieving, modifying or removing it.

A perpetual license involves a one-time upfront payment that grants the right to use the software indefinitely. This matches the company's requirement to avoid recurring costs. It is a common licensing model for business applications where long-term use is expected without additional fees.

A compatible viewer or reader application renders the document as intended, preserving text, formatting, images, and page layout without requiring the full authoring program. This satisfies the user's need to read and view the document reliably while avoiding the cost and installation footprint of the original word processor.

An .msi file is a Microsoft Installer package containing installation instructions, file manifests and registry changes, so Windows Installer can deploy the software automatically rather than requiring manual copying. This directly satisfies the stem's scenario of installing software on Windows, where the .msi extension denotes that packaged, self-executing installation format.

Web-based file converters can transform proprietary formats into universally readable formats like PDF without installing software. This allows the user to view the content using a PDF reader, which is typically already available. It is a practical solution when the original application is unavailable, though care must be taken with sensitive data due to privacy concerns with online converters.

The GNU General Public License is a copyleft licence: it permits modification and redistribution of source code, provided derivative works are released under the same GPL terms. This reciprocal condition distinguishes it from permissive licences such as MIT or Apache.

Relational databases store data in relations, commonly called tables, where rows represent records and columns represent fields. This is the defining structural characteristic of the relational model. The inventory system would place products in one table and suppliers in another, so this statement correctly describes the concept.

Real-time scanning inspects files as they are opened, downloaded or executed, intercepting malware before it can run. This satisfies the stem's protection requirement by blocking threats at the moment of access, rather than relying solely on periodic manual scans that leave infection windows open.

A spreadsheet application is built around a grid of rows and columns where each cell can hold data or a formula. It can open the file, recalculate formulas when cells change, and save the workbook with its formatting intact. This matches the user's need to edit cells and preserve formulas and formatting.

The SELECT clause names the column Name, FROM targets the Customers table, and WHERE filters rows on City = 'New York', satisfying the stated city constraint. This returns only matching customer names rather than every row.

macOS installer packages use the .pkg extension, a bundle format that the Installer application processes to place files and run scripts. This distinguishes it from .dmg disk images and .app application bundles, satisfying the question's requirement for the installer package extension.

Silent installation runs the update package with unattended switches, suppressing all prompts and dialogue boxes, so deployment to 200 domain computers proceeds without any user interaction. This directly satisfies the stem's requirement to avoid user involvement across the fleet, unlike interactive methods that halt pending input.

Shareware licenses permit try-before-you-buy distribution, letting users evaluate fully functional software for a trial period before paying to continue using it. This directly matches the stem's constraint of limited-time use prior to purchase, distinguishing it from freeware, which imposes no payment obligation, and open-source licences, which grant source-code rights.

Python executes source code line by line through an interpreter at runtime, without a separate compilation step producing machine code. This satisfies the stem's requirement for an interpreted language, since the interpreter translates and runs each statement directly rather than compiling the whole program ahead of execution.

The .exe extension denotes a Windows executable, which typically contains the installer program that unpacks and configures the graphics application. Other extensions such as .txt, .jpg or .docx are data files and cannot execute installation routines on Windows.

A relative path specifies a file's location from the current working directory, such as a subdirectory beneath it, rather than from the filesystem root. This directly satisfies the stem's scenario of accessing a file in a subdirectory relative to the current location.

git commit records the staged snapshot into the local repository's history, satisfying the requirement to save state locally. It differs from git push, which publishes commits to a remote, and from git add, which only stages changes for the next commit.

A cloud-based productivity suite runs in the browser, so nothing is installed on the laptops, and documents are stored in the provider's cloud where multiple users can edit simultaneously and changes appear within seconds. This directly satisfies both the no-installation constraint and the near-real-time collaboration requirement for the small business staff.

The MIT License grants permission to reuse, modify and redistribute software with only attribution and licence-notice requirements, satisfying the stem's open-source criterion. Its permissive terms contrast with proprietary EULAs, which restrict source access. Recognised by the Open Source Initiative, it qualifies alongside other approved licences such as Apache 2.0 and GPL.

A site license allows an organization to install and use software on multiple computers at a specific location, such as a small business office. It is designed for this exact scenario, providing legal coverage for all employees at the site. This is the appropriate recommendation.

Google Play is the default app store on Android smartphones, satisfying the stem's requirement for installing applications on that platform. It provides native APK delivery, automatic updates and Play Protect scanning, unlike third-party marketplaces or sideloading. For a standard Android device, Google Play is the intended, officially supported source.

SELECT * FROM Employees uses the asterisk wildcard to return every column for all rows, satisfying the requirement to retrieve all records. The FROM clause names the source table, and no WHERE filter restricts the result set, so the full table contents are returned.

The GNU General Public License grants users the freedom to run, study, modify and redistribute software, requiring derivative works to carry the same terms. This copyleft reciprocity is the defining characteristic of an open-source licence.