Foundations of Coding WGU Preassessment

Foundations of Coding WGU Preassessment

• studiers in 3 days (1 review)

Students also studied Terms in this set (95) Western Governors UniversityDTAN 6228 Save Foundations of Coding Final exam st...31 terms luis_hernandez2704 Preview D615A-WGU-Foundations of Coding...19 terms nadams191Preview WGU - Scripting and Programming ...85 terms Pontiac1979Preview Founda 110 term daw Which type of SQL statement lets a user access information about a database?

A. FIND

B. LIST

C. SET

D. SHOW

A What should be done to avoid introducing new problems when troubleshooting?

• Test changes iteratively
• Conduct testing with limited inputs
• Develop multiple hypotheses
• Use symmetric and asymmetric tests

A What is the relationship between programming and scripting languages?

• Scripting languages are compiled forms of

programming languages.

• Scripting languages represent a subgroup of

programming languages.

• Scripting languages form the basis of programming

languages.

• Scripting languages interpret programming language

instructions.B

What is the part of a database that translates request instructions into low-level, file-system commands?

• The log
• The query processor
• The transaction manager
• The storage manager

D What is the component of Python that indicates where a given block of code ends?

• The "#" symbol
• Indentation
• Conditional statement
• Try-except block

B A user needs to name the table to be searched. Which SQL keyword is needed?

A. WHERE

B. MARK

C. SHOW

D. FROM

D Which goal represents a primary objective of code review?

• Eliminating randomness
• Consolidating modules
• Consolidating modules
• Sharing knowledge

D What is a strategy to make hypothesis testing more efficient?

• Create a hypothesis for each program function
• Create hypotheses that are likely and easy to test
• Use the same conditions to test each hypothesis
• Test a hypothesis asymmetrically when possible

D How do basic SQL and Python differ?

• SQL focuses on web applications, but Python does

not.

• SQL is a high-level language, but Python is not.
• SQL requires data type declarations, but Python does

not.

• SQL supports dynamic typing, but Python does not.

C What is the name of the architectural component of a database that contains a directory of tables, columns, indices, and other objects?

• The transaction manager
• The query processor
• The catalog
• The log

C

Which statement describes how compiled and interpreted languages differ?

• Compiled languages show results from changes faster.
• Compiled languages require more frequent translation.
• Compiled languages require a greater effort to edit.
• Compiled languages require more memory usage.

C Which strategy represents a best practice for evaluating a possible solution in the troubleshooting process?

• Run program versions in parallel
• Test with multiple end users
• Evaluate using multiple languages
• Verify that there are no new problems

A What is a way in which a sort algorithm enhances the efficiency of searching a data list?

• By ordering data based on predetermined criteria
• By performing basic data calculations
• By finding data elements that satisfy criteria
• By removing elements that are outliers

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

• Test the algorithm for each potential input
• Compare the algorithm's speed to expectations
• Use testing to ensure the algorithm's reliability
• Reduce the algorithm's dependence on external

modules C What is the part of a database that prevents conflicts among concurrent requests?

• The storage manager
• The transaction manager
• The catalog
• The query processor

D What is one way in which flowcharts simplify program planning?

• They use shapes to represent actions and decisions.
• They show the history of program changes.
• They list each possible function input.
• They give examples of specific coding languages.

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

• Describe individual tasks in pseudocode
• Test each portion of pseudocode
• Determine the inputs and outputs
• Break down the problem into smaller tasks

D

Which SQL operator is used to reverse the sign of one numeric value?

• ^
• %
• -
• /

C A user needs to select rows that only appear in one of two tables. Which relational operation should be used?

• Join
• Rename
• Difference
• Union

C How do algorithms affect daily life?

• They use metrics to evaluate performance.
• They reveal new approaches to old problems.
• They incorporate variety into task execution.
• They provide guiding decision-making principles.

D What is the SQL sublanguage that includes the SELECT statement?

• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Data Transaction Language (DTL)
• Data Query Language (DQL)

D What is a primary function of a database system?

• Ensuring data security
• Identifying trends in data
• Performing data forecasting
• Simplifying complex data

D Which action is a best practice for resolving issues during the troubleshooting process?

• Collaborate with team members
• Incorporate custom error messages
• Reduce the amount of source code
• Test with a different operating system

A A user needs to compare related columns of two tables to combine them.Which relational operation should be used?

• Join
• Union
• Intersect
• Difference

A