DATA PROCESSING FIRST TERM EXAMINATION SS 3
FIRST TERM
Examination malpractices may lead to a repeat of the subject or suspensions don’t be involved.
SUBJECT:
DATA PROCESSING
TIME ALLOWED: 2HRS
CLASS: S.S 3
INSTRUCTION: Answer five questions in all, one question from section A and any four questions from section B.
Note: You are reminded of the importance of clarity of expression and orderly presentation of relevant materials.
Note: All questions carry equal marks.
FIRST TERM EXAMINATION SS 3 DATA PROCESSING
INSTRUCTIONS: ANSWER THE FOLLOWING QUESTIONS BY PICKING THE RIGHT ANSWER FROM THE GIVEN ALTERNATIVES
PART A : 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
7. Which of the following is not a software maintenance? a) Virus b) Spyware c) Hard disk d) Registry removal
8. The software maintenance that involves developing and deploying solutions to problems is .……… a) corrective b) adaptive c) preventive d) perfective
9. The software maintenance that takes care of the changes that occur in software maintenance is called ……… a) adaptive b) corrective c) perfective d) preventive
10. Disk cleaning should be done ……….. a) hourly b) daily c) weekly d) yearly
11. Patches and update are regularly released by software companies to tackle security problems found in …………. a) programs b) hardware c) people ware d) peripheral
15 . Software testing is generally performed by the ………… a) organization itself b) software developer c) tester d) end-user
13. The minimum duration of testing required at an enterprise level is _________ hours.
a) 6–12 b) 24–36 c) 48–72 d) 72–120
14. 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
15. The objective of acceptance testing is to ……. a) ensure compliance with functional requirements b) assess the capabilities of the software under specified operating conditions c) identify discrepancies between user expectations and system functionality d) ensure the usability of the software
16. Before releasing a software product for commercial use, it needs to undergo …………. testing.
a) alpha b) beta c) integration d) performance
17. Data models describe ……… data for storage in data management systems (a) structured (b) unstructured (c) integer (d) alphabetic
18. Which of this is not an example of standard data model (a) ISO 10303 (b) ISO 15926 (c) IDEAS GROUP d) Good shepherd
19. ……….. key is a field in a relational table that matches a primary key of another table (a) foreign (b) surrogate (c) primary (d) candidate
20. ……………. 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
21. A roof covers a building describes …………relationship (a) one-to-one (b) one-to-many (c) many-to-many(d) none of the above
22. ……… is a relationship that have a one-to-one (1:1) cardinality ratio (a) many to many (b) one to very many (c) many to zero (d) few to none
23. ……….. is an entity type which has a non-null primary key and participate in a many-to-many relationship (a) Member (b) Address (c) Student (d) Teacher
24. The cardinality ratio indicates the maximum number of ……………… (a) one cardinals observed in an entities set (b) zero or more (c) one or more (d) none of the above
25. …………….. changes in a data model are accomplished by adding new attributes and relationships to existing entity types (a) minor(b) major(c) trivial d) none of these
26. ………. is an index in which the search key contains some candidate key. a) Unique index b) An index c) composite d) sparse index
27. …… can be created on a non- key attribute. a) primary index b) dense index c) secondary index d) sparse index
28. A sparse index contains one entry for each ……of records in the data file. a) page b) table c) row d) column
29. ………is the one in which not all fields in the Search key are bound to constant. a) dense index b) composite search key c) secondary index d) range query
30. ……. is when the search key for an index contain several fields. a) primary index b) composite search key c) secondary index d) unique index
THEORY
1. List and explain the four software maintenance.
2. State four benefits of software maintenance
3. State three routine computer maintenance
4. Differentiate between clustered index and unclustered index.
5. State two reasons why clustered index is expensive to maintain.Y
6. (a) Define the following terms (i) Entity (ii) Attribute (iii) Relationship
(b) What is cardinality?
(c) Mention and explain three types of relationship in ERD with one example each
7. (a) Define the following (i) Primary key (ii) Foreign key (iii) Composite primary key
(b) Explain the term Normal Form.
(c) Design a database of your choice indicating the primary key and the foreign key
8. Create a student table with the following fields: name, age, and scores of 5 records. Create an index using a composite keys name and age. (show the table and SQL statements)
9. Discuss the different types of indexing.
10. Differentiate between a unique index and a range query.