Applications and Software

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

A user wants to install software on a Linux system. Which file types are most commonly used for installing applications?

A technician needs to install software on 50 company computers without user interaction. Which installation method should be used?

A developer writes code in Python and runs it without compiling. This is an example of which type of language?

A user is selecting a web browser for everyday use. Which of the following is NOT a web browser?

Which of the following best describes a web application?

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

In Git, which action creates a snapshot of changes in the repository?

A user wants to remove a record from a database table. Which SQL command should be used?

Which file attribute prevents a file from being modified or deleted accidentally?

A developer writes code in C++ and must convert it to machine code before execution. This process is called:

Which of the following is an example of an absolute file path?

A company is choosing collaboration software. Which TWO of the following are examples of collaboration applications? (Select 2)

A developer is learning version control. Which THREE of the following are core Git concepts? (Select 3)

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

A user wants to install a free text editor on their Windows computer. Which file extension is most likely used for the installer?

A company is migrating its email and document collaboration from an on-premises server to a cloud-based solution. The IT manager wants to ensure that employees can access their files and emails from any device with a web browser. Which software category should the company implement?

A developer is writing a script in Python that processes user input. The script needs to execute a block of code repeatedly while a condition is true. Which programming construct should the developer use?

A user is trying to install software on a macOS computer and has downloaded a file with a .dmg extension. What should the user do with this file to install the software?

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

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

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?

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

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?

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

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

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

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

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

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

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?

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

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?

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?

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?

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:

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

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?

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

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?

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?

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

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

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

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

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

Which of the following software licenses allows users to modify and redistribute the source code, provided they keep the same license terms?

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

Which of the following is a key difference between a web application and a desktop application?

A user wants to edit a plain text configuration file on a Linux system. Which type of application is most appropriate?

In a database, which SQL statement is used to add new records to a table?

A programmer writes code to run a block of instructions repeatedly until a condition is met. Which programming concept is being used?

A developer is using Git and wants to integrate changes from a feature branch into the main branch. Which Git operation should be performed?

A user downloads a freeware application that displays occasional ads and offers paid upgrade options. This distribution model is best described as:

Which of the following best describes the function of a web API?

Which file extension typically indicates a compressed archive in Windows?

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 system administrator is evaluating antivirus software for company computers. Which TWO features are most important for protecting against malware? (Select TWO.)

A database administrator needs to retrieve, update, and delete records from a customer table. Which THREE SQL commands are required? (Select THREE.)

A software engineer is debugging a program and needs to identify potential issues. Which THREE tools or techniques are commonly used in debugging? (Select THREE.)

A user wants to install a software package on a Linux system using a package that ends in .deb. Which Linux distribution family is most likely being used?

A company uses a software license that allows anyone to view, modify, and distribute the source code, provided that any distributed modifications are also made available under the same license. Which type of license is this?

A developer writes a Python script that processes user input. During execution, the script prompts for an age and stores it in a variable. Which data type is most appropriate for the variable that stores the age?

A user is trying to install software from an .msi file on a Windows computer. What is the most likely purpose of an .msi file?

Which of the following software categories includes applications like Microsoft Teams and Slack?

A user downloads a trial version of a photo editing application that is fully functional for 30 days. After the trial period, the user must purchase a license. This type of software distribution model is known as:

A system administrator needs to deploy a software update to 500 computers without user interaction. Which installation method should be used?

Which of the following file extensions indicates a document created with Microsoft Word?

A user is troubleshooting an issue with a web application that is only accessible through a browser. The user notes that the application runs slowly. Which component is most likely responsible for processing the application's server-side logic?

A programmer is writing code that needs to repeat a block of instructions 10 times. Which programming construct is best suited for this task?

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?

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 user wants to install software on a macOS computer. Which TWO file types are commonly used as installer packages on macOS? (Select TWO.)

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

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

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

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

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?

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

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

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?

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

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

Which TWO of the following are types of desktop applications?

A developer is writing code and uses a variable to store a user's age. Which TWO data types are appropriate for storing a whole number age?

Which THREE of the following are productivity software suites?

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

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