FUNDAMENTALS OF PROGRAMMING,
TROUBLESHOOTING, AND SQL DATABASES | FROM
QUESTION TO PERFECTION| STUDY WITH CONFIDENCE!
Course Code:
Course Title:
Programme:
Academic Year: 2026/2027
Duration: 2 Hours
Total Marks: 70%
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
, What is a computer program? Answer: A set of instructions that tells a computer what to do,
similar to a recipe.
What are the three basic parts of a program? Answer: Input, Process, and Output.
What is input in programming? Answer: Getting information into the program, such as typing
on a keyboard or clicking a button.
What does the process part of a program do? Answer: It performs actions on the input data,
such as calculations or changes.
What is output in programming? Answer: The results displayed or saved by the program, like
printing text on a screen.
Define an algorithm. Answer: A step-by-step plan for solving a problem, written in plain
language.
What is algorithmic thinking? Answer: Breaking down a problem into clear, simple steps to
solve it.
What is a variable in programming? Answer: A labeled box that holds information, such as a
name or a number.
What is the first step in solving a problem? Answer: Understanding what information you get
(Input).
What is the goal of an algorithm? Answer: To answer a specific question based on the input
provided.
What makes a good algorithm? Answer: It must be clear, doable, and have a defined endpoint.
What is pseudocode? Answer: Writing the steps of an algorithm in English, not in a
programming language.
What is the purpose of testing an algorithm? Answer: To ensure it works correctly with various
inputs.
What is the difference between compiled and interpreted languages? Answer: Compiled
languages translate code all at once, while interpreted languages translate code line by line.
What is Python known for? Answer: Being easy to learn, readable, and used in various
applications like data analysis and AI.
What are the main types of values in Python? Answer: Numbers (integers and floats), text
(strings), and boolean values (True/False).
What is the first step in algorithm design? Answer: Understand what you need: inputs, goals,
and outputs.
What is an example of a simple algorithm? Answer: Finding the largest number in a list.
APPHIA – Crafted with Care and Precision for Academic Excellence.
2
TROUBLESHOOTING, AND SQL DATABASES | FROM
QUESTION TO PERFECTION| STUDY WITH CONFIDENCE!
Course Code:
Course Title:
Programme:
Academic Year: 2026/2027
Duration: 2 Hours
Total Marks: 70%
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
, What is a computer program? Answer: A set of instructions that tells a computer what to do,
similar to a recipe.
What are the three basic parts of a program? Answer: Input, Process, and Output.
What is input in programming? Answer: Getting information into the program, such as typing
on a keyboard or clicking a button.
What does the process part of a program do? Answer: It performs actions on the input data,
such as calculations or changes.
What is output in programming? Answer: The results displayed or saved by the program, like
printing text on a screen.
Define an algorithm. Answer: A step-by-step plan for solving a problem, written in plain
language.
What is algorithmic thinking? Answer: Breaking down a problem into clear, simple steps to
solve it.
What is a variable in programming? Answer: A labeled box that holds information, such as a
name or a number.
What is the first step in solving a problem? Answer: Understanding what information you get
(Input).
What is the goal of an algorithm? Answer: To answer a specific question based on the input
provided.
What makes a good algorithm? Answer: It must be clear, doable, and have a defined endpoint.
What is pseudocode? Answer: Writing the steps of an algorithm in English, not in a
programming language.
What is the purpose of testing an algorithm? Answer: To ensure it works correctly with various
inputs.
What is the difference between compiled and interpreted languages? Answer: Compiled
languages translate code all at once, while interpreted languages translate code line by line.
What is Python known for? Answer: Being easy to learn, readable, and used in various
applications like data analysis and AI.
What are the main types of values in Python? Answer: Numbers (integers and floats), text
(strings), and boolean values (True/False).
What is the first step in algorithm design? Answer: Understand what you need: inputs, goals,
and outputs.
What is an example of a simple algorithm? Answer: Finding the largest number in a list.
APPHIA – Crafted with Care and Precision for Academic Excellence.
2
