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

Question 1

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. The .exe extension is the standard executable file format for Windows installers. .dmg is for macOS disk images, .deb is for Debian-based Linux, and .pkg is for macOS installer packages.

Answer

.pkg

Answer

.dmg

Answer

.deb

Question 2

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. Silent installation runs the installer without displaying any prompts or requiring user input, ideal for automated deployments. App store installation typically requires user interaction, interactive installation requires clicks, and network installation may still involve prompts.

Answer

App store installation

Answer

Interactive installation

Answer

Network installation

Question 3

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 open source license that requires derivative works to be distributed under the same license, ensuring source code remains open. MIT and Apache are permissive licenses with fewer restrictions, and shareware is not open source.

Answer

Shareware

Answer

Apache License 2.0

Answer

MIT License

Question 4

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?

Accepted Answer

Google Workspace. 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.

Answer

Slack

Answer

Microsoft 365

Answer

Zoom

Question 5

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. 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.

Answer

Desktop application

Answer

Mobile app

Answer

Hybrid app

Question 6

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

Question 7

Which of the following file attributes on a Windows system would prevent a user from accidentally modifying a document when set?

Accepted Answer

Read-only. The read-only attribute in Windows prevents a file from being modified or deleted (though it can be overridden by the user). Hidden hides the file, system marks it as a system file, and archive is used for backup.

Answer

Hidden

Answer

System

Answer

Archive

Question 8

A developer needs to track changes to source code over time, collaborate with other developers, and maintain a history of all modifications. Which tool is specifically designed for these tasks?

Accepted Answer

Git. Git is a version control system that tracks changes, enables collaboration, and maintains a history. An IDE is for writing code, a debugger finds errors, and a text editor edits text files but lacks version control features.

Answer

Text editor

Answer

Integrated Development Environment (IDE)

Answer

Debugger

Question 9

Which of the following is a valid SQL statement to retrieve all records from a table named 'Employees'?

Accepted Answer

SELECT * FROM Employees. SELECT * FROM Employees is the correct SQL syntax to retrieve all columns and rows from the table. The other options have incorrect syntax or keywords.

Answer

GET * FROM Employees

Answer

FETCH * FROM Employees

Answer

READ * FROM Employees

Question 10

A user downloads a free application from the internet that offers full functionality for a 30-day period. After 30 days, the user must pay to continue using it. Which license type does this describe?

Accepted Answer

Trial. Trial software (often called trialware) provides full functionality for a limited time, then requires payment. Shareware may have limited functionality or be fully functional for a trial period. Freeware is free forever, and open source is free and modifiable.

Answer

Open source

Answer

Freeware

Answer

Shareware

Question 11

A programmer declares a variable 'price' and assigns it the value 19.99. In most programming languages, what is the data type of this variable?

Accepted Answer

Float. 19.99 is a number with a decimal point, so it is a floating-point number (float). Integer is a whole number, string is text, and boolean is true/false.

Answer

Boolean

Answer

String

Answer

Integer

Question 12

Which of the following is an example of a relative file path?

Accepted Answer

Documents\Report.docx. A relative path is defined relative to the current working directory, without a leading slash or drive letter. 'Documents\Report.docx' is relative. 'C:\Users\Report.docx' is absolute. '/home/user/Report.docx' is absolute on Linux, and '\Server\Share\Report.docx' is a UNC path.

Answer

/home/user/Report.docx

Answer

C:\Users\Report.docx

Answer

\Server\Share\Report.docx

Question 13

A project team is using Git for version control. Which TWO actions are typical Git operations? (Choose TWO.)

Accepted Answer

Commit. Commit saves changes to the local repository, and push uploads changes to a remote repository. Increase is not a Git command, and compile is not related to version control.

Answer

Compile

Answer

Increase

Answer

Branch

Question 14

A database contains a table 'Orders' with columns OrderID, CustomerID, OrderDate, and TotalAmount. Which THREE SQL statements will correctly insert a new row into the table? (Choose THREE.)

Accepted Answer

INSERT INTO Orders VALUES (1, 101, '2023-01-15', 50.00). The correct syntax for INSERT includes INTO and VALUES. The third option is also valid as it specifies column order. The first and second are missing INTO and VALUES respectively, and the last uses SET which is for UPDATE.

Answer

INSERT (OrderID, CustomerID, OrderDate, TotalAmount) INTO Orders VALUES (1, 101, '2023-01-15', 50.00)

Answer

INSERT INTO Orders SET OrderID=1, CustomerID=101, OrderDate='2023-01-15', TotalAmount=50.00

Answer

INSERT Orders VALUES (1, 101, '2023-01-15', 50.00)

Question 15

Which TWO of the following are examples of security software? (Choose TWO.)

Accepted Answer

Antivirus. Antivirus software protects against malware, and a VPN encrypts internet traffic for security. Web browser and media player are not primarily security tools.

Answer

Media player

Answer

Web browser

Answer

Text editor