CCNA Applications and Software Questions

The .docx extension identifies an Office Open XML word processing document, the default format produced by Microsoft Word. Other extensions map differently: .xlsx denotes spreadsheets, .pptx presentations and .pdf portable documents, so the extension alone determines the file type.

Freemium offers the core application free while displaying ads and prompting paid upgrades for additional features. This matches the stem exactly: free download, occasional advertisements, and optional paid tiers. Trialware and adware alone do not combine a free base product with paid upgrade options.

The /quiet or /silent switch suppresses all installer UI and prompts, letting the update run unattended across 500 machines via scripting or deployment tools. This directly satisfies the no-user-interaction constraint, unlike interactive installers that require clicking through dialogue boxes on each host.

Disk Cleanup targets files that are safe to remove, such as temporary files and superseded Windows Update packages, directly addressing the goal of reclaiming disk space. Selecting these categories removes installation leftovers that accumulate over time without touching installed applications, complementing the uninstall step performed through Programs and Features.

Setting the read-only attribute blocks write and modify operations on the file, so any attempt to save changes is refused until the attribute is cleared. This directly satisfies the stem's requirement to prevent accidental modification of a document, while still allowing the user to open and read it.

Log files record runtime events, errors and stack traces, giving the engineer historical evidence of what the program actually did before failing. This satisfies the debugging need to identify potential issues without halting execution, complementing interactive tools that inspect live state.

Windows executables use the .exe extension, which the OS loader recognises as a Portable Executable binary it can run directly. Downloadable installers for Windows are therefore distributed as .exe files, satisfying the scenario's requirement for the most likely installer extension on that platform.

A cloud-based suite keeps documents on a central service and uses real-time co-authoring so each participant's edits appear for others almost instantly. The service merges changes and tracks who is editing. This directly enables multiple employees to work in the same document at the same time and see each other's updates without exchanging files manually.

PDF (Portable Document Format) preserves the layout, fonts, and images exactly as intended and can be viewed on almost any device with a free reader. It is the standard for sharing final documents that should not be easily altered. This matches the user's need for universal viewability without the original software.

The .zip extension denotes a compressed archive container in Windows, holding one or more files in compressed form. Executable extensions such as .exe or document extensions such as .docx do not indicate compression, making .zip the extension that typically signals a compressed archive.

A copyleft license like the GNU GPL grants freedom to use, modify, and redistribute the software, but requires that derivative works be distributed under the same license. This ensures modified versions remain open and under identical terms, exactly matching the user's stated requirement for reciprocity.

An integer stores whole-number values without fractional components, matching an age expressed in completed years. It satisfies the stem's constraint that the script processes numeric input into an appropriate variable type, avoiding the precision and comparison issues that arise when ages are held as strings or floating-point values.

Collaboration software directly satisfies the category constraint by providing shared workspaces, persistent chat channels, file exchange and integrated voice or video meetings. Microsoft Teams and Slack both centre on real-time team communication rather than content creation or system maintenance, which is precisely the defining function this question tests.

OLE allows a document to contain objects such as charts and tables created by other applications, and the embedded object retains its original formatting and can often be edited in place. This directly supports combining text, a chart, and a table from separate files into one report, making OLE the correct feature.

Group Policy can deploy .msi packages to domain-joined computers at startup or to users at logon, which matches the requirement to update 150 machines without desk visits. Because Active Directory is already in place, this is the native, centralized method for silent .msi deployment, making it the correct choice.

INSERT INTO adds new rows to a table, directly fulfilling the 'Create' half of CRUD. It is the SQL statement that populates records, distinguishing it from SELECT, which only retrieves existing data without modifying the table's contents.

Antivirus software continuously scans files and processes against known malware signatures and behavioural heuristics, then quarantines or removes detected threats. This directly satisfies the stem's requirement for security software, since its core purpose is defending a device against malicious code rather than managing hardware or user productivity.

The scenario describes software whose source code is available and whose license allows the user to modify and redistribute it under the same terms. That combination matches an open-source license, often called copyleft when derivative works must carry the same terms. It explains both the availability of source and the permission to share changes.

In Windows 11, Settings > Apps > Installed apps lists installed programs with an ellipsis menu that offers Uninstall for each entry. This is the supported graphical method for removing a licensed application from a workstation, and it triggers the vendor's uninstall routine, which cleans up registry entries and files associated with the program.

Python code here executes directly by an interpreter at runtime, with no separate compilation step producing machine code. That interpreted, run-as-written execution model is precisely what defines a scripting language, satisfying the stem's stated constraint.

A loop repeats a block of instructions, testing a condition each iteration to decide whether to continue or exit. This directly satisfies the stem's requirement to run instructions repeatedly until a condition is met, unlike selection or sequential constructs.

Windows installer packages are typically compiled executables, so a .exe file runs the setup routine directly. This satisfies the requirement of installing a free text editor on Windows, unlike .txt, .jpg or .csv, which are data formats Windows cannot execute.

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

An index is a separate data structure, typically a B-tree, that maps column values to row locations. When a query filters on the indexed date column, the database can seek directly to the relevant range instead of reading every row. That is why report generation sped up while data entry, which touches individual rows, remained responsive.

An absolute path specifies a file's complete location from the filesystem root, here the drive letter C:\ followed by each directory. This satisfies the stem by tracing the full hierarchy rather than a relative position.

INSERT maps to the 'Create' operation, adding new rows to a table. It satisfies the stem's requirement for the Create command within CRUD, distinct from SELECT (Read) and UPDATE (Update). Its row-level write semantics make it the precise SQL statement for creating records.

OneDrive is Microsoft's cloud storage service integrated into Windows 11. By signing in with a Microsoft account, users can enable automatic syncing of the Documents folder to OneDrive. This provides cloud backup and access from other devices. It is the built-in feature designed for this purpose and requires minimal configuration, aligning perfectly with the user's need.

A web application runs in a browser and stores data on a remote server, exactly matching the stem's constraints. Unlike locally installed software, processing and storage occur server-side, with the browser acting as the client interface. This satisfies both the browser-based access and remote data storage requirements described.

Open-source licences grant access to source code and permit modification, enabling derivative works. This satisfies the stem's requirement for a characteristic of MIT or Apache licensing, since the freedom to modify is fundamental to the open-source definition.

A Boolean stores exactly two possible states, true or false, matching the stem's 'True' or 'False' value. Other types such as integer, string or float cannot natively represent a binary logical state, so Boolean is the precise fit.

A web API exposes defined endpoints over HTTP so separate applications can request and exchange data regardless of language or platform, satisfying the requirement to describe its core function. It is not a database, browser, or storage service.

Copying files to an external USB drive creates a second copy in a separate location, satisfying the requirement for redundancy. If the laptop fails or files are deleted, the external copy can be used for restoration. Regular copying also preserves older versions until they are overwritten, supporting recovery of earlier file states.

The .deb format is the native package archive for Debian-based systems, installed via dpkg or apt. Since the stem specifies a system using the Debian package manager, .deb directly satisfies that constraint, unlike .rpm (Red Hat) or source tarballs, which require different tooling.

Group Policy software installation allows administrators to deploy applications to domain-joined computers automatically, with elevated privileges, and can be configured to update or remove software as needed. This ensures consistent installation and simplifies updates, making it ideal for this scenario.

Scanning with current antivirus signatures and checking the file's reputation can detect known malware and flag suspicious or unsigned executables. This lets the user make an informed decision before execution. It is not a guarantee of safety, but it is the appropriate risk-evaluation step for an unexpected executable from an unknown source.

The web server executes server-side logic such as PHP, Python or Java, generating dynamic responses before sending them to the browser. Since the application is browser-accessible and slow, this component handles the processing that determines response time.

The UPPER function converts a text string to uppercase and returns the result in the cell where it is entered. Because it returns a new value rather than editing the source, A2 remains unchanged. This is precisely the behavior required to display an uppercase version of A2 in B2.

The .deb extension is the native package format for Debian-based distributions, including Ubuntu, which use dpkg and APT for installation. This directly satisfies the stem's constraint of a package ending in .deb, unlike RPM-based families such as Red Hat or SUSE, which cannot natively install .deb files.

A while loop repeats a block as long as its condition remains true, re-evaluating before each iteration. This directly satisfies the stated need to execute code repeatedly while a condition holds, unlike a for loop, which iterates over a sequence.

A branch is a movable pointer to a commit, letting developers diverge from the main line of history and work on isolated changes without affecting other work. This satisfies the stem's requirement for a core Git concept, as branching is fundamental to Git's distributed model and commit graph structure.

User Account Control (UAC) detects the attempt to write to protected areas and prompts for an administrator's credentials. If the user can provide them, the installation continues with elevated privileges. This is the standard behavior when a standard user tries to perform a task requiring admin rights on Windows 10.

The path begins at the drive root 'C:\', giving the full location from the file system's top level. This satisfies the stem's requirement for a path that is unambiguous regardless of the current working directory, unlike a relative path which depends on the present location.

Microsoft Teams is a collaboration and communication platform, not a web browser. It renders content within its own application shell and does not provide general-purpose URL navigation or browsing features, unlike Chrome, Edge, Firefox or Safari, so it is the correct non-browser answer.

.pkg is Apple's native installer package format, containing scripts and payloads that macOS Installer executes to place files and configure the system. It satisfies the installer-package requirement directly, unlike .dmg disk images, which merely mount as volumes.

A proprietary license keeps the source code private and restricts copying, modification, and redistribution. The scenario matches exactly: one installation, no copying, no modification. This is the standard commercial end-user license used by most paid productivity suites, so it is the correct classification.

Git is a distributed version control system that records snapshots of source code, enabling branching, merging and history tracking. It directly satisfies the requirement to track changes across a collaborative project, unlike build or ticketing tools.

git branch creates a new branch, which is an independent line of development. This allows the team to work on a new feature in isolation without impacting the main branch. Changes made on the branch can later be merged back. This is the standard Git operation for isolating feature work and aligns perfectly with the scenario.

SaaS delivers a complete, provider-managed application over the internet. The provider owns the servers, applies patches, and guarantees uptime, while users simply log in through a browser or mobile app. This exactly matches the email replacement described, making SaaS the correct cloud service model for the scenario.

The .deb format is the native package format for Debian-based distributions, including Ubuntu. It satisfies the stem's Ubuntu constraint directly, since Ubuntu derives from Debian and its package manager, dpkg, installs .deb files. Other Linux families use different formats, such as .rpm on Red Hat-based systems.

Legacy applications often depend on specific runtime libraries, such as particular versions of a framework or runtime, that are not present on a modern default Windows installation. Installing those libraries first ensures the program can load its dependencies and start correctly. This is a direct, necessary step to meet the stated requirement for specific runtime libraries.

Compilation translates C++ source directly into machine code before execution, satisfying the stem's requirement for a prior conversion step. Unlike interpretation, which executes instructions line by line at runtime, compilation produces a standalone binary. This matches the scenario where code must be converted ahead of execution.

Git integrates completed branch work by merging the feature branch into the main branch, combining the divergent commit histories. This satisfies the stem's scenario of a finished feature being brought back into the mainline after development on a separate branch.

Microsoft Teams is a collaboration application: it combines persistent chat, channels, file sharing, and integrated audio/video meetings, letting teams work together on shared content. That real-time, multi-user interaction satisfies the question's requirement for a collaboration tool.

DELETE removes rows from the customer table, satisfying the deletion requirement in the stem. Unlike TRUNCATE, which drops all rows and cannot be filtered, DELETE supports a WHERE clause, allowing targeted removal of specific customer records while leaving the table structure and remaining data intact.

Listing all four columns explicitly and supplying four matching values in the same order inserts a complete row. Every column is populated, so no NOT NULL constraint is violated, and the column list matches the VALUES tuple exactly.

Compilation translates the entire high-level source file into machine code ahead of execution, producing an executable. This matches the stem's constraint that the whole program is converted before it runs, distinguishing it from interpretation, which translates and executes line by line.

Offline access with local caching stores a copy of the documents on the device so the user can open and edit them without an active internet connection. When connectivity returns, the suite synchronizes the changes back to the cloud. This directly addresses the need to keep working during a temporary outage while preserving the cloud copy.

A commit records the staged changes as a new snapshot in the repository's history, identified by a unique hash and linked to its parent commit. This captures the repository state at that point, which is exactly the snapshot action described.

Trialware distributes a fully functional application free for a limited period, after which a licence purchase is required to continue use. This matches the 30-day fully functional trial described, distinguishing it from freemium, demo, or open-source models.

Multithreading enables a program to run multiple threads concurrently within a single process. Each thread can perform a separate task, such as downloading files while updating the UI, improving responsiveness. This is the correct concept for simultaneous execution of multiple instruction sequences.

A repository is Git's core storage unit, holding the complete commit history, branches and tracked files for a project. It satisfies the version control constraint directly: every commit, merge and checkout operation acts on repository contents, making it one of the three fundamental Git concepts the question requires.

Git is a distributed version control system that records every change to source code, enabling branching, merging and full history. It directly satisfies the stem's requirements for tracking modifications over time and supporting collaboration between multiple developers.

Conditional logic evaluates boolean expressions such as whether a user is logged in, then executes different branches accordingly. It is the programming construct that lets a program make decisions based on runtime conditions, matching the scenario described.

Compilation translates C++ source code into machine code before execution, producing an executable binary. C++ is a compiled language, so a compiler performs lexical analysis, optimisation and code generation, unlike interpretation which executes source line by line at runtime.

.docx is the Office Open XML format used by Microsoft Word 2007 and later, storing document text and formatting as zipped XML parts. Older binary .doc files and unrelated extensions such as .xlsx or .pptx do not denote Word documents.

The make install target copies compiled binaries, libraries, and configuration files into system directories such as /usr/local/bin. Because those locations are root-owned, sudo is required. This is the standard final step in the ./configure && make && make install sequence for locally built software on Linux.

Merging replays the feature branch's commits onto the main branch and creates a merge commit that preserves both histories, satisfying the requirement to integrate completed feature work. Unlike rebasing, it does not rewrite existing commits, so shared branch history stays intact for collaborators.

Browser-based execution with server-side processing is the defining split: web apps depend on a remote server and browser sandbox, while desktop apps run natively on the OS with direct hardware access. This satisfies the stem's request for a key architectural difference between the two models.

A loop is the construct designed for iteration, repeating a block of instructions a defined number of times. Setting the loop counter to 10 executes the block exactly ten times, directly satisfying the stated repetition requirement.

Silent installation runs the installer with preconfigured parameters and suppressed prompts, so deployment completes with no user interaction. This directly satisfies the stem's requirement to install software across multiple company computers unattended, unlike interactive setups that halt awaiting input.

The GNU General Public License is a copyleft licence: it permits viewing, modifying and distributing source code provided the original copyright notice is retained and derivative works are released under the same open-source terms. Permissive licences such as MIT or BSD allow modifications to remain closed-source, so they fail the stem's condition.

Google Workspace is a cloud productivity suite providing Docs, Sheets, Slides, Gmail and Drive under one subscription. These integrated applications cover document creation, spreadsheets and collaboration, satisfying the stem's requirement to identify a productivity software suite.

19.99 contains a fractional part, so most languages infer a floating-point type rather than an integer. Float stores real numbers with decimal precision, satisfying the stem's assignment of a decimal literal to the variable price.

Debian-based distributions such as Ubuntu use .deb packages managed by dpkg and apt, while Red Hat-based distributions such as Fedora and RHEL use .rpm packages managed by rpm and dnf. These are the two dominant native Linux package formats for installing applications.

Merging combines divergent branch histories by integrating commits from one branch into another, preserving the commit graph through a merge commit or fast-forward. This satisfies the stem's requirement for a core Git operation, as branching and merging are fundamental to Git's distributed version-control model.