Data Processing Objective Questions For SS1, SS2, SS3
Data Processing Objective Questions For SS1, SS2, SS3
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
11. In table design which field data type is used for date of Birth?
(a) text
(b) number
(c) date/time
(d) currency
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
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
23. Which of the following represents the relationship between a set of values?
(a) Column
(b) Field
(c) Query
(d) Row
25. The feature of database that allows accessibility of certain records is called…………….
(a) form
(b) keys
(c) queries
(d) reports
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)
(a) Write an SQL statement to retrieve STUDENT_ID and FIRSTNAME of all the students
from ENUGU campus (3marks)
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 mks)
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 (5mks)
Data Processing
Exam Question for SS1-3
To get the complete exam question papers for the subject and any of the classes
concern, then continue reading
1. MAKE A CALL.
Call or Whatsapp us on 08051311885 for cost and account number to make
payment and how to received your Ms-Word/PDF Copy
2. MODE OF PAYMENT.
Mobile Transfer, POS or Direct Bank Deposit.
3. AFTER PAYMENT.
Send us the following
Depositor Name:
Name of Product Paid for:
Valid email address.
4. DELIVERY ASSURANCE.
We will deliver the past question to you, 10 minutes after confirmation of payment
to the email address you will send to us.
Also available for download are other senior secondary school exam questions