061006T4ICT

ICT TECHNICIAN LEVEL 5

MULANGO TECHNICAL AND VOCATIONAL COLLEGE

WRITTEN ASSESSMENT

2 HOURS

INSTRUCTIONS TO CANDIDATE

1. This paper has TWO sections A and B. Attempt questions in each section as per
instructions given in the section.
2. You are provided with a separate answer booklet.
3. Marks for each question are indicated in the brackets.
4. Do not write on the question paper
This paper consists of THREE (3) printed pages
Candidates should check the question paper to ascertain that all pages are printed
as indicated and that no questions are missing.
Candidate should answer the questions in English.
©2025 Mulango TVC TURN OVER

Page 1 of 6
 Section A (20 marks)

Answer ALL the questions in this section. Each question is 1 Mark.

1. Which type of database model organizes data into tables with rows and columns?
A. Hierarchical
B. Relational
C. NoSQL
D. D. Graph
2. ________________ is a set of one or more attributes taken collectively to uniquely identify a record.
A. Primary Key
B. Foreign Key
C. Supper Key
D. Candidate Key
3. What is a table in a database?
A. A Visual representation of the database structure
B. A Collection of related records organized in rows and columns
C. A backup copy of the entire database
D. A query is used to retrieve data.
4. Select the relationship that exists between two tables in a relational database when a record in the 1 st
table can be related to many records in the 2 table, but each record in the 2nd table is related to only
one record in the 1st table.
A. One-to-one
B. one-to-many
C. many-to-one
D. many-to-many
5. When creating a new table, what is the purpose of the PRIMARY KEY constraint?
A. It specifies the table’s name
B. It enforces unique values in a specific column and identifies a record
C. It sets a default value for all records
D. It defines a foreign key relationship

Page 2 of 6
6. What type of data can be stored in the database?
A. Image oriented data
B. Text, Files containing data
C. Data in the form of audio or video
D. All the above
7. What is the primary goal of database testing?
A. To test the user interface of a database application
B. To ensure data consistency, accuracy, and reliability in a database
C. To evaluate the network speed of a database server
D. To validate the database design only
8. Which of the following is not a common method for testing the performance of a database?
A. Load testing
B. Stress Testing
C. Usability testing
D. Scalability testing
9. Mary is to retrieve data from the student's database. What SQL statement can she use to get her
results?
A. SELECT
B. PRINT
C. DISPLAY
D. OUTPUT
10. In a relationship database management system, what is the purpose of the “DESC” command?
A. To describe how to delete a database object
B. To describe the structure of a table or database object
C. To insert data into a table
D. To modify the schema of a table
11. Choose the term that describes the smallest unit of data in a relational database.
A. Table
B. Record
C. Field

Page 3 of 6
 D. Database Schema
12. When setting up a database you are required to define the data types for column. What is the primary
purpose for doing so?
A. To limit the amount of data that can be stored in a column
B. To specify how data is stored and interpreted
C. To define the primary key of a table
D. To create a relationship between tables
13. In a NoSQL database model, which type is designed for high-speed data retrieval and querying?
A. document-oriented
B. Key-value
C. Column-family D. Graphical
14. Which component of a DBMS is responsible for interpreting and executing SQL queries?
A. Query optimizer
B. Database Engine
C. Data dictionary
D. Query Designer
15. What does the term “SQL’ stand for in the context of database management?
A. Structured Query Language
B. Sequential Query Logic
C. Secure Query Layer
D. System Query Link
16. Select the primary purpose of a "VIEW" in a database.
A. To store data in a structured format
B. To generate reports of business analysis
C. To provide a virtual table based on the results of an SQL query
D. To create backup copies of the database
17. ICT students were given the four processes below during their database system lessons. Choose
which one is not the utility of DBMS.
i) Backup ii) loading iii) Process organization iv) File organization
A. i, ii, and iv only
B. i, ii, and iii only

Page 4 of 6
 C. i, iii, and iv only
D. All (i, ii, iii, and iv)
18. The relationship between ________________ is called parent-child relationship.
A. Forms
B. Record type
C. Filtered type
D. Data type.
19. Queries are special views of data in a _________________
A. Table
B. Record
C. Forms
D. Report
20. Shown below are the data processing steps. Select the odd one out.
A. Validation
B. Collection
C. Verification
D. Computation

Page 5 of 6
 Section B (40 marks)
Answer any Two Questions in this section

21. a) Database systems employ a variety of data model, each with a distinct function and a
requirement that is met by a different organization. Describe FIVE possible model kinds. (10
Marks)
b) Define the below terms as used in database systems.
i. Relationship (2 Marks)
ii. Entity (2 Marks)
iii. Query (2 Marks)
iv. Form (2 Marks)
v. Table (2 Marks)

22. a) Explain four factors considered when choosing the type of database software to adopt.
(8 Marks)
b) The ACID properties of data transactions provide a mechanism to ensure the correctness
and consistency of data in a database. Explain each of these four properties. (8 Marks)

c) Data Definition Language is used to bring objects into existence. Discuss two database objects.
(4 Marks)

24. a) Discuss five types of database security. (10 Marks)

THIS IS THE LAST PRINTED PAGE

Page 6 of 6