CCNA Itf Applications Software Questions — Page 2 of 2

MCQmedium

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?

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

B.SELECT Name FROM Customers WHERE City = 'New York'

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

D.DELETE FROM Customers WHERE City = 'New York'

AnswerB

Correct. This query retrieves the Name column for rows where City is 'New York'.

Why this answer

The SELECT statement is used to query data. The correct syntax is SELECT column FROM table WHERE condition. Here, we need the Name column from Customers where City equals 'New York'.

Practice this question →

MCQeasy

Which of the following is the correct file extension for a macOS installer package?

A..msi

B..pkg

C..exe

D..dmg

AnswerB

.pkg is an installer package on macOS.

Why this answer

.pkg is the standard macOS installer package format.

Practice this question →

MCQmedium

A technician is deploying a software update to 200 computers in a domain. To avoid user interaction, which installation method should be used?

A.Silent installation

B.App store installation

C.Interactive installation

D.Manual installation

AnswerA

Silent installation runs without prompts, suitable for automated deployment.

Why this answer

Silent installation runs without requiring user input, ideal for automated deployments. Interactive installers require user clicks, and app stores usually involve user interaction.

Practice this question →

MCQhard

A software license allows users to use the software for a limited time before purchasing. This is an example of which license type?

A.Commercial

B.Freeware

C.Shareware

D.Open source

AnswerC

Shareware often has a trial period.

Why this answer

Trial software is time-limited for evaluation before purchase.

Practice this question →

Multi-Selecteasy

Which TWO of the following are examples of interpreted programming languages?

Select 2 answers

A.C++

B.Assembly

C.Python

D.Java

E.JavaScript

AnswersC, E

Python is an interpreted language.

Why this answer

Interpreted languages are executed line by line without prior compilation.

Practice this question →

MCQeasy

A user needs to install a new graphics editing application on a Windows computer. Which file extension is most likely associated with the installer?

A..exe

B..deb

C..pkg

D..dmg

AnswerA

.exe is the standard executable file extension for Windows applications.

Why this answer

Windows executable installers typically use the .exe extension. .msi is also common for Windows Installer packages, but .exe is the most common for applications. .dmg is for macOS, .deb for Debian-based Linux.

Practice this question →

MCQmedium

A user wants to access a file located in a subdirectory relative to the current working directory. Which type of path is being used?

A.Absolute path

B.Relative path

C.Symbolic link

D.Network path

AnswerB

Relative path is based on the current working directory.

Why this answer

A relative path specifies location relative to the current directory. Absolute path starts from root (e.g., C:\\).

Practice this question →

MCQhard

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?

A.git pull

B.git branch

C.git commit

D.git push

AnswerC

git commit records changes to the local repository.

Why this answer

git commit saves a snapshot of the changes in the local repository.

Practice this question →

MCQeasy

Which of the following is an example of open-source software license?

A.Shareware

B.GPL

C.Commercial license

D.Freemium

AnswerB

GNU General Public License is an open-source license.

Why this answer

The GPL is a well-known open-source license that allows users to freely use, modify, and distribute software.

Practice this question →

Multi-Selectmedium

Which TWO of the following are open-source licenses? (Select 2)

Select 2 answers

A.Shareware license

B.MIT License

C.End-User License Agreement (EULA)

D.GNU General Public License (GPL)

E.Commercial license

AnswersB, D

MIT is a permissive open-source license.

Why this answer

GPL and MIT are well-known open-source licenses.

Practice this question →

MCQmedium

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

A.Microsoft Store

B.Mac App Store

C.Google Play

D.App Store

AnswerC

Google Play is the Android app store.

Why this answer

Google Play is the official app store for Android devices.

Practice this question →

MCQeasy

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

A.GET * FROM Employees

B.SELECT * FROM Employees

C.FETCH * FROM Employees

D.READ * FROM Employees

AnswerB

This is the standard SQL query to retrieve all records.

Why this answer

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.

Practice this question →

MCQeasy

Which of the following is an example of open-source software license?

A.Freeware

B.GPL

C.Shareware

D.Freemium

AnswerB

GNU General Public License is a common open-source license.

Why this answer

The GNU General Public License (GPL) is a well-known open-source license.

Practice this question →