Download WGU SCRIPTING AND PROGRAMMING EXAMINATION TEST 2026 COMPLETE QUESTIONS AND ANSWERS and more Exams Programming Languages in PDF only on Docsity!
WGU SCRIPTING AND PROGRAMMING EXAMINATION
TEST 2026 COMPLETE QUESTIONS AND ANSWERS
Transaction Manager - answer - What is the part of a database that prevents conflicts among concurrent requests? Spatial - answer - Stores geometric info, such as polygons Test changes iteratively - answer - What should be done to avoid introducing new problems when troubleshooting? The log - answer - What is the part of a database that stores information about updates, removals, and insertions that have been processed? Verify that there are no new problems - answer - Which strategy represents a best practice for evaluating a possible solution in the troubleshooting process? They ensure that activities are performed in an organized way. - answer
- What is a way in which algorithms help people perform daily tasks?
- Predictability and reliability
- Guiding us through many tasks and endeavors
- Are deeply ingrained in cultural norms, traditions, and societal expectations.
- Can be understood as a step-by-step procedures or sequences of tasks. Ex: recipe, driving directions, doing laundry - answer - Algorithms in a daily life
- understand the problem (break into smaller parts—>inputs, outputs, constraints)
- Choose the right algorithm
- Use pseudocode
- Modularity your code
- Handle Edge cases
- Optimize for readability
- Test and validate
- Optimize for performance
- Document your algorithm
- Iterate and Refine - answer - Algorithm best practices The catalog - answer - What is the name of the architectural component of a database that contains a directory of tables, columns, indices, and other objects?
PHP - answer - Which Programming language is interpreted? Prevent conflicts between concurrent transactions - answer - What must a database system do when processing transactions? Determine the inputs and outputs - answer - A manufacturing company hired a programmer to code an algorithm to choose the ideal box size for shipping a given order. Which step should be taken first as the programmer works on the algorithm? Use testing to ensure the algorithm's reliability - answer - A programmer has written an algorithm for an application that identifies a materials list for a given manufacturing process. Which best practice for algorithm validation should the programmer follow? n = 0 For i in range(550, 881): n = n + i - answer - Find sum of all integers from 550 to 880, inclusive, and then store result in the variable n.
Difference - answer - Select rows that only appear in one of two tables. Compiled languages require a greater effort to edit. - answer - Which statement describes how compiled and interpreted languages differ? programer - answer - Person develops applications that utilize the database Provide guiding decision-making principles - answer - How to algorithms affect daily life? Data Query Language (DQL) - answer - Includes the SELECT statement Validate the cause of a problem - answer - Purpose of hypothesis testing? Conduct testing to verify the accuracy of each part of the solution. - answer - A developer needs to create an algorithm to determine how to route requests for a company's internal information system. The developer has identified individual steps of the algorithm and written pseudocode. Which step should the developer take next?
'While' loop - answer - executes a block of code as long as a condition is true. Used when the number of iterations depends on a condition. Len( ): - answer - determines the length of a sequence (e.g., string, list, tuple) Function Recursion - answer - is a programming technique where a function calls itself within its own definition. Encapsulation, Abstraction, Inheritance, Polymorphism - answer - four Major Principles of Object Oriented Programming Encapsulation - answer - Bundling data (attributes) and methods (functions) that operate on the data within one unit, e.g., a class. Abstraction - answer - Hiding the complex implementation details and exposing only the necessary parts. Inheritance - answer - Mechanism to create a new class using details of an existing class without modifying it. Polymorphism - answer - Ability to define a single interface or method that can be used with different data types or classes.
Search algorithms - answer - used to find specific elements within a data structure, such as a list or array. Provide a systematic and efficient approach to locating specific items within a dataset, ensuring accuracy, flexibility, and scalability across various applications and domains. Sorting Algorithms - answer - Organize data into a specified order. Common _______ algorithms include bubble sorts, merge sorts, and quick sorts. Arrange elements within a dataset in a specified order, enabling efficient searching, analysis, presentation, and data preprocessing. Filtering Algorithms - answer - process data to extract elements that meet certain criteria, effectively narrowing down the dataset. Selecting or excluding elements from a dataset based on certain criteria, while a search algorithm focuses on locating a specific element or value within a dataset. A list of - answer - What is this an example of? [1, 2, 3] A tuple - answer - What is this an example of? (1, 2, 3) Dictionaries - answer - collections of key-value pairs, where each key is associated with a value.
solutions to avoid redundant computations. This technique is particularly useful for problems with overlapping subproblems. Greedy Algorithms - answer - make decisions based on the current best option without considering the global optimal solution.
- Algorithm efficiency (appropriate for problem and size and complexity)
- Problem decomposition (break down into smaller, more manageable subproblems)
- Algorithm validation (ensure correctness and reliability..Ex: unit testing, integration testing, performance testing)
- Optimization and refinement - answer - Best practices and considerations for PLANNING algorithms
- Determine inputs and outputs
- Breakdown problem into smaller tasks
- Describe each sub task in pseudocode
- Test pseudocode by working a problem - answer - How to develop an algorithm Flowcharts - answer - represent more complex algorithms by incorporating various symbols, decision points, and branching paths to capture the intricacies of the algorithm.
- Symbols and shapes
- Sequential steps
- Decision points (Diamond shaped symbols)
- Conditional statements (if-else or switch-case statements)
- Loops and iterations (for loops, while loops, and do-while loops) —
repeated multiple times until specific condition is met.
- Parallel processing (Complex algorithms sometimes involve parallel processing or simultaneous execution of multiple tasks) Paradigms - answer - programming style or philosophy used in the language, such as procedural, object-oriented, or functional. Data types - answer - Type of values that can be stored in a program like numbers, strings, and Booleans markup languages - answer - Primarily used for structuring and presenting content on the web. Focus on organizing and formatting data for display. scripting languages - answer - Subgroup of programming languages that are used for creating software applications and websites with dynamic functionality. EX: Python, R, JavaScript, and Perl. Executed one line at a time. Function - answer - self-contained block of code that performs a specific task and can be called from other parts of the program.
- Portability: don't rely on precompiled executables. Procedural Programming - answer - method of programming that uses step-by-step instructions Object-Oriented Programming (OOP) - answer - Programming paradigm based on objects and classes. Write programs by creating objects that have their own data and behavior. Functional Programming - answer - Write programs by defining functions that take inputs and produce outputs Event-Driven Programming - answer - some program statements run when triggered by an event, like a mouse click or a key press Declarative Programming - answer - Problem is described, language implementation decides how to solve it eg. SQL First-Class functions - answer - treat functions just like any other piece of data. We can pass them as arguments to other functions, return them from functions, and even store them in variables.(Functional programming)
- Immutability
- First-class functions - answer - Two principles of functional programming advantages:
- easier to understand and debug (with immutability, fewer surprises, making it easier to track down errors)
- concise and elegant code (shorter, more readable) Disadvantages:
- Steep learning curve
- not suitable for all tasks - answer - Advantages and disadvantages of Functional programming? Advantages:
- Simplicity
- Modularity
- Efficiency
- Ease of debugging
- Wide adoption
- Compatibility Disadvantages:
- Limited reusability
- Difficulty with complex problems
- Not always the best choice
A set - answer - What is this an example of? {1, 2, 3}...unordered, mutable collection of unique elements Mapping Type - answer - The only mapping type in Python is the dict type. Like a sequence type, a dict serves as a container. dict: dictionary, an unordered collection of key-value pairs. Example of this is : my_dict = {'key': 'value', 'name': 'John'} Syntax errors - answer - errors occur when the code violates the rules of the programming language, such as indentations, mismatched parentheses, or undefined variables. Logic Errors - answer - also known as bugs, occur when the code produces unexpected or incorrect results due to flawed logic or incorrect algorithm implementation. Runtime Errors - answer - occur during program execution and can lead to program crashes or unexpected behavior, such as accessing an undefined variable, accessing a file that does not exist, or attempting to divide by zero. Effective troubleshooting - answer - requires systematic approaches to identify and diagnose issues accurately. Strategies include: error messages and logs, code review, debugging tools, and isolation and simplification.
Code Review - answer - process where developers examine and evaluate source code to ensure its quality, correctness, and adherence to coding standards. It typically involves one or more developers reviewing another developer's code before it is merged into the main codebase. Primary objectives include: identifying issues, improving code quality, ensuring consistency, sharing knowledge, mitigating tasks, and fostering collaboration. Conducted using version control system like Git and other code review tools. Debugging Tools - answer - help developers identify and resolve errors, bugs, and unexpected behavior in their code. These tools provide features to inspect variables, control program execution, set breakpoints, and analyze program state during runtime. Examples: Print() statements, pdb, IDEs, ipdb, debugging with Jupyter Notebooks, Logging, remote debugging, profiling tools, third-party debugging libraries. print() statements - answer - simplest and most widely used debugging techniques. Python Debugger (pdb) - answer - allows developers to interactively debug Python programs by setting breakpoints, stepping through code line by line, inspecting variables, and evaluating expressions.
- Iterate and refine
- Verify and test fixes - answer - step-by-step approach to diagnosing programming problems using isolation and simplification Best practices for resolving issues - answer - Once the problem is identified and diagnosed, it's time to resolve the issue and implement a solution.
- Incremental changes - Test each change iteratively to ensure it resolves the issue without introducing new problems.
- Version control - Branching and merging workflows can help manage code changes effectively.
- Documentation - serve as a reference for future troubleshooting efforts and knowledge sharing.
- Testing and validation - verify that it resolves the problem and does not introduce regressions or new issues. Automated testing frameworks, unit tests, integration tests, and user acceptance tests to validate the solution thoroughly. Best practices when troubleshooting - answer - 1. Understand the problem
- Isolate the issue
- Verify inputs and outputs
- Review recent changes
- Use debugging tools
- Check for Error messages and logs
- Consult documentation and resources
- Test in isolation
- Collaborate and seek help
- Document findings and solutions
- Review and learn Troubleshooting - answer - systematic process for finding and fixing a problem's cause. Common process is to create a hypothesis and then run a test. Test - answer - procedure whose result validates or invalidates a hypothesis. Hypothesis - answer - states a possible cause of a problem. Programmers - answer - Who must follow a systematic process to find bugs? Following a systematic process can reduce frustration. Symmetric Test - answer - A result of Yes validates, and a No invalidates, a hypothesis (or vice versa).
