Coc theory exam for DBA Level 3

Choose the best answer

1. Which of the following should not be configure when database records

a. User need and requirement c. Complexity and duplicate of the work

b. Designer d. Visibility of the data base system

2. To run select statements and multiple duplicate what key word can use to retrieve only the
duplicate

a. Individual c. Separate
b. Duplicate d. Distant

3. Which of the following multi values attributes

a. Sex c. Emp_age
b. Id no d. Addressed

4. Publisher and title relation on will be

a. One to one c. Many to many

b. One to many d. It has not related

5. Which of the following records would addressed in creating theory having the criteria b/n1/1/99
and
a. The records b/n the data 1/1/99&&31/12/99
b. Records b/n the data 1/1/99&&31/12/99 including 1/1/99&&31/12/99
c. Records whose data equal 1/1/99&&31/12/99
d. All data except 1/1/99&&31/12/99
6. Which of the following data type

a. Ole object c. Index

b. Input mask d. Caption

7. which of the following is a data base management system

a. C++ c. Edo folder

b. Oracle d. Dram weaver

8. Which of the following is not the necessary information to be back up a data base?

a. name of the data base to view

b. back up devices where data base back up will be written

c. whether you are granting to operate the back task

9. Which of the following is memo data type?

A. N12 C. Xyz
B. $123 D. 01march 05

10. In which data base model information organized in the data base

A. Relation in the data base C. Network

B. Object oriented D. Hierarchical

11. Revoke in valves

A. Removing prevent granted permission from user account group data base
B. Removing a prevent denied permission from account group data base
C. Removing prevent granted on denied permission from role or group in the data base
D. Removing a user from a role or group
12. Which of the following is not true about primary key?

A. Primary key has no null values C. All tables must have a primary key
B. A primary key values always uniquely D. None
identified

13. 13. Which of the following is true about index?

A. Provide fast accept data in the row of C. Is applied only four char data type
the table D. The primary key of the table is
B. Import data on the row of the table automate index

14. 14. Which of the following true about view?

A. It is a base table C. It is partiality data base table

B. It is derived table D. It is a stored procedure

15. 15. Change which of the following central to normalization

A. Functional dependency C. Query

B. Foreign key D. Data

16. 16. Which statement should you use change records that criteria

A. Select C. Up date
B. Insert D. Modify

17. 17. You cannot include sub query

A. Select C. Up date
B. Insert D. Drop

18. 18. Which type of join should you use if you want to return only
A. Inner join C. Right outer join
B. Left outer join D. Full join

19. 19. Which of the following not value in communication?

A. Understanding each other C. Poor listening and mature evaluation

B. Language difference and people D. De motivation
expression

20. 20. Task measurement and evaluation are made except

A. After the task is completed C. During the accomplishment of the task

B. Before the task identified D. After the plan of the task is completed

21. 21. Which of the term reference to the degree to system are accurate and consistent?

A. Data security C. Data independency

B. Data manipulation D. Data integrity

Matching
A 9. Specified that the values in the
specified in column order should be
1. Minimize data sorted in ascending
2. The process of validity that the user 10. State in which on foreign key values
attempting connect to DB server is in a data
authorized 11. Data collection methodology
3. Data base role 12. A mechanism to restore the
4. The column or combination of database alter assailer
valued match the primary key on 13. Information about the proprieties of
unique key is these some another data
table 14. The protection of data against the
5. The process protecting against the celebrate or accident access of an
loser of data do no dise failure authorized person
maintainability a full redundant copy 15. The rules and regulation on how to
of the data on separate disk design data base
6. Data manipulation language
7. Data definition language
8. Data control language
L. Order by last name ASC
M. Referential integrity
N. Public
B
O. Foreign key
P. Order the last name
A. Renormalization ASEC
B. Grant Q. Meta data
C. Authorization R. Data security
D. Questioner S. Up date
E. Password
F. Database recovers
G. Mirroring
H. Procedure
I. Drop
J. Master data
K. Normalization

Database Administration level – 3

Practical exam level 3
Suppose you are database administrator in a company and assigned to create a database that
management the information about the company employees.

The main tasks of the project are the following

1. Create a data base named HRM using SQL server 2000 enterprise manager
2. Create the following tables in HRM data base by using the following information

Table 1: Department

Filed name Data type size

Dep ID Char 10
Dep name char 50

Table 2: Employee

Filed name Data type SIZE

EMP ID Char 50

F name Char 50

L name Char 50

Sex Char 10

DOB Data and time

Higher date Date and time

Salary numeric

Dep ID Char 10

Table 3:- Training

Filed name Data type SIZE

EMP- ID Char 10
Training ID Char 10
Title Char 10
Instructor name Char 50
Duration Char 50

1. Set DEP id for department EMP ID Employee training ID for training table as key
2. Create a relationship the 3 tables

Emp id F
name

L name
Dep id Sex
Dep name DCB Salary
Dep ID

Emp ID
Training ID
Title
INS name
Duration
3. Insert the following records in to respective tables

DEP ID DEP name

0111 Finance
0112 Human resource
0113 Information technology
0114 Planning
0115 procumbent

Emp id F name L name Sex Date of Hired date salary DEP ID

birth
E001 Abebe Mekasha M 12/4/1950 6/15/1987 4000 0111
E002 Tewodrose Sileshi M 5/27/1975 3/27/1996 3000 0113
E003 Selam Nigussie F 4/9/1986 12/5/2006 1500 0114
E004 Bekele Abera M 12/3/1967 5/13/2000 10000 0115
E005 Taye Daniel M 5/13/1980 4/6/2000 2500 0114
E006 Aster Debebe F 12/6/1981 3/8/2001 4500 0112
E007 Samson Begashaw M 12/5/1968 1/5/1995 8000 0111
E008 Meaza Birru F 3/13/1950 3/2/1970 6000 0115
E009 Almaz Bekafa F 2/71980 3/5/2000 1000 0112
E010 zelalem teshome M 2/5/1963 8/5/1983 6000 0115

Emp id Training id title Last name duration

E002 001 Accounting Neuro 2 month
E003 002 Oracle Ava 4 month
E004 003 Mgmt Emi 3 month
E005 004 Strategic planning Emi Month
1. Insert the following record in to department table by using query analyze Dept id 0116 Dep
name =marketing
2. Write SQL statement that displays records that containing Emp ID ,first name ,last name
and department name and save it by name Employs for each dept and save it by the name
salary in my document folder
3. Write SQL statement that displays the total salary of employees by for each dept and save it
by the name salary in my document folder
4. Write SQL statement that increases the salary of employs by 20% and save it by name
increment in my document
5. Write SQL that delete the record that contain zelalme from employee table and save it by
the name zelalme in my documents folder
6. Take backup HRM data base and save the backup in the MY document s folder.

ORAL QUESTION

1. How do you determining the scope of the data base?

2. What could you do if the performance of the data base is not good?
3. How could you protect your data base failure?
4. What if the user/data base user does not understand how to success and or unstudied with
the data base ?
5. What is the need of having documentation for the data base?