National Examination Paper:

BACK-END DEVELOPMENT AND

DATABASE DEVELOPMENT

Level: L5

MOCK FOR THE 2024/2025 NATIONAL

EXAMINATIONS

QUESTION PAPER
YI
TRADE: SOFTWARE DEVELOPMENT
EN
CANDIDATE NAMES:
IS

…………………………………………………………………………….
/G

INDEX NUMBER:
………………………………………………………………………………….
TG

DURATION: 3 HOURS
ES

INSTRUCTIONS TO CANDIDATES:

1. Read and understand all instructions before answering.

2. For multiple-choice questions, choose only one correct answer and clearly
circle the letter or number.
3. Erasing or altering answers is strictly prohibited and will lead to zero mark
for the affected question.
4. Use only blue or black ink pens (no pencils or colored pens)

May 2025

MOCK for the 2024/2025 National Examinations (Questionnaire) Page 1 of 6

Downloaded by NDAHIRIWE MUKE Fidele on Thu, 29 May 2025 14:20:19 CAT

ATTEMP ALL QUESTIONS

01. Which of the following is a backend programming (4Marks)

language?
A) HTML
B) Python
C) CSS
D) JavaScript

02. Answer by True(T) or False(F): (4Marks)

A database management system (DBMS) helps manage a

database efficiently.

03. Which of the following is an example of a NoSQL (4Marks)

YI
database?
A) PostgreSQL EN
B) MongoDB
C) MySQL
D) Oracle
IS

04. Which of the following is NOT a type of SQL query? (4Marks)

/G

A) SELECT
B) DELETE
C) POST
TG

D) INSERT

05. Which of the following HTTP methods is used to send (4Marks)

ES

data to the server to create a new resource?

A) POST
B) GET
C) PUT
D) DELETE
06. Which of the following is the primary function of a (4 Marks)
backend server?
A) Rendering web pages for the client
B) Processing business logic and handling data requests
C) Managing user interface components
D) Handling CSS styles
07. Match the following backend technologies/tools to their (8 Marks)
corresponding description: (2 marks each)

MOCK for the 2024/2025 National Examinations (Questionnaire) Page 2 of 6

Downloaded by NDAHIRIWE MUKE Fidele on Thu, 29 May 2025 14:20:19 CAT

 Back-End Description
technologies/tools

1. A framework for
1. API building web
applications in Node.js
B. A NoSQL database used
2. SQL Database to store JSON-like
documents

C.A tool used to structure

3. Express.js
and query relational data

D.A method for

communication between
4. MongoDB
different software
applications

YI
08. You are tasked with creating a simple RESTful API in (4Marks)
EN
Node.js to manage user information. Which method
would you use to create a new user in the database?
A) app.get('/users', function(req, res) {})
IS

B) app.post('/users', function(req, res) {})

/G

C) app.put('/users', function(req, res) {})

D) app.delete('/users', function(req, res) {})

09. Which of the following commands would you use to fetch (5 Marks)
TG

all the records from a user’s table in a SQL database?

A) SELECT * FROM users
ES

B) SELECT users FROM *

C) FETCH * FROM users
D) RETRIEVE * FROM users

10. In a Python backend, how would you connect to a (5 Marks)

PostgreSQL database?
A) Using the sqlite3 library
B) Using the psycopg2 library
C) Using the mysql-connector module
D) Using the pymongo library

11. You need to update an existing record in a database (5 Marks)

using SQL. Which command would you use?
A) INSERT INTO
B) UPDATE

MOCK for the 2024/2025 National Examinations (Questionnaire) Page 3 of 6

Downloaded by NDAHIRIWE MUKE Fidele on Thu, 29 May 2025 14:20:19 CAT

 C) SELECT
D) DELETE FROM

12. In a situation where your database queries are taking too (5 Marks)
long, which of the following would be the first step to
investigate?
A) Database schema design
B) The physical memory of the server
C) The database index usage
D) Server uptime

13. A backend API fails to return the expected results. Upon (5 Marks)
investigation, you discover that the request is not being
parsed correctly. What should you check first?
A) Check the server logs for errors
B) Validate the request headers

YI
C) Ensure the database connection is successful
D) Verify the client-side code
EN
14. Your backend application is experiencing a bottleneck (5 Marks)
during peak traffic times. Which of the following could
IS

help improve performance?

A) Increase the number of database replicas
/G

B) Decrease the number of application servers

C) Move the database to a more expensive cloud provider
D) Use more synchronous operations in the code
TG

15. What does the array_merge() function do? (5 Marks)

a) Deletes duplicate values
ES

b) Sorts an array
c) Combines two or more arrays
d) Filters array elements

16. How do you declare a static method in a PHP class? (5 Marks)

a) static function methodName() { ... }

b) public static function methodName() { ... }

c) function static methodName() { ... }

d) static public function methodName() { ... }

17. Which is a key advantage of using stored procedures? (5 Marks)

A) Reduced database security
B) Increased network traffic
C) Encapsulation of business logic and reduced code

MOCK for the 2024/2025 National Examinations (Questionnaire) Page 4 of 6

Downloaded by NDAHIRIWE MUKE Fidele on Thu, 29 May 2025 14:20:19 CAT

 duplication
D) Slower query execution

18. Which tool allows developers to embed native (5 Marks)

Android/iOS components directly into Flutter apps?
A) Platform Channels
B) JavaScript Bridge
C) React Native Modules
D) Codemagic

19. You are evaluating whether to use a relational or a (5 Marks)

NoSQL database for an application.

Which factor is most critical in making your decision?

A) The data structure and relationships between entities
B) The number of queries per second
C) The number of tables in the database

YI
D) The operating system being used EN
20. You are designing a simple RESTful API route in Node.js (5 Marks)
using Express to update a user's profile.
IS

Which of the following code snippets is correct?

A)
/G

app.put('/users/:id', (req, res) => {

const userId = req.params.id;

TG

// Update user profile logic here

ES

res.send('User profile updated');

});

B)

app.get('/users/:id', (req, res) => {

const userId = req.params.id;

// Get user profile logic here

res.send('User profile details');

});

C)

MOCK for the 2024/2025 National Examinations (Questionnaire) Page 5 of 6

Downloaded by NDAHIRIWE MUKE Fidele on Thu, 29 May 2025 14:20:19 CAT

 app.delete('/users/:id', (req, res) => {

const userId = req.params.id;

// Delete user profile logic here

res.send('User profile deleted');

});

D)

app.post('/users', (req, res) => {

// Create new user profile logic here

res.send('New user profile created');

});

YI
21. You need to create a database schema for a blogging EN (4Marks)
application where each post is written by one author but
can have multiple comments. Which type of relationship
would you use between the posts and comments tables?
IS

A) One-to-One
B) One-to-Many
/G

C) Many-to-Many
D) Many-to-One
TG

END
ES

MOCK for the 2024/2025 National Examinations (Questionnaire) Page 6 of 6

Downloaded by NDAHIRIWE MUKE Fidele on Thu, 29 May 2025 14:20:19 CAT