DEEPER LIFE HIGH SCHOOL

FIRST TERM EXAMINATION 2017/2018 SESSION

SUBJECT: DATA PROCESSING CLASS: SS2 TIME: 2HRS
Instruction: Answer all questions in section A and three in B (1hour 30 minutes)

SECTION A (Objective Test: Choose the option from a-d)

1. In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side
is called _______
(a) Child , Parent
(b) Parent , Child
(c) Brother , Sister
(d) Father , Son
2. In a database table, the category of information is called ____________
a. tuple
b. field
c. record
d. relation
3. This key uniquely identifies each record
a. primary key
b. key record
c. unique key
d. field name
4. In anEntity relationship in E/R diagram, the degree of relationship between entities
is denoted by____________
a. Use case diagram
b. E-R diagram
c. Crow foot
d. oval shape
5. To transform a relationship into an entity on an ERD, we use a special symbol called
an (a) Entity
(b) Attribute
(c) associative entity
(d) none of the above
6. The table below is in First Normal Form:

Person Favourite Colour

Ram Purple
Ram Red
John Green
John Yellow
John Red
(a)True (b) False (c) None of the above (d) all of the above

7. In a database, the simplest mode of organization Is

(a) rows
(b) types
(c) column
(d) table
8. Which of the following is a type of Query option in ACCESS
(a) static
(b) continuous
(c) detailed
(d) Crosstab
9. The default object in a database used for data entry is
(a) data sheet
(b) query
(c) forms
(d) report
10. Which of the field is suitable for use as primary key?
(a) Name
(b) E-mail
(c) School fees
(d) Age
11. In table design which field data type is used for date of Birth?
(a) text
(b) number
(c) date/time
(d) currency
12. One of the significance of data model is
(a) volatility
(b) reusability
(c) rigidity
(d) all of the above
13. The size of a field with Number data type cannot be
a. 2
b. 4
c. 8
d. 16
14. In which of the following can many entity instances of one type be related to many
entity instances of another type?
A. One-to-One Relationship
B. One-to-Many Relationship
C. Many-to-Many Relationship
D. Composite Relationship
15. The printed listings of database data is
(a) forms
(b) queries
(c) reports
(d) tables
16. To highlight all fields to be added to a generated form, click
(a) <<
(b) <
(c) >
(d) >>
17. Which field is most suitable to be the key field of a students’ performance record
system in a school?
(a) Classroom number
(b) Date of birth.
(c) Entry number of birth.
(d)Students’ admission number
18. A data model is a ___ representation of the data structure that are required by
a database.
(a) logical
(b) conceptual
(c) physical
(d) dynamic
19. Foreign key is a field in a relational table that matches a ___ of another table.
(a) candidate key
(b) row
(c) field
(d) primary key
20. The ………………….. the Normal Form applicable to a table, the less vulnerable it is to
inconsistencies and anomalies.
(a) Better
(b) lower
(c) higher
(d) consistent
21. ………………..is an instruction used to retrieve data from the database in a specified
format
(a) Form
(b) Report
(c) Query
(d) Table
22. The benefits of data modeling includes the following except
(a) clearer scope
(b) faster performance
(c) fewer application errors
(d) unmanaged risk
23. Which of the following represents the relationship between a set of values?
(a) Column
(b) Field
(c) Query
(d) Row
24. The following are examples of DBMS packages except (a) Access (b) Dbase (c) Excel
(d) FoxPro
25. The feature of database that allows accessibility of certain records is called…………….
(a) form
(b) keys
(c) queries
(d) reports
26. The elements of a SELECT statement include the following except
(a) SELECT
(b) FROM
(c) WITH
(d) WHERE
27. Which of the following is not a database object?
(a) Forms
(b) Formulae
(c) Queries
(d) Tables
28. Another name for field
(a) tables
(b) Attribute
(c) rows
(d) records
29. A/An ………..database management system distributed data processing tasks
between workstation and network server
(a) client server
(b) E-R model
(c) hierarchical
(d) relational
30. The conceptual representation of the data structure that are required by a database
is known as
(a) blue print
(b) conceptual structure
(c) data model
(d) visual mode
31. What are the types of anomalies that occurs when a database is not normalized?
(a) Deletion, upgrade and editing
(b) Editing, formatting and creation
(c) Insertion, update and deletion
(d) Update, upgrade and editing
32. The relationship between DEPARTMENT and EMPLOYEE is a
(a) One-to-one relationship
(b) One-to-many relationship
(c) Many-to-many relationship
(d) Many-to-one relationship
33. A combination of two primary keys which can individually serve as primary key is
called______
(a) Super key
(b) Primary key
(c) Candidate key
(d) Unique key
34. A primary key that consists of more than one field is called a
(a) Composite key
(b)Secondary key
(c) Group key
(d) foreign
35. Which of the following statements concerning the primary key is true?
(a) All primary key entries are unique
(b) The primary key may be null
(c) The primary key is not required for all tables
(d) The primary key data does not have to be unique.
36. In the context of a database table, the statement "A determines B" indicates that
(a) Knowing the value of attribute “A” you can not look up the value of attribute “B”
(b) You do not need to know the value of attribute “A” in order to look up the value
of attribute(c) Knowing the value of attribute “B” you can look up the value of
attribute “A”(d) Knowing the value of attribute “A" you can look up the value of
attribute “B”
37. ……………key is the key that serves as a cross-reference from a new table to the
original table
(a) Candidate
(b) Primary
(c) Foreign
(d) Composite
38. The highest number of primary key a table can have is …………
(a) 3
(b) 2
(c) 1
(d) 4
39. ……………shape is use to represent relationship among entities in an E/R diagram
(a) Rectangle
(b) Diamond
(c) Triangle
(d) Oval
40. The phenomenon of treating a relationship as an entity due to the importance of its
attributes is referred to as…………………………
(a) Relationship
(b) Associative entity
(c) Association
(d) attributes
41. Microsoft Access is a ____________ program.
(a) Database
(b) DOS
(c) graphic
(d) Presentation

Use the table below to answer questions 42-46

Choose the KEYWORDS that best complete the blank spaces

KEYWORDS USE
Example ALTER DATABASE Modifies a database
42 Creates a new database
CREATE TABLE 43
44 Deletes a database
DROP TABLE 45
46 Modifies a table

42. (a) ALTER TABLE (b)MAKE DATABASE (C) CREATE TABLE (d) CREATE DATABASE
43. (a) Creates an existing table (b) creates a new table (c) Creates a new database (d)
Creates a new form
44. (a) ALTER TABLE (b) DROP DATABASE (c) DELETE TABLE (d) DROP TABLE
45. (a) alter table (b) drop database(c) delete table (d) drop table
46. (a) ALTER TABLE (b) DROP DATABASE (c) DELETE TABLE (d) DROP TABLE

47. A database language concerned with the definition of the whole database structure
and schema is ________
a. DCL
b. DML
c. DDL
d. SQL
48. Which of the following is not a database model
a. network database model
b. relational database model
c. Object Oriented database model
d. relative database model
49. Which of the following is NOT a type of Microsoft Access database object?
a. Table
b. Form
c. Worksheets
d. Modules
50. Which of the following database object hold data?
a. Forms
b. Reports
c. Queries
d. Tables
51. A __________ enables you to view data from a table based on a specific criterion
a. Form
b. Query
c. Macro
d. Report
52. Which of the following is not a field type in Access
a. Memo
b. Hyperlink
c. OLE Object
d. Lookup Wizard
53. Which of the following database object produces the final result to present?
a. Forms
b. Reports
c. Queries
d. Tables
54. What do you mean by one to many relationships between Student and Class table?
a. One student can have many classes
b. One class may have many students
c. Many classes may have many students
d. Many students may have many classes
55. A part of database that stores only one type of data is
a. Report
b. Field
c. Query
d. Record
56. Which of the following may not be a database?
a. Data presented in table in MS Word document
b. Data entered in Excel spreadsheet
c. A presentation created in PowerPoint
d. A telephone diary
57. Collection of related records in a database is known as
a. File
b. Bench
c. Table
d. Field
58. The complete information about an entity in a database is called
a. Data
b. Information
c. Field
d. Record
59. Which of the following can be an example of a database?
a. Address book of all the suppliers of a company
b. Salary sheet of all the employees of a company
c. Records of daily sales transactions of a company
d. All of above
60. Which of the following expresses correct order?
a. Characters, Fields, Records, Tables, Files, Databases
b. Characters, Fields, Records, Tables, Database, Files
c. Databases, Tables, Files, Records, Field, Character
d. Files, Databases, Tables, Records, Fields, Characters

ESSAY
Instruction: Answer question one and any other two

1. (a) Create a relational database for your class (WITHOUT USING THE COMPUTER) of
say, six (6) students, using six reasonably suitable attributes (without repeating any
data type)
(6 marks)
From the table, state the following:
1. (b) i. The primary key

ii. Number of fields

iii. Number of records

iv. Name any field that can be used as primary key.(1 mark each=4 marks)

2a. What is a Data model? (2 marks)

2 (b) Briefly explain any three types of data model (1 mark each=3
marks)

2 (c) Define the following terms

c i. Candidate keys (1 mark)

ii. Primary key (1 mark)

iii. Foreign keys (1 mark)

iv. Entity (1 mark)

v. Attribute (1 mark)

3. Given the table below;

STUDENTDETAILS
STUDENT_ID LASTNAME FIRSTNAME CAMPUS
(a) 001 OLUGBADE
Write an SQL statement WEMIM0
to retrieve STUDENT_ID and FIRSTNAME of all theLAGOS
students from
002 UDEOJI NGOZI ENUGU
003 AJIBO VICTORIA ENUGU
004 OLANREWAJU BUNMI IBADAN
005 AGBO PRECIOUS YOLA
006 OLONITOLA TOMIWA KADUNA
007 JERRY JESSICA ENUGU
ENUGU campus (3marks)
(b) What is the primary key of the table? (1 mark)
(c) How many records are in the table? (1 mark)
3 (d) A school principal keeps the following students details in a database; Name, Address, Date
of birth, state of origin Tuition Paid and Admission Number.

(i) Name the most appropriate primary key field for the database and give reasons (2 mks)

(ii) state the most appropriate data type for the first three fields in the database (3 marks)

4. (a) List and Explain the three types of anomalies that can occur in database if it is not
normalized (4 1/2 marks)

(b) Give two examples of one to one relationship (1/2 mark)

(c) Highlight FIVE SQL keywords (5marks)