Great Michael’s College
1st Term Examination 2022/2023 Academic Session
Subject: Data Processing Class: SS 2
Section A: Objective Questions
Instruction: Choose the correct answer from the given options a – d.
1. The A B table
0 0 0 Octal (c) Hexadecimal (d) Binary
1 0 1
2 1 0
3 1 1
2. The number system in base 16 is known as …………….. (a) Hexadecimal
(b) Decimal (c) Octal (d) Binary
3. The following are impacts of ICT on society EXCEPT (a) faster
communication speed (b) borderless communication (c) proper use of
paper to communicate (d) effective sharing of information
4. Another name for the Fifth generation of computer is ……………….. (a)
Microprocessor (b) Transistor (c) Artificial Intelligence (d) Super
computer
5. In the approach of data modelling, ……………….. data modelling illustrates
the specific entities, attribute and relationship involved in a business
function. (a) Conceptual Data Modelling (b) Logical Data Modelling (c)
Flat Data Modelling (d) Physical Data Modelling
6. The processing of structuring and organizing data is referred to as
…………… (a) Data Structure (b) Data Organization (c) Data Manipulation
(d) Data Modelling
7. The major concept for data modelling is to …………… (a) translate simple
system design to a complex representation of data (b) translate
complex system design to a simple representation of data (c) translate
simple system design to a simple representation of data (d) translate
complex system design to a complex representation of data
8. The term “Data Model” refers to two different things: data organization
and ……………. (a) data model (b) data processing (c) data structure (d)
data organization
9. The following are unstructured data EXCEPT (a) video (b) email
messages (c) picture (d) database
10. The Flat Model can also be referred to as ………….. (a) horizontal model
(b) table model (c) vertical model (d) smooth model
11. Which of these models is organized into an upside-down tree-like
structure? (a) Hierarchical model (b) Flat model (c) Network model (d)
Star Schema model
12. Another name for field type is known as ……………. (a) file type (b) name
type (c) record type (d) data type
13. Another name for unique identifier is known as ……………. (a) key (b)
data (c) field (d) record
14. ……………. is an attribute or field that can be used to identify a record in a
database table or file. (a) Data (b) Field (c) Key (d) Table
15. ……………. model organizes data using two fundamental constructs, called
records and sets. (a) Hierarchical (b) Relational (c) Network (d) Optical
16. Another name for Decimal is ………………. (a) Datum (b) Binary (c) Denary
(d) Hexadecimal
17. The octal number system has a radix of ……………… (a) 7 (b) 10 (c) 16
(d) 8
18. The conversion of 1012 to decimal is ……………….. (a) 1110 (b) 510 (c) 1710
(d) 7
19. The number system in base 8 is known as …………….. (a) Hexadecimal
(b) Decimal (c) Octal (d) Binary
20. All the following are examples of Database Management System
Packages EXCEPT ……………. (a) MS. Access (b) SPSS (c) Acrobat Reader
(d) Dbase
Section B: Theory
Instruction: Answer four (4) questions only in this section. Question 3 is
COMPULSORY
1a. Define Data modelling.
1b. What does SDLC stand for?
1c. What does DBMS stand for?
2a. Describe Data Structure.
2b. Name three (3) different approaches to data modelling.
3a. Complete the Hexadecimal table below:
A B C D
0 0 0 0 0
1 0 0 1
2 0 0
3
4
5 0
6
7 1
8
9
A 1
B
C
D 1 1
E 1 1
F 1 1
3b. Use the complete table in (3a) to convert the following to binary.
i. 4F716
ii. 6DF16
iii. AF216
iv. 9FA16
v. FF016
4a. Mention four (4) impacts of ICT on the Society.
4b. List six (6) examples of DBMS packages.
5. Mention five (5) types of data models.
