IT Specialist – Software Development Practice Test

These questions are part of the practice quiz. Start practicing

• Which term describes a server configuration concept that maps a virtual path to a physical directory containing website files?
• Garbage Collection is best described as?
• Which term refers to an object that has been created from a class?
• Which term denotes a limitation on the data entered within a data field in a database?
• Which description matches Linked Lists?
• The hashing of data to detect tampering from source to destination is associated with:
• What programming construct repeats execution while a given condition remains true?
• What characterizes a Key-Value Database?
• In databases, which term describes a method of storing data to make data easier to find when conducting searches on the data?
• A dictionary as a data source stores data in:
• A class based on another class is called:
• HTML5 is defined as?
• Which term is a blueprint for an object?
• What data type stores whole numbers?
• What term describes the process of testing a small unit of code to ensure it functions correctly?
• Which statement describes a static method in a class?
• In relational databases, a foreign key is best described as?
• Which architectural pattern uses a View and a ViewModel to enable data binding with the Model?
• A block of memory that uses a fixed memory allocation to store data is known as what?
• What is a stored procedure?
• In web development, which term describes a pointer in a web server configuration to a physical directory containing site files?
• Which loop guarantees at least one execution of its body?
• Which term describes the action of emitting an error from code to expose its properties for debugging?
• What programming concept involves a function calling itself to repeat execution under a condition?
• In object-oriented programming, the term for a class that extends another class?
• Which term refers to the mechanism that links two tables so information from one can be retrieved based on a shared attribute?
• SOAP stands for Simple Object Access Protocol. What is it primarily used for?
• A Switch statement is most appropriate when you need to handle which scenario?
• Which term describes the phase in the SDLC in which the actual code writing takes place?
• Which data type stores text?
• Which data type stores decimal numbers?
• Decision Table is a matrix that shows actions to take based on one or more conditions.
• Which term describes a data type that stores whole numbers?
• Flat File refers to a type of database where all the data is stored in a single file. Which term matches this description?
• What is Join?
• Which term refers to the scrambling of data to protect it from unwanted views?
• What term describes a connection between two database tables that allows one to look up information from the other using a common field?
• Which testing activity focuses on verifying a single component or unit of code in isolation?
• DDL stands for Data Definition Language, which consists of SQL keywords used to control the structure of a database.
• Which term refers to a suite of tools that help developers debug and analyze webpages from within a browser?
• Which description best captures Binary Search?
• Which SDLC phase involves bug fixing and handling enhancement requests?
• In database transactions, which statement best describes the isolation level?
• Flowchart is a diagram that represents the logic of a program using shapes and arrows. Which term matches this description?
• What term describes a line of code that causes an error to occur and allows a developer to view the error properties?
• Switch statements are used to ...
• What does JSON stand for and what is it?
• In the context of object-oriented programming, which term means an object that has been created from a class?
• Which statement about a stack data structure is true?
• Do...While loop runs:
• Which concept stores small files with session information on a local computer to be reused later?
• In concurrent programming, what best defines a lock?
• In object-oriented design, what is an interface?
• Which statement best describes Agile project management?
• Which term describes the act of hiding the internal state of an object and requiring access through its methods?
• Which term describes a pool of connections used by an application to connect to a server?
• Cross-Site Request Forgery is a malicious mechanism in which an attacker uses a person's authentication information to force actions on a website.
• Which sorting algorithm sorts by comparing adjacent elements?
• Which concept in programming focuses on ensuring every function in a code block has a clear purpose?
• In version control, the process of saving changes to a file or folder and unlocking the file or folder for editing purposes.
• In debugging, which concept refers to the order in which errors occur and the line numbers causing them?
• Concurrency is the act of two or more actions on the same data happening simultaneously. Which term describes this concept?
• Which markup language is designed to store and transport data in a structured, self-describing format?
• DML refers to SQL keywords that:
• Which term is a blueprint for an object?
• What is database normalization?
• Which term describes programming that is processed on the client machine when an application runs?
• Which term describes the act of not allowing a value to change after it is set?
• What is Local Storage?
• In web browsing, what does session storage refer to?
• Which algorithm sorts by repeatedly comparing adjacent elements and swapping when out of order?
• Which term refers to an English-language outline for eventual code examples in an app?
• Which data type stores numbers with fractional parts?
• What characterizes synchronous tasks?
• The deployment phase is when:
• What does Polymorphism refer to in OOP?
• Which memory area is used for local variables and function call frames, with automatic allocation and deallocation?
• Which statement about session storage is accurate?
• What is a base class in object-oriented design?
• Which term describes a type of join that includes only records common to both sides of a join?
• What is the term for a characteristic of an object?
• In version control, what is the copy of files and folders that a team can work on before merging?
• Which term describes a cryptographic key that is intended to be distributed publicly to enable encryption?
• What does LINQ do?
• In programming, an array is defined as:
• What is Linear Search?
• Which statement about the Software Development Life Cycle (SDLC) is accurate?
• What is a key characteristic of arrays in many programming languages?
• What data structure represents an item list that operates on a first-in-first-out basis?
• Which term describes the encryption key designed to be shared publicly to allow others to encrypt messages to a recipient?
• What is an HTTP Request?
• In memory management, an adjustable amount of memory set aside to store items such as objects is called what?
• Which term describes the act of shielding one item from another item?
• Which characteristic is typical of a single-page application?
• Hashing is best described as?
• Which database concept enforces rules on data entry?
• What is Page Lifecycle in web development?
• What is defined as coding two or more methods with the same name but with different functionality?
• In many programming languages, an access modifier designates what?
• Which sorting algorithm operates by selecting a pivot and moving elements left or right of it?
• Which term describes a block of code that forms a class?
• Garbage Collection provides what primary benefit?
• What is SQL Injection?
• In Agile methodologies, requirements are typically expected to be:
• Which term describes a group of connections an app uses to connect from the app to a server?
• Which option best defines Linear Search?
• In object-oriented design, a base class typically provides what for derived classes?
• What is the name of the exception handling construct that includes a try block, a catch block, and a finally block?
• Which statement best describes the Page Lifecycle in web applications?
• Which statement best describes an Outer Join?
• A SQL keyword used to run through a table, one line at a time.
• What SQL keyword is used to modify existing data in a table?
• Which statement best describes a REST API?
• Which diagram is used to show entities and relationships between those entities in a database?
• Which description matches the behavior of Selection Sort?
• Which term is a small file that stores information from a web session on the client machine for later use?
• What is a Private Key?
• Boolean values are primarily used to support which programming concept?
• Which term refers to the language that defines database structure (such as creating or altering tables)?
• What action creates a local copy of a repository from a remote host such as GitHub?
• Which construct includes a finally block that executes after either the try or catch block completes?
• In which architectural pattern is a ViewModel used to expose data and commands to the View, enabling data binding?
• GitHub serves primarily as what?
• Which term best matches the definition: A decision structure that checks for a condition and runs a block of code if the condition is true and a different block of code if the condition is false?
• Which statement best describes a for loop?
• Which concept ensures that each record in a table is unique?
• Which language acronym stands for a markup language used to organize data within a document?
• Which diagram shows the entities and relationships in a database?
• Which concept enables a derived class to provide its own implementation of a base class method?
• Which term describes a decision structure that checks for a condition and runs a code block if the condition is true?
• In transactional systems, rollback refers to
• Which of the following describes an action such as a mouse click, a window opening, or a text field changing?
• Document database stores records as documents:
• A simple data store that uses key-value pairs is commonly called:
• Which statement best defines JavaScript?
• A file or series of files that store information and allow people to develop queries and reports based on the information.
• Which statement best describes a for loop?
• Which statement best describes JavaScript?
• Which term describes a framework in which events drive control of an app?
• In programming, what is an Object?
• Which statement describes digital signature in the given context?
• In version control, the process of locking a file or folder so that only one person can work on the file or folder.
• Cascading Style Sheets (CSS) is a formatting language that controls how information is formatted on a webpage.
• What is a shared (symmetric) key in cryptography?
• HTML5, as described in the material, is best understood as?
• Which statement best describes an Interface in object-oriented design?
• Which term is defined as the act of ensuring every function in a code block has a purpose?
• What term refers to a mechanism in a database that can fire actions after data modifications or to prevent changes?
• Which statement best describes an abstract class in object-oriented programming?
• In databases, a function is defined as?
• Which framework is a database map that an app uses, and can be built from code or from a database?
• What describes decryption?
• Server-Side Programming is best described as?
• Which practice helps prevent SQL Injection?
• Which design pattern separates concerns into a model, a view, and a controller?
• Which SQL operation is used specifically to modify existing rows in a database table?
• What best describes a single-page application (SPA)?
• Which concept is used to apply style rules to HTML content?
• What is a Primary Key?
• What best describes OAuth?
• Which statement correctly reflects a core constraint of 1NF?
• In transactional terms, which operation finalizes all processes within a transaction?
• What data structure processes items in first-in-first-out order?
• What is the primary purpose of database normalization?
• Which loop construct repeats execution as long as its condition remains true?
• Which option describes the correct characteristic of symmetric (shared key) encryption?
• In software architecture, what is a delegate?
• What is Planning and Design in the SDLC?
• Which sorting algorithm sorts by repeatedly selecting the smallest remaining element and placing it into its final position?
• Which term describes the phase where actual code writing takes place in the SDLC?
• Which describes the Boolean data type?
• Which framework serves as a database map for an application and can be built from code or the database?
• In version control, what describes saving a local copy of a repository from a remote source like GitHub?
• Which statement correctly describes First Normal Form (1NF)?
• What is an HTTP Response?
• Which diagram is commonly used to illustrate the flow of program logic using shapes and arrows?
• In math, a calculation with multiple operands is called?
• What describes Overriding?
• In version control, what does the operation 'Merge' refer to?
• In object-oriented programming, what is a method?
• Which best describes defensive coding?
• Which term is described as an encryption key used by an app to send to a user to encrypt data?
• What type of database stores data in separate entities and relates them through common fields?
• Which statement describes JSON?
• Which phase of the software development life cycle details the business requirements for an app?
• Which term refers to a frame inside an HTML file that displays the contents of another HTML file?
• Which statement best describes a property of Third Normal Form (3NF)?
• Which practice focuses on removing unused code and ensuring errors are handled gracefully?
• Which term refers to the creation of an object based on a class?
• What describes a save point in a transaction?
• Merge Sort is a sorting algorithm that works by...
• Which term describes integrating changes from different branches into a single branch?
• What does State Management refer to in web forms?
• What is a foreign key in relational databases?
• Which option describes a Key-Value Database?
• Which term refers to a type of join where only records that are common to both sides of a join appear in the result set?
• Which statement best describes Testing in the SDLC?
• Which term defines the act of having a variable that cannot be changed once it is set?
• Which statement about server-side programming is true?
• What is GitHub primarily used for?
• What is a Generic Class?
• Which describes an Outer Join?
• Which term describes the structure or schema of a database?
• What describes Overloading?
• What is the typical behavior of a stack in data handling?
• Asynchronous tasks are best described as:
• Which SQL statement is used to retrieve data from a database?
• Which statement best describes rollback?
• Which concept is a matrix that maps combinations of conditions to actions?
• Which term describes an adjustable memory area used to store objects and support dynamic memory allocation?