FC0-U71 Applications and Software Practice Test 6 — 15 Questions

Question 1

A developer is working on a collaborative software project and uses Git for version control. The developer creates a new feature on a separate branch. After completing the feature, what is the typical next step to integrate the changes into the main branch?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Merge the feature branch into the main branch. After completing work on a feature branch, the typical next step is to merge the feature branch into the main branch to integrate the changes. This is the standard Git workflow: create a branch, commit changes, then merge back into the mainline (often via a pull request). Merging combines the histories and brings the feature into the main branch.

Answer

Commit the changes directly to the main branch

Answer

Delete the feature branch without merging

Answer

Push the branch to the remote repository

Question 2

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

Accepted Answer

SELECT Name FROM Customers WHERE City = 'New York'. The SELECT statement is the only SQL command that retrieves data without modifying it. The syntax SELECT Name FROM Customers WHERE City = 'New York' correctly specifies the column to return (Name), the table to query (Customers), and the filter condition (City = 'New York'). This returns exactly the customer names in New York as required.

Answer

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

Answer

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

Answer

DELETE FROM Customers WHERE City = 'New York'

Question 3

A user wants to install software on a macOS computer. Which TWO file types are commonly used as installer packages on macOS? (Select TWO.)

Accepted Answer

.pkg. Option A (.pkg) is correct because macOS uses flat package files (.pkg) as native installer packages that the Installer.app utility opens to place files and run installation scripts. Option C (.dmg) is correct because a disk image (.dmg) is a common macOS distribution container that, once mounted, typically holds an app bundle or a .pkg installer the user runs to install software. Option B (.exe) is not correct because .exe is a Windows executable format that macOS does not natively execute as an installer. Option D (.msi) is not correct because .msi is a Windows Installer package format used by Windows systems. Option E (.deb) is not correct because .deb is a Debian/Ubuntu Linux package format, not a macOS installer type.

Answer

.exe

Answer

.msi

Answer

.deb

Question 4

A company is evaluating different software licenses for a new project. Which THREE of the following are characteristics of open-source licenses such as the MIT License or Apache License? (Select THREE.)

Accepted Answer

Users can modify the source code.. Option C is correct because open-source licenses such as MIT and Apache explicitly grant the right to modify the source code, which is a core requirement of the Open Source Initiative definition. Option D is correct because these licenses permit redistribution of the software, including in original or modified form, subject only to attribution or notice requirements. Option E is correct because open-source licenses grant freedom of use for any purpose, including commercial use, without field-of-use restrictions. Option A is incorrect because open-source licenses do not require modifications to be kept private; in fact, they permit and often encourage public distribution of modified versions. Option B is incorrect because MIT and Apache licenses are royalty-free and do not require payment of a fee to use the software.

Answer

Users must keep their modifications private.

Answer

Users must pay a fee to use the software.

Question 5

A database includes a table called 'Products' with columns: ProductID, ProductName, Price, and Quantity. Which TWO of the following SQL statements correctly insert a new product into the table? (Select TWO.)

Accepted Answer

INSERT INTO Products (ProductID, ProductName, Price, Quantity) VALUES (1, 'Widget', 9.99, 100). Only the INSERT statements that provide values for all required columns in the correct order are valid. Option C explicitly lists columns and provides correct values. Option E omits column names but provides values for all four columns in the correct order. Option A uses an invalid syntax (SET clause is not standard SQL for INSERT). Option B provides three values but only two column names, causing a mismatch. Option D provides only three values for a four-column table.

Answer

INSERT INTO Products SET ProductID=1, ProductName='Widget'

Answer

INSERT INTO Products (ProductName, Price) VALUES ('Widget', 9.99, 100)

Answer

INSERT INTO Products VALUES (1, 'Widget', 9.99)

Question 6

A user downloads a software installer from the internet. On Windows, which file extension is most likely to be used for the installer?

Accepted Answer

.exe. On Windows, the standard file extension for executable programs and software installers is .exe (executable). When a user downloads an installer for Windows, it is typically an .exe file that can be run to install the application. The other extensions are associated with different operating systems: .pkg and .dmg are used on macOS, and .deb is used on Debian-based Linux distributions.

Answer

.pkg

Answer

.deb

Answer

.dmg

Question 7

A developer wants to install a Linux application on a system that uses the Debian package manager. Which package format should the developer look for?

Accepted Answer

.deb. Debian-based Linux distributions (Debian, Ubuntu) use the dpkg package manager and .deb package format. A developer installing software on such a system should look for .deb packages, which can be installed with dpkg or apt.

Answer

.msi

Answer

.rpm

Answer

.pkg

Question 8

Which programming concept allows a program to make decisions based on conditions, such as checking if a user is logged in?

Accepted Answer

Conditional logic. Conditional logic (e.g., if/else statements) evaluates a Boolean expression and executes different code paths based on whether the condition is true or false. In the example, checking if a user is logged in requires a decision point: if the user is authenticated, grant access; otherwise, redirect to login. This is the fundamental mechanism for decision-making in programming, distinct from iteration, modularization, or data storage.

Answer

Loops

Answer

Functions

Answer

Variables

Question 9

A user saves a document as 'report.docx'. Based on the file extension, what type of file is it?

Accepted Answer

Word processing document. The .docx extension is the standard file format for Microsoft Word documents, which are word processing files. It indicates a document created in a word processor, containing formatted text, images, and other elements. Therefore, 'report.docx' is a word processing document.

Answer

PDF file

Answer

Presentation

Answer

Spreadsheet

Question 10

A software engineer is working on a collaborative project and needs to track changes to the source code. Which of the following tools is specifically designed for version control?

Accepted Answer

Git. Git is a distributed version control system (DVCS) designed specifically to track changes to source code, maintain history, and support branching/merging across collaborative teams. It records snapshots of the repository and lets multiple developers work concurrently without overwriting each other's changes. The other tools serve different roles in the development lifecycle and do not provide version history or change tracking.

Answer

Compiler

Answer

Debugger

Answer

IDE

Question 11

A company is deploying software to multiple workstations without user interaction. Which TWO installation methods are considered silent installations?

Accepted Answer

Running setup.exe /quiet. Option B is correct because running setup.exe /quiet invokes the installer's silent mode, suppressing the user interface and requiring no interaction, which is exactly what unattended deployment needs. Option C is correct because msiexec /i package.msi /qn installs the MSI package with the /qn switch, which sets the Windows Installer UI level to "no UI," producing a fully silent installation. Option A is not silent since double-clicking setup.exe and clicking Next requires manual user input at each wizard step. Option D is not a silent installation method because app store installations typically involve user-driven prompts and account interaction. Option E is not silent because downloading from a website and manually running the installer requires user action to initiate and complete the install.

Answer

Double-clicking setup.exe and clicking Next each time

Answer

Using an app store to install

Answer

Downloading from a website and manually running the installer

Question 12

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

Accepted Answer

INSERT. The 'Create' part of CRUD in terms of row-level data operations is fulfilled by INSERT (option B), which adds new rows into a table using INSERT INTO ... VALUES syntax. The 'Read' operation is fulfilled by SELECT (option E), which retrieves rows from one or more tables and is the standard SQL query command. The 'Update' operation is fulfilled by UPDATE (option D), which modifies existing row values using UPDATE ... SET ... WHERE. CREATE (option A) is a DDL statement for creating schema objects such as tables or databases, not for creating data rows, so it does not map to the CRUD 'Create' data operation here. DELETE (option C) removes rows and corresponds to the 'Delete' operation, not to Create, Read, or Update, so it is not among the three required commands.

Answer

CREATE

Answer

DELETE

Question 13

Which TWO of the following are types of desktop applications?

Accepted Answer

Web browser. A web browser (D) is a classic desktop application because it is installed locally on a workstation's operating system (Windows, macOS, Linux) and runs as a native GUI process on that machine. A media player like VLC (E) is likewise a desktop application: it is installed locally and executes on the user's own computer to play audio/video files. By contrast, a mobile app from Google Play (A) is packaged for Android/iOS mobile platforms, not desktop operating systems. A server-side script (B) executes on a server (e.g., PHP, ASP.NET, Node.js) rather than on the user's desktop. A web-based email client (C) runs in the browser and is delivered from a remote web server, so it is a web application, not a desktop application.

Answer

Mobile app from Google Play

Answer

Server-side script

Answer

Web-based email client

Question 14

Which THREE of the following are productivity software suites?

Accepted Answer

Google Workspace. Google Workspace (B) is a cloud-based productivity suite bundling Gmail, Docs, Sheets, Slides, and Drive, so it clearly qualifies. Apache OpenOffice (C) is an open-source office suite containing Writer, Calc, Impress, and Base, making it a classic productivity suite. Microsoft 365 (E) is Microsoft's subscription productivity suite combining Word, Excel, PowerPoint, Outlook, and Teams, so it also qualifies. Slack (A) is a team messaging/collaboration tool rather than a full productivity suite, and Zoom (D) is a video-conferencing service, so neither belongs in this category.

Answer

Slack

Answer

Zoom

Question 15

A programmer is using a version control system. Which THREE are core Git concepts?

Accepted Answer

Repository. Option B (Repository) is correct because a Git repository is the core storage structure that holds all tracked files, history, and metadata in the .git directory. Option C (Branch) is correct because a branch is a movable pointer to a commit, enabling parallel lines of development in Git. Option D (Commit) is correct because a commit is Git's fundamental snapshot object that records a point-in-time state of the repository along with author, message, and parent references. Option A (Variable) is incorrect because variables are programming-language constructs, not Git concepts. Option E (Compilation) is incorrect because compilation is a build-process step performed by compilers, unrelated to Git's version control model.

Answer

Variable

Answer

Compilation