FOUNDATIONS OF CODING (WGU) PRACTICE EXAM
QUESTIONS AND ANSWERS. | FROM QUESTION TO
PERFECTION| STUDY WITH CONFIDENCE!
Course Code:
Course Title:
Programme:
Academic Year: 2026/2027.
Duration: 2 Hours.
Total Marks: 100.
Candidate Instructions:
1) Write your Registration Number on every answer booklet used.
2) Answer ALL questions in Section A and ANY TWO (2) questions in Section B.
3) Read each question carefully before answering.
4) Begin each question on a new page.
5) The marks for each question are indicated in brackets.
6) This paper consists of several printed pages, including this page.
7) Ensure your copy is complete before the examination begins.
8) Unauthorized materials and communication with other candidates are not permitted.
Turn Over.
APPHIA – Crafted with Care and Precision for Academic Excellence.
1
,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?
1. Predictability and reliability
2. Guiding us through many tasks and endeavors
3. Are deeply ingrained in cultural norms, traditions, and societal expectations.
4. 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
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 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?
Scripting languages represent a subgroup of programming languages Answer: What is the
relationship between programming and scripting languages?
APPHIA – Crafted with Care and Precision for Academic Excellence.
2
, Join Answer: compare related columns of two tables to combine them.
Collaborate with team members Answer: Which action is a best practice for resolving issues
during the troubleshooting process?
represents a template for the creation of an object. Answer: Which purpose does a class have in
Python?
Data Definition Language Answer: Includes the CREATE statement
Product Answer: List all combinations of rows of two tables
Guests = input("How many guests?") Answer: Display message "How many guests?" In python
and STORE users input in the variable guests.
Ensuring data security Answer: Primary function of a database system?
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.
APPHIA – Crafted with Care and Precision for Academic Excellence.
3
QUESTIONS AND ANSWERS. | FROM QUESTION TO
PERFECTION| STUDY WITH CONFIDENCE!
Course Code:
Course Title:
Programme:
Academic Year: 2026/2027.
Duration: 2 Hours.
Total Marks: 100.
Candidate Instructions:
1) Write your Registration Number on every answer booklet used.
2) Answer ALL questions in Section A and ANY TWO (2) questions in Section B.
3) Read each question carefully before answering.
4) Begin each question on a new page.
5) The marks for each question are indicated in brackets.
6) This paper consists of several printed pages, including this page.
7) Ensure your copy is complete before the examination begins.
8) Unauthorized materials and communication with other candidates are not permitted.
Turn Over.
APPHIA – Crafted with Care and Precision for Academic Excellence.
1
,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?
1. Predictability and reliability
2. Guiding us through many tasks and endeavors
3. Are deeply ingrained in cultural norms, traditions, and societal expectations.
4. 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
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 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?
Scripting languages represent a subgroup of programming languages Answer: What is the
relationship between programming and scripting languages?
APPHIA – Crafted with Care and Precision for Academic Excellence.
2
, Join Answer: compare related columns of two tables to combine them.
Collaborate with team members Answer: Which action is a best practice for resolving issues
during the troubleshooting process?
represents a template for the creation of an object. Answer: Which purpose does a class have in
Python?
Data Definition Language Answer: Includes the CREATE statement
Product Answer: List all combinations of rows of two tables
Guests = input("How many guests?") Answer: Display message "How many guests?" In python
and STORE users input in the variable guests.
Ensuring data security Answer: Primary function of a database system?
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.
APPHIA – Crafted with Care and Precision for Academic Excellence.
3
