Applications and Software

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

A user downloads a freeware application that displays occasional ads and offers paid upgrade options. This distribution model is best described 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 attributes on a Windows system would prevent a user from accidentally modifying a document when set?

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 downloads a software installer from the internet. On Windows, which file extension is most likely to be used for the installer?

Which file extension typically indicates a compressed archive in Windows?

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?

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

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

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

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

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

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

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

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

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

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

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 of the following best describes the function of a web API?

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?

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 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 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 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 developer is learning version control. Which THREE of the following are core Git concepts? (Select 3)

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 user is selecting a web browser for everyday use. Which of the following is NOT a web browser?

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 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 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 writes code in C++ and must convert it to machine code before execution. This process is called:

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 company is choosing collaboration software. Which TWO of the following are examples of collaboration applications? (Select 2)

A database administrator needs to retrieve, update, and delete records from a customer table. Which THREE SQL commands are required? (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 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:

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

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 programmer is using a version control system. Which THREE are core Git concepts?

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 programming concept allows a program to make decisions based on conditions, such as checking if a user is logged in?

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

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

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

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

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

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

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?

Which THREE of the following are productivity software suites?

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?

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

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

Which TWO of the following are types of desktop applications?

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

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

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

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

Which of the following best describes a web application?

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?

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?

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

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 file extensions is associated with a compressed archive file?

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

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 licenses allows users to modify and redistribute the source code, provided they keep the same license terms?

A system administrator is evaluating antivirus software for company computers. Which TWO features are most important for protecting against malware? (Select TWO.)

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

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

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?

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

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

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

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

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 user wants to access a file located in a subdirectory relative to the current working directory. Which type of path is being used?

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 is an example of open-source software license?

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

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

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

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