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

Question 1

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

Accepted Answer

INSERT INTO customers VALUES (...). To add a new customer record to the 'customers' table, the database administrator should use the SQL INSERT statement. The INSERT INTO statement is specifically designed to add new rows of data into a table. The syntax 'INSERT INTO customers VALUES (...)' will insert a new row with the provided values into the specified columns.

Answer

DELETE FROM customers WHERE ...

Answer

SELECT * FROM customers

Answer

UPDATE customers SET ...

Question 2

A software developer is working on a team project and uses Git for version control. The developer has made changes to the code and wants to save a snapshot of the current state of the project locally. Which Git command should they use?

Accepted Answer

git commit. The `git commit` command records the staged changes in the local repository, creating a permanent snapshot of the project's current state. It captures a point-in-time version of the code along with a commit message, allowing the developer to track history and revert if needed. Unlike remote operations, `git commit` works entirely locally, which matches the requirement to save a snapshot locally.

Answer

git pull

Answer

git branch

Answer

git push

Question 3

Which of the following file extensions is associated with a compressed archive file?

Accepted Answer

.zip. .zip is a common compressed archive format.

Answer

.exe

Answer

.jpg

Answer

.docx

Question 4

A user is trying to access a file located at 'C:\Users\John\Documents\report.docx'. This is an example of which type of file path?

Accepted Answer

Absolute path. An absolute path specifies the complete location of a file from the root of the file system, including the drive letter on Windows. 'C:\Users\John\Documents\report.docx' starts at the C: drive root and fully qualifies every directory down to the file, so it is an absolute (fully qualified) path. Relative paths, by contrast, are resolved against the current working directory.

Answer

Symbolic link

Answer

Relative path

Answer

Network path

Question 5

A developer is writing a program in C++. The source code needs to be translated into machine code before execution. Which process is required?

Accepted Answer

Compilation. Compilation is the process required to translate C++ source code into machine code before execution. The compiler converts the high-level code into an executable format.

Answer

Interpretation

Answer

Linking

Answer

Debugging

Question 6

A user wants to install an application on an Android smartphone. Which app store should they use?

Accepted Answer

Google Play. Google Play is the official app store for Android devices, developed and maintained by Google. It provides a curated catalog of applications that are compatible with the Android operating system. Installing apps from Google Play ensures they are scanned for security and updated automatically. Therefore, for an Android smartphone, Google Play is the correct choice.

Answer

Microsoft Store

Answer

Mac App Store

Answer

App Store

Question 7

Which programming data type would be used to store a value of 'True' or 'False'?

Accepted Answer

Boolean. A Boolean data type is specifically designed to hold one of two truth values: True or False. It is named after mathematician George Boole and is fundamental to conditional logic, comparisons, and control flow in programming. Storing 'True' or 'False' in any other type would be semantically incorrect and would lose the type's logical meaning.

Answer

String

Answer

Float

Answer

Integer

Question 8

A user wants to install a program on their Ubuntu Linux system. Which TWO file extensions are commonly used for Linux installer packages? (Select TWO.)

Accepted Answer

.deb. Option A (.deb) is correct because Debian-based distributions such as Ubuntu use .deb packages, which are installed with dpkg or apt (e.g., apt install ./package.deb). Option D (.rpm) is correct because .rpm is the standard package format used by RPM-based Linux distributions like Red Hat Enterprise Linux, Fedora, and openSUSE, and it is commonly recognized as a Linux installer package format. Option B (.dmg) is incorrect because it is a macOS disk image format, not a Linux package. Option C (.exe) is incorrect because it is a Windows executable format. Option E (.msi) is incorrect because it is a Windows Installer package format.

Answer

.dmg

Answer

.exe

Answer

.msi

Question 9

A developer is using Git for version control. Which THREE actions are core Git operations? (Select THREE.)

Accepted Answer

merge. Option A (merge) is a core Git operation because it combines changes from one branch into another, using the commit history and a three-way merge to integrate divergent lines of development. Option B (commit) is fundamental to Git, as it records a snapshot of the staged changes into the local repository, creating a new commit object with a unique SHA-1 hash. Option C (branch) is also a core Git operation, allowing the creation, listing, or deletion of branches, which are lightweight movable pointers to commits that enable parallel development. Options D (debug) and E (compile) are not Git operations; debugging and compiling are development tasks performed by debuggers and compilers, not by Git's version control commands.

Answer

debug

Answer

compile

Question 10

A database administrator needs to perform CRUD operations on a table. Which TWO SQL statements are used for the 'Create' and 'Read' operations? (Select TWO.)

Accepted Answer

INSERT INTO. INSERT INTO (B) is correct because it is the SQL statement that creates new rows in a table, satisfying the 'Create' portion of CRUD. SELECT (D) is correct because it is the SQL statement used to read/query existing rows from a table, satisfying the 'Read' portion of CRUD. DELETE (A) is incorrect because it removes rows and corresponds to the 'Delete' operation, not Create or Read. CREATE TABLE (C) is incorrect because it defines a new table's schema (DDL) rather than creating row-level data as part of CRUD. UPDATE (E) is incorrect because it modifies existing rows and corresponds to the 'Update' operation.

Answer

DELETE

Answer

CREATE TABLE

Answer

UPDATE

Question 11

A user wants to install software on a Windows computer using the application's official installer. Which of the following file extensions is most likely associated with a Windows executable installer?

Accepted Answer

.exe. Exe (executable) is the standard Windows file extension for application installers and executables. Running an .exe file launches the installer or the application on Windows systems.

Answer

.pkg

Answer

.dmg

Answer

.deb

Question 12

An IT administrator needs to install software on multiple company computers without user interaction. Which installation method should the administrator use?

Accepted Answer

Silent installation. A silent installation runs the installer with no user interaction, using command-line switches (e.g., /quiet, /silent, /S) so it can be deployed unattended across many machines. This is the standard method for mass deployment without user involvement. Network installation refers to installing from a shared network location, but it can still prompt the user; silent installation specifically addresses the no-interaction requirement.

Answer

App store installation

Answer

Interactive installation

Answer

Network installation

Question 13

Which of the following license types allows users to view, modify, and distribute the source code, as long as they include the original copyright notice and any modifications are also open source?

Accepted Answer

GNU General Public License (GPL). The GNU General Public License (GPL) is a copyleft license that explicitly requires derivative works to be distributed under the same GPL terms, meaning any modifications must also be open source. It also mandates preservation of the original copyright notice. This copyleft requirement is the defining characteristic that matches the question's condition that 'modifications are also open source.'

Answer

Shareware

Answer

Apache License 2.0

Answer

MIT License

Question 14

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?

Accepted Answer

Web application. A web application runs in a browser and stores/processes data on a remote server, accessed over the network via HTTP/HTTPS. This matches the description exactly. Desktop, mobile, and hybrid apps run natively on a device rather than in a browser with server-side data storage.

Answer

Desktop application

Answer

Mobile app

Answer

Hybrid app

Question 15

A developer writes code in a high-level language and then uses a tool to translate the entire source code into machine code before execution. This process is known as:

Accepted Answer

Compilation. Compilation translates the entire source code into machine code (binary) before execution. Interpretation executes code line by line without prior translation into machine code. Debugging is the process of finding errors, and linking combines object files into an executable.

Answer

Interpretation

Answer

Debugging

Answer

Linking