Data Processing Ss1 - Ss3
Data Processing Ss1 - Ss3
Objectives
1. _____ means any basic fact which may be input to some processing system [a]data
[b]information [c]computer [d]input
2. ___ is the end-result of a processing system [a]information [b]data [c]output
[d]storage
3. What is the relationship between data and information? [a]input, process and output
[b]input, output [c]data, storage, output [d]process, output and input
4. _____ is an operation on computer data which involves the entering, sorting, updating
and retrieving of information using a computer. [a]Data [b]data processing [c]
processor [d]process
5. ____ is an example of data processing cycle [a]data gathering [b]data wants
[c]information [d]data
6. ___ is an example of early mechanical counting devices [a]abacus [b]phone [c]stick
[d]laptop
7. ___ is an example of early electro-mechanical counting devices [a]blaize pascal
machine [b]abacus [c]slide rule [d]phone
8. What was abacus used for? [a]addition [b]subtraction [c] A and B [d]none of the
above
9. ___ is a way of representing data in the number system [a]decimal system [b]binary
system [c]octal system [d]all of the above
10.There are ____ generations of computer [a]2 [b]4 [c]5 [d]6
11.The first generation was developed around ___ [a]1900-1940 [b]1940-1956 [c]1914-
1920 [d]1950-1954
12.What technology did the second-generation use? [a]vacuum tube [b]transistor
[c]computer [d]data
13.What technology did the first-generation use? [a]vacuum tube [b]transistor
[c]computer [d]data
14.What technology did the fifth-generation use? [a]A. I [b]vacuum [c]data [d]chips
15.Computer can be classified into how many? [a]4 [b]5 [c]6 [d]8
16.Digital computer is under classification of computer by ___ [a]size [b]generation
[c]type [d]purpose
17.General purpose computer is under classification of computer by ___[a]size
[b]generation [c]type [d]purpose
18.Super computer is under classification of computer by ___[a]size [b]generation [c]type
[d]purpose
19.___ is the process of converting information into digital format [a]Information
[b]digitalization of data [c]digital [d]data
20.There are how many technologies of different information age [a]5 [b]6 [c]8 [d]10
THEORY
Answer 4 questions out of five, Question 1 is compulsory
1. Define Data and Information
b. Define Data Processing
c. List the 6 data processing cycle
d. Show the relationship between data and information with a diagram
2. List 3 devices each of the following: (i)Early mechanical counting devices (ii)Early
electro-mechanical counting devices (iii)Early electronic counting devices
b. Draw an Abacus
Objectives
1. ___ is a system package designed to define, manipulate, retrieve and manage data
in a database [a]DBMS [b]data [c]information [d]processor
2. ____ is an example of DBMS [a]MYSQL [b]oracle [c]FileMaker [d]all of the above
3. The following are database terminologies EXCEPT [a]row [b]column [c]field [d]ball
4. What are used to design a database on a computer? [a]database [b]database
packages [c]MS [d]computer
5. ____ is an example of a database management system [a]MS-Access [b]Ms word
[c]PowerPoint [d]excel
6. _____ is an operation on computer data which involves the entering, sorting,
updating and retrieving of information using a computer. [a]Data [b]data
processing [c] processor [d]process
7. There are ____ generations of computer [a]2 [b]4 [c]5 [d]6
8. The first generation was developed around ___ [a]1900-1940 [b]1940-1956
[c]1914-1920 [d]1950-1954
9. What technology did the second-generation use? [a]vacuum tube [b]transistor
[c]computer [d]data
10.What technology did the first-generation use? [a]vacuum tube [b]transistor
[c]computer [d]data
11.What technology did the fifth-generation use? [a]A. I [b]vacuum [c]data [d]chips
12.Computer can be classified into how many? [a]4 [b]5 [c]6 [d]8
13.___ is the process of structuring and organizing data [a]data model [b]data
modelling [c]concept [d]data processing
14.There are ___ concepts of data modelling [a]4 [b]5 [c]6 [d]2
15.____is described by a data model within a given domain [a]data [b]data structure
[c]structure [d]data concept
16.There are how many approaches in data modelling? [a]3 [b]4 [c]2 [d]6
17.There are ___ types of data modelling [a]5 [b] 4 [c]6 [d]8
18._____ means any basic fact which may be input to some processing system [a]data
[b]information [c]computer [d]input
19.___ is the end-result of a processing system [a]information [b]data [c]output
[d]storage
20.What is the relationship between data and information? [a]input, process and
output [b]input, output [c]data, storage, output [d]process, output and input
THOERY
Answer 4 questions out of 5, Question 1 is compulsory
1. Define Database Management System
b. List 5 examples of DBMS
c. List 5 database terminologies
Objectives
1. ………. is a database table that has been reduced to certain fields.a) Table b) An index
c) Table model d) Network model
2. The copy of an index is always in …… form. a) duplicate b) field c) sorted d) domain
3. The …………index can take place only if the data records are sorted on the search key
field. a)unclustered b)insert c) update d) clustered
4. A …………… can contain several unclusterd indexes a) data file b) primary c) check d)
index
5. Index contain a value and ……. a)pointer b) sign c) update d) model
6. Which of the following is not a software maintenance? a) Virus b) Spyware c) Hard
disk d) Registry removal
7. The software maintenance that involves developing and deploying solutions to
problems is .……… a) corrective b) adaptive c) preventive d) perfective
8. The software maintenance that takes care of the changes that occur in software
maintenance is called ……… a) adaptive b) corrective c) perfective d)preventive
9. Disk cleaning should be done ……….. a) hourly b) daily c) weekly d) yearly
10.Patches and update are regularly released by software companies to tackle security
problems found in …………. a) programs b) hardware c) people ware d)peripheral
11.Software testing is generally performed by the ………… a) organization itself b) software
developer c) tester d) end-user
12.The minimum duration of testing required at an enterprise level is _________ hours.
a) 6–12 b) 24–36 c) 48–72 d) 72–120
13.Which of the following is not a part of system testing? a) Usability testing b)
functionality testing c) performance testing d) stress and load testing
14.The objective of acceptance testing is to ……. a) ensure compliance with functional
requirements b) assess the capabilities of the software underspecified operating
conditions c) identify discrepancies between user expectations and system
functionality d) ensure the usability of the software
15.Before releasing a software product for commercial use, it needs to undergo ………….
testing. a) alpha b) beta c) integration d) performance
16.Data models describe ……… data for storage in data management systems (a)
structured (b) unstructured (c) integer (d) alphabetic
17.Which of this is not an example of standard data model (a) ISO 10303 (b) ISO 15926 (c)
IDEAS GROUP d) Good shepherd
18.……….. key is a field in a relational table that matches a primary key of another table
(a) foreign (b) surrogate (c) primary (d) candidate
19.……………. is graphical representation of entities and their relationships to each other
(a) Entity-Relationship Diagram (b) Entity-Relationship Picture (c)Entity-Relationship
Data (d) Entity-Relationship Symbol
20.A sparse index contains one entry for each ……of records in the data file. a) page b)
table c) row d) column
THEORY
Answer all questions
1. Define Index and Database Index
b. Define Clustered and Unclustered Index