Foundations of Coding (WGU) Practice exam
questions and answers.
1. Transaction Manager: What is the part of a database that prevents conflicts among concurrent requests?
2. Spatial: Stores geometric info, such as polygons
3. Test changes iteratively: What should be done to avoid introducing new problems when troubleshoot- ing?
4. The log: What is the part of a database that stores information about updates, removals, and insertions that have been
processed?
5. Verify that there are no new problems: Which strategy represents a best practice for evaluating a possible
solution in the troubleshooting process?
6. They ensure that activities are performed in an organized way.: What is a way in
which algorithms help people perform daily tasks?
7. 1. Predictability and reliability
2. Guiding us through many tasks and endeavors
3. Are deeply ingrained in cultural norms, traditions, and societal expecta-
tions.
4. Can be understood as a step-by-step procedures or sequences of tasks.
Ex: recipe, driving directions, doing laundry: Algorithms in a daily life
8. 1. understand the problem (break into smaller parts—>inputs, outputs,
constraints)
2. Choose the right algorithm
3. Use pseudocode
4. Modularity your code
5. Handle Edge cases
6. Optimize for readability
7. Test and validate
8. Optimize for performance
9. Document your algorithm
10. Iterate and Refine: Algorithm best practices
9. The catalog: What is the name of the architectural component of a database that contains a directory of tables,
columns, indices, and other objects?
, 10. Scripting languages represent a subgroup of programming languages: What is
the relationship between programming and scripting languages?
11. Join: compare related columns of two tables to combine them.
12. Collaborate with team members: Which action is a best practice for resolving issues during the
troubleshooting process?
13. represents a template for the creation of an object.: Which purpose does a class have in
Python?
14. Data Definition Language: Includes the CREATE statement
15. Product: List all combinations of rows of two tables
16. Guests = input("How many guests?"): Display message "How many guests?" In python and STORE
users input in the variable guests.
17. Ensuring data security: Primary function of a database system?
18. PHP: Which Programming language is interpreted?
19. Prevent conflicts between concurrent transactions: What must a database system do when
processing transactions?
20. Determine the inputs and outputs: 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?
21. Use testing to ensure the algorithm's reliability: 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?
22. n = 0
For i in range(550, 881):
n = n + i: Find sum of all integers from 550 to 880, inclusive, and then store result in the variable n.
23. Difference: Select rows that only appear in one of two tables.
24. Compiled languages require a greater effort to edit.: Which statement describes how
compiled and interpreted languages differ?
25. programer: Person develops applications that utilize the database
26. Provide guiding decision-making principles: How to algorithms affect daily life?
27. Data Query Language (DQL): Includes the SELECT statement
28. Validate the cause of a problem: Purpose of hypothesis testing?
questions and answers.
1. Transaction Manager: What is the part of a database that prevents conflicts among concurrent requests?
2. Spatial: Stores geometric info, such as polygons
3. Test changes iteratively: What should be done to avoid introducing new problems when troubleshoot- ing?
4. The log: What is the part of a database that stores information about updates, removals, and insertions that have been
processed?
5. Verify that there are no new problems: Which strategy represents a best practice for evaluating a possible
solution in the troubleshooting process?
6. They ensure that activities are performed in an organized way.: What is a way in
which algorithms help people perform daily tasks?
7. 1. Predictability and reliability
2. Guiding us through many tasks and endeavors
3. Are deeply ingrained in cultural norms, traditions, and societal expecta-
tions.
4. Can be understood as a step-by-step procedures or sequences of tasks.
Ex: recipe, driving directions, doing laundry: Algorithms in a daily life
8. 1. understand the problem (break into smaller parts—>inputs, outputs,
constraints)
2. Choose the right algorithm
3. Use pseudocode
4. Modularity your code
5. Handle Edge cases
6. Optimize for readability
7. Test and validate
8. Optimize for performance
9. Document your algorithm
10. Iterate and Refine: Algorithm best practices
9. The catalog: What is the name of the architectural component of a database that contains a directory of tables,
columns, indices, and other objects?
, 10. Scripting languages represent a subgroup of programming languages: What is
the relationship between programming and scripting languages?
11. Join: compare related columns of two tables to combine them.
12. Collaborate with team members: Which action is a best practice for resolving issues during the
troubleshooting process?
13. represents a template for the creation of an object.: Which purpose does a class have in
Python?
14. Data Definition Language: Includes the CREATE statement
15. Product: List all combinations of rows of two tables
16. Guests = input("How many guests?"): Display message "How many guests?" In python and STORE
users input in the variable guests.
17. Ensuring data security: Primary function of a database system?
18. PHP: Which Programming language is interpreted?
19. Prevent conflicts between concurrent transactions: What must a database system do when
processing transactions?
20. Determine the inputs and outputs: 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?
21. Use testing to ensure the algorithm's reliability: 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?
22. n = 0
For i in range(550, 881):
n = n + i: Find sum of all integers from 550 to 880, inclusive, and then store result in the variable n.
23. Difference: Select rows that only appear in one of two tables.
24. Compiled languages require a greater effort to edit.: Which statement describes how
compiled and interpreted languages differ?
25. programer: Person develops applications that utilize the database
26. Provide guiding decision-making principles: How to algorithms affect daily life?
27. Data Query Language (DQL): Includes the SELECT statement
28. Validate the cause of a problem: Purpose of hypothesis testing?
