DATA PROCESSING FIRST TERM EXAMINATION SS 2
Examination malpractices may lead to a repeat of the subject or suspensions don’t be involved.
SUBJECT: DATA PROCESSING TIME: 2HRS
CLASS: SS 2
SS 2
DATA PROCESSING
FIRST TERM EXAMINATION
OBJECTIVES
1. In a database data is organized into simple (a) tables (b) rows (c) columns (d) type
2. A data model is a ___ representation of the data structure that are required by a database. (a) logical (b) conceptual (c) physical (d) dynamic
3. The following is not a step of design process: (a) planning logical design (c) survey( d) implementation
4. In a database the data is stored in___ (a) file system (b) database structure (c) sequential files
(d) flat files
5. A table design consist of how many fields?(a) one field (b) two field (c) three
6. In a database data is organized into simple (a) tables (b) rows (c) columns (d) type
7. A data model is a ___ representation of the data structure that are required by a
database. (a) logical (b) conceptual (c) physical (d) dynamic
8. The following is not a step of design process: (a) planning logical design (c) survey
(d) implementation
9. Creating a Query, choose the following from New Query dialog box. (a) creating
query wizard (b) design view (c) simple query wizard
(d) none of the above
10. To select all fields to be added to a generated form click
(a) >> (b) < (c) > (d) <<
11. To create a new table in design view choose the following menu item:
(a) Table ; New table
(b) View ; New table
(c) Insert ; New table
(d) All of the above
12. ______ is not an option in database view
(a) table
(b) query
(c) form view
(d) none of the above
13. _______ is an option in database view to add, edit field and objects
Select Query menu item to create a new select query. (a) Query > New Query
(b) View &gt; New Query
(c) Table &gt; New Query
(d) All of the above
14. To create a new table in design view choose the following menu item:
(a) Table ; New table
(b) View ; New table
(c) Insert ; New table
(d;gt; New Query
(c) Table &gt; New Query
(d) All of the above
14. To create a new table in design view choose the following menu item:
(a) Table ; New table
(b) View ; New table
(c) Insert ; New table
(d) All of the above
15. Foreign key is a field in a relational table that matches a ___ of another table.
(a) candidate key (b) row (c) field (d) none of the above
16. Each value of the primary key uniquely identifies one ___ of the table. (a) column
(b) row (c) field (d) none of the above
17. The ___ the normal form applicable to a table, the less vulnerable it is to
inconsistencies and anomalies. (a) better (b) lower (c) higher (d) none of the above
18. The ___ provide us with a means of organizing and structuring the data.
19. A set of tools and procedures for applying the tools that specifies the notation used within the organization is called ______ .
(a) database (b) database management system (c) database design (d) none of the above
20. To create a new table in design view choose the following menu item:
(a) Table ; New table
(b) View ; New table
(c) Insert ; New table
(d) All of the above
21. 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
22. ______ is not an entity type.
23. ______ is not a relationship type.
24. A database can be represented as an ERD (Entity Relationship Diagram). True/False
25. Select Query menu item to create a new select query. (a) Query ; New Query
(b) View ; New Query
(c) Table ; New Query
(d) All of the above
26. A table has two part
(a) header and footer (b) header and data area
(c) data area and record (d); none of the above
27. The date format for a query is:
Column name : Date /
(a) MM/DD (b) DD/MM (c) DD-MM (d) none of the above
28. An ERD is a diagram that shows all the entities, relationships and attributes in a database system.
True/false
29. To define or create an attribute we must first define a
table. True/False
30. To define or create an attribute we must first define a table and relationship. True/false
THEORY :
1. What are the example of standard data model
2. Explain standard data model
3. What are the steps of designing data model
4. What is primary key?
5. What is the use of foreign keys?
6. What are candidate keys?
.7. Define Query.
8. What elements can we break SELECT statement into?
9. Differentiate between The WHERE Clause and The ORDER BY Clause
10.
What are entities?
11. What are attributes?
12. What are associative entities?
