Occupational Code: EIS DBA4

Ministry of Education
Sector: Economic Infrastructure
Sub – Sector: Information Technology
Occupation: Database Administration
Knowledge Assessment L_IV
The assessment covers the following units of competence:
EIS DBA4 01 0811 Plan and Organize work
EIS DBA4 02 0811 Contribute to the development of strategic plan
EIS DBA4 03 0811 Assist with Policy development for client support
EIS DBA4 04 0811 Monitor and Support Data Conversion
EIS DBA4 05 0811 Apply Object-oriented programming Language Skills
EIS DBA4 06 0811 Use Advanced Structured Query Language
EIS DBA4 07 0811 Determine Suitability of Database Functionality and Scalability
EIS DBA4 08 0811 Perform Database System Test
EIS DBA4 09 0811 Monitor and Administer Database
EIS DBA4 10 0811 Identify and Resolve Database Performance Problems
EIS DBA4 11 0811 Migrate to New Technology
EIS DBA4 12 0811 Establish Quality Standards
EIS DBA4 13 0811 Develop Team and Individuals
EIS DBA4 14 0811 Utilize Specialized Communication Skills
EIS DBA4 15 0811 Manage and Maintain Small/Medium Business Operations
EIS DBA4 16 1012 Manage Continuous Improvement System

Candidate name
Registration number
Name of training provider
Name of Assessment Center

Knowledge Assessment for Data Base Administration _L_IV _V1

Occupational Code: EIS DBA4

Structure of Test
Section No of questions No of marks Suggested time
A-Multiple choice questions 21 21 30min
B-Matching Type 15 15 20min
Total 36 50min
OFFICE USE ONLY
Multiple Choice Questions /21
Matching Type /15
Final Mark /36
December 2014
Instructions
1. Write your name, Registration number, name of training provider and
Assessment center name in the space provided on Cover page of this booklet
2. You have 10 minutes reading time and opportunity to ask questions to the
Assessor
3. All written responses must be in English.
4. At the end of the examination return this book let to the assigned accredited
assessor
5. You may use the following references in this test
 Non-programmable calculators
6. Do not bring the following items into the assessment venue
 Mobile telephones
 Programmable calculators
 Written notes
SECTION A – MULTIPLE-CHOICE QUESTIONS
Instructions for Section A
1. There are twenty one [21] questions in this section.
2. Select the best answer and encircle the letter
3. If you wish to change an answer, place an X mark on the letter you have
encircled and then circle the letter of your preferred answer.
4. A correct answer scores 1, an incorrect answer scores 0.No marks will be given
for a question if more than one answer is supplied

Knowledge Assessment for Data Base Administration _L_IV _V1

Occupational Code: EIS DBA4

1. Suppose you are a database administrator of the North wind Company. The
company needs to prepare database protection policy. The company forms a
committee for this purpose and you are a member of this committee .Which one of
the following is not your role in this policy formulation process?

A. Understand all employee behavior of the company

B. Understand day to day activity of the company
C. Understand business plan of the company
D. Understand future need of the company

2. One of the following does not force a company to migrate to new technologies?

A. The need for support from venders

B. Data growth
C. Competitive advantages
D. Data redundancy

3. You need to bring data from an Access database in to a database in SQL Server.
You want to perform the task as simply as possible. Which one of the following
options best meets the requirements?

A. Import and Export Wizard

B. Copy Database Wizard
C. Create Database Wizard
D. Create form design Wizard

4. One of the following is a task in database system testing?

A. Comparing actual results to expected results on completion of each database

system unit
B. Removing redundant records if there are any
C. Preparing the database backup before starting database system test
D. Making sure that, technical documents are prepared

Knowledge Assessment for Data Base Administration _L_IV _V1

Occupational Code: EIS DBA4

5. You have run an SQL statement that asked the DBMS to display data from a table
named USER_TABLES. The result include columns of data labeled “Table name “,
Number of Columns “and primary key.” You are looking at

A. User data
B. Metadata
C. report data
D. Indexes data

6. Which one of the following is not factor that affect work place communication

A. Personal behavior
B. Lack good governance
C. Office location
D. Motivation to work together

7. A language that expresses a computer problem as a series of objects a system

contains, the behaviors of those objects, and how the objects interact with each
other.

A. Structure -Oriented Programming Languages

B. Object-Oriented Programming Languages
C. Function-Oriented Programming Languages
D. Procedure-Oriented Programming Languages

8. One of the following is not a basic concept in Object-oriented programming

A. Polymorphism
B. Class
C. Transmission
D. Inheritance

Knowledge Assessment for Data Base Administration _L_IV _V1

Occupational Code: EIS DBA4

9. One is not considered as a core concept of Kaizen task

A. Workplace management
B. Waste elimination
C. Focus on individual performance
D. Standardization

10. Criteria that should not be considered when evaluating or assessing functionality of
database?

A. Accuracy of database
B. Reliability of database
C. Sensitivity of database
D. Consistency of database

11. The strategies in managing and maintaining small/medium business day to day
operations does not include: -

A. Developing work activities

B. Developing effective work habits
C. Adjusting work schedules as needed
D. Developing business strategy

12. Which of the following is not true about strategic plans?

A. It indicated the future business plan of organization

B. Implemented within bounded time
C. It indicate day to day activity of the organization
D. It indicated the major activity of the organization

Knowledge Assessment for Data Base Administration _L_IV _V1

Occupational Code: EIS DBA4

13. You are assigned to lead a small team in your company that manages database.
Identify the wrong statement in leading the team

A. Assign responsibilities to team members

B. Favor some individuals in your team
C. Possess necessary leadership skill
D. Understand the team role

14. One of the following is not the responsibility of database administrator

A. Control over data and program accessing data

B. Authorizing Access to the database
C. Maintenance of hardware and software component of the entire organization
D. Creating and testing backup

15. How do you prevent system privileges deletion and updating authority on PRICE and
YEAR column of the CATALOGUE table from user Girma

A. GRANT DELETE, UPDATE (price,year) ON catalogue From girma

B. ALLOW DELETE, UPDATE (price,year) ON catalogue From girma
C. REVOKE DELETE, UPDATE (price,year) ON catalogue From girma
D. DENY DELETE, UPDATE (price,year) ON catalogue From girma

16. In your data model, you have two relations associated with each other by many-to-
many relationship. How will this relationship be physically implemented in a
relational database?

A. By adding a third relation between the original two relations in order to create
two one-to-many relationships.
B. By adding the primary key of the first relation to the second relation as a
foreign key.
C. By dragging the primary key of the second table to the first table
D. By adding any key of the first table to the second table as a foreign key

Knowledge Assessment for Data Base Administration _L_IV _V1

Occupational Code: EIS DBA4

17. A statement used to create, modify, and delete database objects such as tables,
views, schemas, domains, triggers and stored procedures.

A. RDBMS
B. DML
C. DCL
D. DDL

18. Planning and organizing a given work doesn’t include:

A. Setting attainable objectives

B. Creating and manipulating database
C. Monitoring and evaluating activities
D. Scheduling activities

19. One of the following is not the task applied when converting data

A. Backing-up data before conversion

B. Documenting data rejection and errant behavior of data
C. Modifying and formatting data
D. Converting support documents

20. It is not an activity to establish quality standard specifications to maintain and

improve quality at work.

A. Developing an agreed upon specifications

B. Identifying quality requirements
C. Monitoring the effectiveness of quality assurance procedures
D. Providing services for requested department

Knowledge Assessment for Data Base Administration _L_IV _V1

Occupational Code: EIS DBA4

21. Which one of the following does not affect database performance (response time)?

A. Database design
B. Number of columns to be retrieved from tables
C. Number of concurrent users
D. Number of users with administrative access right

SECTION B – MATCHING TYPE QUESTIONS

Instructions
1. There are fifteen [15] questions in this section.
2. Match column A with column B. Select the letter of the correct answer from column
B & write your answer on the provided space in front of the number in column A
3. If you wish to change your answer place an x mark on your previous answer and
write your preferred answer
4. A correct answer scores 1, an incorrect answer scores 0. No marks will be given
for a question if more than one answer is supplied

Knowledge Assessment for Data Base Administration _L_IV _V1

 Occupational Code: EIS DBA4

Column A Column B
___1. A Column of a table which has unique value for each record A. Table
___2. Defines how data are stored in database B. COUNT
___3. It is a place holder on memory C. View
___4. The protection of data against the deliberate or accidental access D. Relationship
of unauthorized persons E. Primary Key
___5. A data element that describes entity and used to identify one F. SUM
entity from other
G. ORDER BY
___6. An association between two data objects
H. Variable
___7. Searching, Selecting, and Retrieving of actual data from personal
I. Physical level
file data bank or other file
J. Attribute
___8. Virtual table
K. Foreign key
___9. User friendly interface to allow easy entry of data in the database
L. GROUP BY
___10. Standard operation which causes sorting, merging, input/output,
and report generating M. Form
___11. SQL command used to aggregate data N. DATEADD
___12. SQL command used to sort data O. Data retrieval
___13. Aggregate function to get total number of rows in a table P. Documentation
___14. SQL function to get Date Interval Q. DATEDIFF
___15. An SQL statement used to remove table R. Data Manipulation
S. Data Security
T. DROP

Knowledge Assessment for Data Base Administration _L_IV _V1