Database Administration Level III COC Theory Model Exam for

Both Regular and Extension TRAINEE’S

Name: _____________________________________
I. Choose the Best Answer from the given Alternatives:
1. Which one of the ff should not be consider when a database design?
A. User needs and requirement
B. The designer interest
C. The complexity and simplicity of the work
D. Feasibility of the data base system.
2. You run as select statement and multiple duplication of what key word can you use to retrieve
only the non-duplicate records?

A. Duplicated
B. Individual
C. Separate
D. Distinct
3. Following is a simple SQL quiz that beginners may find interesting. Study the 3 tables below,
answer the following questions.

What is the result of: "Select Employee.EmpID, Employee.FirstName,

HoursWorked.NormalHours *2 from Employee inner join HoursWorked on
Employee.EmpID = HoursWorked.EmpID where Employee.EmpID = 10001"
A. 10001 John 40
B. 10001 John 80
C. 10001 John 42
D. 10001 John 5
E. 10001 80

E. Which of the ff is multi-valued attribute

A. Sex
B. emp age

Prepared by HaymanotYihune Page 1 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

C. Id number
D. Address

4. Publisher and titles table relation will be.

A. One---to---one relation
F. One---to---many relation
G. Many---to---many relation
H. Has no relation

5. Which of the ff records would be addressed in creating query having the criteria between 1/1/99
and 31/12/99?
A. Record between the actual 1/1/99 & 31/12/99 includes 1/1/99 & 31/12/99
B. Record between the actual 1/1/99 & 31/12/99 Excluding 1/1/99 & 31/12/99
C. Record which data equal 1/1/99 & 31/12/99
D. All data excepts 1/1/99 & 31/12/99
6. One Of The F.F Is Not SQL server system database component
A. Master database
B. Model database
C. Conventional database
D. Tmpdb
7. Which of the following is data type?

A. Ole-Object
B. Input mask
C. Index
D. Caption

8. Which of the following is a database management system?

A.C++
B. Oracle
C. Adobe Reader
D. Dreamweaver

9. Which one of the following is not necessary information to backup database type?
A. Name of the database to back-up
B. Back-up devices where the database backup will be written
C. Whether you are generated operate the backup task
D. Model of the database
10. Which of the following is memo data type?

A. N12
Prepared by HaymanotYihune Page 2 of 34
 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

B. &123
C. ZYX
D. 01-march -05

11. In which database model is information organized in tables.

A. Relational Database
B. Object Objected
C. Network
D. Hierarchical

12. Revoking Involves

A. Removing a previously granted permission for user account group in a database
B. Removing a previously denied permission for user account group in a database
C. Removing a previously granted or denied permission from a role or group in database
D. Removing User from a role or group
13. What is an index?
A. An index is a special way to join 2 or more tables
B. An index is the same as alias
C. An index is a database table attribute, which speeds-up data search within a table
14. Which of the following is not true about primary key?
A. Primary key don’t allow null values
B. No two rows can have the same primary key values
C. A primary key values uniquely identified a values
D. All table must have a primary key
15. Which of the following is true?
A. TRUNCATE TABLE deletes table from a database
B. TRUNCATE TABLE has to be used along with a WHERE clause
C. TRUNCATE TABLE is identical to DELETE statement without WHERE clause and
both remove all rows in a table
16. Which of the following is not true about index
A. Provides fast access the data in the row of database
B. Enforces uniqueness on the row in table
C. Is applied only for char data type
D. The primary key of the table is automatically index
17. Which of the following is true about a view

A. It is a base table
B. It is derived attribute
C. It is apply a derived & a base table
D. It is stored procedures

Prepared by HaymanotYihune Page 3 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

18. Which of the following are central to normalization

A. Functional dependency
B. Foreign key
C. Query
D. Data type
19. Which of the following not modular programming benefits
A. Less code has to be written
B. allows many programmers to collaborate on the same application
C. Code is short, simple and easy to understand
D. different developers can’t work in parallel

20. Which statement should use to change record is that criteria

A. Update
B. Select
C. Insert
D. Query
21. Of the following entity integrity constraint except
A. Uniqueness
B. Primary key
C. Foreign key
D. Identity
22. You cannot include sub queries in

A. Select
B. Insert
C. Update
D. Drop
23. Which of the following is TRUE about Primary Key?
A. A column that is defined as Primary Key value can be same value more than once
B. A column that is defined as Primary Key cannot contain NULL value
C. Primary key should be long type only

24. Which type of Join should you use .If you want to return only matches?

A. Inner Jain
B. Left Outer join
C. Right outer join
D. Full join
25. What does the following SQL command output SELECT empname from emp where empname
like 'S---';
A. This displays all empname whose empname is ending with "S"

Prepared by HaymanotYihune Page 4 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

B. This displays all empname whose empname is starting with "S"

C. This displays all empname whose empname is with four letter and ending with "S"
D. This displays all empname whose empname is with four letter and starting with “S"

26. One of the following is not barrier in communication?

A. Understanding each other
B. Frequently q differences & poor expressions
C. Poor listening & pre-mature evaluation
D. Emotionality
27. Task measurement & Evaluation are made except
A. After the task is accumulated
B. Before the task is identified
C. During the accomplishment of a task
D. After the plan of the task is completed

28. The requirements of identity property

A. It can be easily modified
B. It will enforce uniqueness
C. Used as primary key
D. It is managed its values by the server
29. Which of the following terms reforms to the degree to which systems are accurate, correct &
consistent?

A. Data Security
B. Data Manipulation
C. Data Independence
D. Data Integrity
30. A NULL value is treated as a blank or 0.
A. True
B. False
31. Which of the following data types are used in SQL?
A. LONG
B. DATE
C. CHAR
D. All the above
32. authors and the titles table relationship will be:
A. One---to---one relation
B. One---to---many relation
C. Many---to---many relation
D. Has no relation

Prepared by HaymanotYihune Page 5 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

33. Which of the following terms used to validate and improve a logical design so that it satisfies
certain constraints that avoid unnecessary duplication of data?
A. Data Security
B. Data Manipulation
C. Normalization
D. Data Integrity
34. When creating a referential constraint, which keyword(s) identifies the table and column in the
parent table?
A. Foreign key
B. References
C. Table Name
D. All
35. In order to remove the index created the SQL command used is:
A. DROP INDEX;
B. DELETE INDEX;
C. REMOVE INDEX;
D. CUT INDEX;
36. In which case we use nulls in topple of relation or table?
A. value known to exist, but unavailable
B. reduce Waste of disk space
C. Avoid Insert anomalies
D. Disallowing generating Spurious
37. ------------------------ denote derived attributes.
A. Double ellipse
B. Dashed ellipse
C. Squared ellipse
D. Ellipse with attribute name underlined
38. What type of lock will deny users any access to a table?
A. EXPLICIT
B. IMPLICIT
C. EXCLUSIVE
D. SHARED
E. READ ONLY
39. What is a collection of all entities of particular entity type in the database?
A. Entity
B. Entity type
C. Entity set
D. Attributes
40. Which normal form applies if all the determinants are prime attribute or candidate keys?
A. First normal

Prepared by HaymanotYihune Page 6 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

B. Second normal
C. Third normal
D. Boyce-Coded Normal
41. Which one is not entity type?
A. Book
B. Gender
C. Order
D. Customer
42. Flow chart return show decision that must made represent by:
A. Diamond
B. Rectangle
C. Round
D. Circle
43. Which type of constraint by default requires that a column be both unique and not null?
A. Primary key
B. Unique
C. Not NULL
D. Check
44. Method data collection in which the situation interest is watched and the relevant facts actions
and behaviors recorded.
A. Interview B. ObservationC. Survey D. Questioner

45. Assume that there is a table named R with attributes A.B.C and D and A is the primary key
(determinate ) of R than which of the following is true about full dependency.
A. (A) (B.C.D) B. (A.C) (B.D) C. (B.C) (A.D) D. (B.C.D) (A)
46. You can run a select statement and multiple duplicates of values are retrieved what key word
can you use to retrieve only the nun duplicable values.
A. Duplicate B. Individual C. distinct D. separate
47. In database modeling a set of objects with the the same property of characteristics is turned
as .
A. Entity instance B. Entity type C. relationship D. relationship instance
48. With SQL which type of join should you use want to return only matched rows.
A. Inner join B. left outer join C. write outer join D. full outer join
49. Dropping a table will remove.
A. Only the table definition but not the stored value
B. Only the permission specified for that table
C. Only the stored values but not the table definition
D. The table definition and as stored value
50. Among the following which of can be considered as composite attribute for employee.

Prepared by HaymanotYihune Page 7 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

A. Address B. salary C. ID D. sex

51. If you have two entities that have the many to many (M.N) relationships between them how do
you map then relational table.
A. You create two tables by defining the column of foreign key to the M Sided of the entity or
relationship
B. You create each individual relation of separate table and introduce a third (new)tables by
taking the primary key together of primary keys and used of foreign keys
C. You create three separate tables without defining a foreign key to the M side of side of
the relationship
D. You create two tables by defining the column of a foreign key to the N side of the entity on
relationship
52. How can you change “Bitukan” in to “Bitukan” in to “last name “column in student tables?
A. Update student set last name =”Birtukan” in to last name = “Birtukan”
B. Modify student set last name = “Birtukan” where last name =”Birtukan”
C. Update student set last name =”Birtukan” where last name” Birtukan”
D. Modify student set last name =”Birtukan”in to last name =”Birtukan”
53. There are certain package a now people to define data items places these items in particular
records combine the records designated files and then manipulate and retried the stored data
what are they called .
A. Data storage system B. batch processing system C. database management system D.
data communication package
54. When the values in one or more attributes being used as a foreign key that must exist in
another set of one or more attributes in another table you have created.
A. Domain integrity constraint C. user defined integrity constraint
B. entity integrity constraint D. relational table integrity
55. given the table bellow which normalization steps is mission
Serial No Owner Model Manufacturing Engine size

A. 2NF B. 3NF C. 1NF D. Boyce code

56. Among the following which activity helps you to determine the entities attribute and
relationships of data?
A. Conceptual database modeling C. Physical database modeling
B. Logical database modeling D. database implementation

57. In the relational model cardinally is turned as.

A. Number of type B. Number of attributes C. Number of table D. Number of constraint
58. Where dose the DBMS store the definition of data elements relationships
A. Data file B. Index C. data dictionary D. data map

Prepared by HaymanotYihune Page 8 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

59. An entity set that does not have sufficient attributes to from a primary key can be associated
as.
A. Strong entity set B. weak entity set C. simple entity set D. primary entity set
60. Which SQL how can populate training table with rows from employee table.
A. Insert in to first name , last name training from employee
B. Select first name, last name, in to employee from training
C. Insert in to first name, last name in to employee from training
D. Select first name , last name in to training from training
61. An instance relation schema R (A.B.C) has distinct values for including null values. Which of the
following is true?
A. A is candidate key B. A is non -primary key C. A is a primary key D. A is
foreign key
62. The database design that constraint multiple tables that are link to gather through matching
data store in each table is termed as.
A. Hierarchical database B. network database C. relational database D. object-oriented
database
63. In the following form of table using SQL statement
SELECT EMPLOYEE IDNO
FROM EMPLOYEESTASTICSTABLE
WHERE SALARY BETWEEN 30000 AND 50000
A. EMPLOYEEIDNO specifies name of the table
B. EMPLOYEESTATICSTICSTABLE specifies name of the column
C. EMPLOYEESTATICSTICSTABLE specifies name of the table
D. SALARY BETWEEN 30000 AND 50000 data type of column
64. Database design involves modeling the collected information at high-level of abstraction
without using a particular data model or DBMS
A. Conceptual database design
B. Logical database design
C. Physical database design
D. Database design schema
65. The requirement (s) for using identity property can be specified as :
A. It can be defined with character data types
B. Only one identity column is allowed per table
C. It can be updated
D. It does allow null values
66. Which one of the following is not true about First Normal Form (1NF)
A. There are no repeating or duplicate fields
B. Each cell contains only a single value

Prepared by HaymanotYihune Page 9 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

C. Each record is unique

D. All non-key fields depend on all components of the primary key
67. In SQL server which one of the following is a wrong statement?
A. Each entity name should be unique in the same database
B. Two attribute of an entity type can have the same name
C. Count function does not return a NULL if no rows satisfy the WHERE clause
D. IN operator allows you to specify multiple values in a WHERE clause
68. Designing a database is an interactive process that involves developing and refining a database
structure based on the information and processing requirements of your business. Which one is
the correct phase of the designing process?
A. Data analysis physical database design Logical database design physical
implementation
B. Data analysis Logical database design physical database design
physical implementation
C. physical database design Data analysis Logical database design physical
implementation
D. physical database design Logical database design Data analysis physical
implementation
69. In modular programing which statement is NOT considered as the benefit?
A. Less code has to be written
B. Codes are simple and easy to understand
C. It does NOT allows many programmers to collaborate on the same application
D. A large program can be break down in to smaller independent modules
70. During the conceptual design phase what will happen :
A. The internal components of the application are design
B. Normalization take place
C. New entities may be discovered
D. Program specifications are written
71. With SQL, how can you return all the records from a table named “EMPLOYE” sorted
descending by “First Name”?
A. Select * from EMPLOYEE ORDER First Name descend
B. Select * from EMPLOYEE ORDER by First Name desc
C. Select * from EMPLOYEE ORDER by First Name Asc
D. Select * from EMPLOYEE ORDER by First Name Ascend
72. While listing limitation of file processing system identity the wrong statement?
A. Data redundancy and inconsistency available
B. Difficult in accessing data
C. Data isolation and integrity

Prepared by HaymanotYihune Page 10 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

D. Concurrent access is possible

73. Which one of the following could NOT be considered as an entity type?
A. Student
B. Address
C. Birth date
D. course
74. during modeling your data , entity relationship is applied at
A. conceptual database
B. schema refinement
C. physical refinement
D. applications and security
75. All of the following are SQL servers system database components except?
A. Master database
B. Conventional database
C. Model database
D. Tempb database
76. Assume that there are two given table, MOTHER table and CHILDREN table under the same
database name. What will be the possible relationship between these tables?
A. One -to -many
B. One – to - one
C. Many – to –many
D. Has no relationship
77. Which one of the following is NOT a data type in SQL server?
A. ID
B. Date t/time
C. Double
D. Money
78. Identifying primary keys, which of the following is wrong statement?
A. They cannot be NULL
B. Only unique values can be used assigned to them
C. They cannot be character data type
D. They cannot be used as reference for other columns in a related table
79. which of the following is background recovery
A. Where the before –images are applied to the database
B. Where the after –images are applied to the database
C. Where the after – images and before –images are applied to the database
D. Switching to an existing copy of the database
80. The transaction log includes which of the following?

Prepared by HaymanotYihune Page 11 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

A. The before –image of record

B. The after – image of a record
C. The before and after- image of a record
D. The essential data of the record
81. In SQL, which of the following is a correct syntax to modify a table:
A. Alter table <TableName<columnNmae><datatype ><filed size><constraints >
B. ALTER TABLE ADD <columnNmae><datatype ><field size ><constraint >
C. ALTER TABLE <TableName>ADD<columnNmae>data type><field
size><constraint>
D. ALTER TABLE <TableName>DROP<columnName><data type><field size>
82. Which of the following referential integrity constraints should be enforced to specify
authorization deletion of a foreign key record when a record in the base table is deleted
A. On drop cascade
B. On delete cascade
C. On update cascade
D. On drop set null
83. All of the followings can be considered as entity integrity constraint except
A. Unique
B. Foreign key
C. Identity
D. Primary key

84. From the following which one is derived attribute?

A. Address
B. Name
C. Age
D. Nene

85. Entity found in the following except?

A. Thing
B. People
C. Location
D. All

Prepared by HaymanotYihune Page 12 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

E. None
86. Which one of the following entity?
A. Teacher
B. Book
C. Sale
D. All
87. Ato kebede is a database trainer who trains trainers the relation between a trainer and trainees
are----------.
A. One –to- many
B. many –to- One
C. One –to- one
D. many –to- many
88. Aster is a registrar head .she record new applicants for training .one day she recorded a ‘male’
trainer as ‘female’ in gender column. Immediately she wants to modify the wrong record to
male. What mechanism or syntax must take to modify that? (Not aster working on SQL).
A. Update syntax
B. Delete syntax
C. Modify syntax
D. Change syntax
89. From the above question (no,5).what language (commands ) the she has taken?
A. DDL
B. DML
C. DCL
D. TCL
90. -------------is directional movement of data to and from external entities, the process and data
stores.
A. Entity Relation Diagram
B. Data Flow Diagram
C. Class Diagram
D. Flow Chart Diagram

91. An application of printer printing process is expressed by a data structure element is.
A. Stack
B. Queue
C. Tree
D. Heap

Prepared by HaymanotYihune Page 13 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

92. Statement of data manipulation language which helps to retrieve records from your database
is --------
A. Insert statement
B. Update statement
C. Select statement
D. Modify statement
93. A database end user whose job is occasionally accessing of the database ,but she/he my need
different information is -----------------------
A. Casual end user
B. Sophisticated end user
C. Casual end user
D. Stand alone end user
94. Let your manager ,s existing database table contain the following attribute with the
corresponding data types as emp_lname=char(90),and salary int ,and the manager wants to
input the record of (‘emp001’,’abebe’,’mekonen’,2000)into his/her database table which query
statement syntax helps to reformat the table structure .
A. Alter table tale_name column column _name char(3)
B. Alter table table_name column column_name char(90)
C. Alter table table_name column column_name int
D. Alter table _name column column_name
95. A Closed ended question is a type of question which is expressed by.
A. What are unit of competencies that you will access?
B. what is your occupation?
C. What type of information do you get?
D. What are functions of CPU?
96. If you will be assigned as a database administrator for an organizations of “XYZ “company.
What will be your role in that database system or “XYZ” company?
A. Responsible for determining software resources only.
B. Involves some steps of database development
C. Authorizing access to the database
D. Responsible to oversee ,control and manage database
97. A data model is distribution of that the way of how the data will be stored in the database, but
it allows record types to have more than two parents.
A. Network data mode
B. Relational data model
C. Hierarchical data model
D. Object data model

Prepared by HaymanotYihune Page 14 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

98. FINANCIAL STATEMENT is a document which showing a business’s assets, liability, and owner s
equity or retained earnings. The related terms are------------.
A. An income statement
B. A demand supply statement
C. A cash flow statement
D. Balance sheet
99. In entity relationship diagram a derived attribute represented by
A. Doable oval
B. Bold oval
C. Dotted oval
D. Normal oval
100. Let mister” X” BORN 3 CHILDRENs from his wife, one is KG Graduated, second is level IV
graduated and the third is level V graduated. The relationship between Miter “X” and with his
level based graduated children_________.
A. One-to-one
B. One-to- many
C. Many-to-one
D. Many-to-many
101. A recursive relationship is an entity relationship diagram which is expressed by.
A. Student-to-student
B. Department-to –employee
C. Course-to-department
D. Instructor-to-student
102. A types of deviations raised to flag non-conformance identified during internal,
external, supplier or corporate audits is
A. Production deviation
B. Customer service deviation
C. Audit deviation
D. Quality improvement deviation
103. Prototyping servers to provide specifications for a real , working system, so its
advantages is
A. To reduce development time
B. Does not involves users
C. To increase development cost
D. Does not facilitate system implementation
104. Let Mr. Birhanu is professional with the job of implementing of database on secondary
storage devices. The he/ she is said to be.
A. Conceptual database designer

Prepared by HaymanotYihune Page 15 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

B. Data administrator designer

C. Logical database designer
D. Physical database designer

105. A database file holds all the log information that is used to recover the database.
A. Primary data file
B. Secondary data file
C. Log file
D. Database file group
106. A database buck up contains all data and database Meta information needed to restore
the whole database is
A. Full back up
B. Incremental back up
C. Transaction log file back up
D. Deferential back up
107. A communication type which is used when you have to provide detailed information
such as figures and fact is expressed by.
A. Oral communication
B. Body movement communication
C. Written communication
D. Gesture communication
108. If you will eat your dinner as a meat you will drink a cup of coffee and if you will eat your
lunch as fruit you will drink a cup of tea; otherwise you will never drink a cup of coffee and tea
over all. Then the correct functional dependency will be.
A. Meat is functional dependent on coffee
B. Coffee is functional dependent on fruit
C. Tea is functional dependent on meat.
D. Coffee is functional dependent on meat.
109. A database management system service that must support the implementation of
access to database administrator and users is serviced by.
A. Transaction support service
B. Authorization service
C. Recovery service
D. integrity service
110. Leadership is a process whereby an individual influences a group of individuals to
achieve a common goal. Traits of good leader set goals and have a vision of the future is
A. Honesty

Prepared by HaymanotYihune Page 16 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

B. Inspiring
C. Forward –looking
D. Intelligent

I. Match Column “A” with Column “B”

1. Sequential steps of procedures to the perform a 15. Influencing people to get things done to
specific task =O standard and quality. =N
2. Set of objects that share the same attributes .and A. Foreign key
operations =M B. Kaizen
3. Descriptions of data itself =G C. Shadow paging
4. Confirming SQL server connectivity =D D. Authentication
5. Participating entity from in ERD =E
E. Questionnaires
6. Data capturing method =F
F. Page
7. Smallest unit of data storage in MSSQL server
=J G. Data dictionary
8. A copy –on- write technique for avoiding H. Object
increasing the performance of the database in I. Enterprise integrity
logically. =C J. Tuning
9. When one attributes in table uniquely K. primary key
determines another attributer =A L. batch production
10. The candidate key which is selected to identify M. class
records of a relation uniquely.=K N. leadership
11. Additional rules which is specified by users.=I O. Algorithm
12. The term which refers to specific group of
P. Sustain
components. =L
Q. Role name
13. Change for butter =B
14. Influencing people to get things done to standard
and quality. =N R. Week entity

Prepared by HaymanotYihune Page 17 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

II. Match Column “A” with Column “B

1. Database Role =N 14. The protection of data against the deliverables or

2. The process of validating that the user accidental access of unauthorized persons.= R
attempting to connect to database server is A. De-Normalization
authorized.=C B. GRANT
3. Minimizes data redundancy in a database K C. Authentication
4. The column and combination of column which D. Questionnaires
values mach the primary key or unique key in
E. Password
the same key or under table. O
F. Database Recovery
5. The processes for protecting against the loss of
data due to disk failure have maintaining a G. Mirroring
faulty. Copy of data on separate disk =G H. Procedures
6. Data Manipulation Language(DML) S I. Drop
7. Data Definition Language (DDL) I J. Master Data
8. Data Control Language (DCL)b K. Normalization
9. Specifies that the values in the specified L. Order by Last name ASC
columns should be stored in ascending order=L M. Referential integrity
10. A state in which all foreign key values in a N. Public
database are valid=M O. Foreign key
11. Data collection Methodology =D
P. Order by last name ASCE
12. A mechanism for restoring a database after a
Q. Metadata
failure =F
13. Information about the properties of data=Q R. Data security
S. Update
15. The role and regulations on how to design Use a database=H
and

Prepared by HaymanotYihune Page 18 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

III. Match Column “A” with Column “B”

1. Algorism N A. Third normal form
2. Set of all possible values for entities=K B. SQL Union
3. Used to remove database & its object=I C. Domains
4. Relationship type=L
D. Where
5. Request for information from
E. Second normal form
database=M
6. Remove transitive dependency=A
F. Data types
7. Combine the results set=B G. Shadow paging
8. Used to specify table=O H. Create database
9. A named column of the relation=P I. Drop command
10. You need to use when you create a J. Physical database
conventional database=H K. Entity type
11. Specify search condition=D L. Diamond
12. The set of allowable/possible values for M. Select statement
attributes=C N. A process or set of rules to be followed in
13. Constraints that specify the possible
calculations or other problem-solving
values for each fields in a table=F
operations, especially by a computer.
14. A copy of write techniques= G
15. Remove partial dependency=E O. Create table
P. Attributes
Q. First normal form

Prepared by HaymanotYihune Page 19 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

IV. Match Column “A” with Column “B”

1. Arranging the activities of database system 15. Language that is used to store, retrieve, and
development lifecycle. =A access.=F
2. Identifying information gaps and proposing a A. Planning
solution for the organization.=Q
B. Arrow with a unique label
3. The process of contracting a model of the
database used in the organization=G.
C. Kaizen
4. The processing of testing and deploying the D. Data control Language(DCL)
designed database.=B E. Data Definition Language(DDL)
5. Administering and maintaining a deployed F. Data Manipulation Language(DML)
database system. =D
G. Design
6. Database system object about which information
is to be collected. =S
H. Diamond
7. Continues change of work procedures.=C I. ALTER
8. The processing is removing duplicated records in J. Double rectangle
database modeling.=O K. Ellipse
9. An SQL command that combines records in L. Entity
form two or more tables in a database.=N
10. An SQL command used to add column.=I
M. Implementation
11. In ER Diagram relationship are represented.=H N. Join
12. In ER Diagram Entities are represented.=R O. Normalization
13. In ER Diagram Attributes are represented.=K P. Operation and support
14. Language that is used to create structure of Q. Analysis
database.=E
R. Rectangle
S. Select

Prepared by HaymanotYihune Page 20 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

V. Match Column “A” with Column “B”

1. The process of periodically taking a copy of a 15. Way of sorting and organizing data in a
database and log file `of lines storage media =Q computer =P
2. Sort a result set =I A. Pseudo code
3. Value of one attributes uniquely determines the B. Implementation
values of another attributes =s C. Relationship
4. No primary key values can be null =E
D. Union
5. The number of participating entities in the
E. Entity integrity
relationship =M
6. A property of an entity or relationship =O
F. First Norman form
7. Building a working model of database system G. Drop
=R H. Data structure
8. A collection of normalized tables =N I. Order by
9. Represent a value for a column that is currently J. Entity type
un no known is not applicable for this record =L K. Second Norman form
10. The physical realization of the database and L. Null
application design =B M. Degree of relationship
11. Method used to define an algorism N. Third Norman form
12. Combine the result set of two or more select
O. Attribute
statement =D
P. Relational database
13. No partial dependency =K
14. A set of meaningful association among entities Q. Back up
=C R. Prototyping
S. Functional dependency

Prepared by HaymanotYihune Page 21 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

VI. Match Column “A” with Column “B”

1. Set of principle concerned with how data 11.Fixed width N-character string padded
is structured =C with specs as needed =Q
2. querying existing data end users and 12.A data base schema specifies by a set of
extracting data for use by application definitions expressed by a special
program = F language Fixed which n- character
3. inserting new data in to updating data in, string padded with spaces as needed =T
deleting data from existing data 13.Constraint that specify the possible
structure D value for each filed in the table =B
4. creating and monitoring users restricting 14.It specifies user views and their
access to data and monitoring the mappings to the conceptual schema =S
performance of database =J 15.Specify the mapping between to schema
5. set of principle concerned with how data =P
is operated up on
6. set of principle concerned with
determining which states are valid for
database
7. Real world interims of the constructs of
some DBMS =G
8. Blueprint for designing and creating a
physical database =H
A. VDL
9. Reduces data redundancy and
inconsistencies=N B. Data type
10.Control concurrency =O C. SDL

Prepared by HaymanotYihune Page 22 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

D. Data manipulation P. Physical data model

E. Union Q. CHARACTER (n) or CHAR
F. Select (n)
G. Entities R. Third normal form
H. Create table S. Logical data model
I. Data maintenance T. CHARACTER VARYING (n)
J. Data control or VARCHAR(n)
K. Data retrieval
L. DDL
M. Data Definition
N. A Normalized data model
O. LOCK TABLE

1. Functional dependency between non-primary key is called?

A. Transitivity dependency
B. Functional dependency
C. Partial dependency
D. Full functional dependency
2. Which one of the following is NOT benefits of using modular programming?
A. The code is stored across multiple files
B. Less code has to be written
C. Code is short , simple and easy to understand
D. The scoping of variables cannot be easily being controlled.
3. Diamond shapes in flow chart represents?
A. Decision that must be made
B. Start of process
C. Instruction
D. End of process
4. Smart draw is unique in three ways which one is not include in that?
A. Automated
B. Complete
C. Integrated
D. Not complete
5. CASE tool means?

Prepared by HaymanotYihune Page 23 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

A. Computer Aided Software Engineering Tools

B. Computer Aided System Engineering Tools
C. Computer Aim Software Engineering Tools
D. Computer Aim System Engineering Tools
6. The structure of the database itself and is used in control and maintenance of a database?
A. Template
B. Documentation
C. Data structure
D. Data dictionary
7. One is the process that involves dividing large tables into smeller that does Not accept
redundant values and defining relationship between them?
A. Normalization
B. Generalization
C. De-normalization
D. Data structure
8. The principle states that before making any changes to the database, it is necessary to face –the
log records to the stable storage?
A. Write ahead logging
B. Repeating history during redo
C. Logging changes during undone
D. Read- ahead logging
9. Client feedback can be implementing in line with the organization policies though the following
accept one?
A. Prototyping
B. Verbal feedback
C. Group decision
D. Questionnaire
10. The relationship between the instance of only entity type (or participant) is known as unary
relationship and it has degree?
A. 1
B. 2
C. 3
D. 4
11. IN E-R Diagram derive attribute are represented by
A. Ellipse
B. Dashed ellipse
C. Rectangle
D. Triangle

Prepared by HaymanotYihune Page 24 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

12. Select * from employee what types of statement is this?

A. DML
B. DDL
C. View
D. DCL
13. A set of one or more keys which is used to speed up access to data in a table is a separate
physical data structure that enables queries to access one or more data rows fast.
A. View
B. Database file
C. Index
D. Schema
14. A technique for providing atomicity and durability in database system. A page, in this context,
refers to a unit of physical storage.
A. Transaction log file
B. Shadow paging
C. Commit
D. Rollback
15. The process of dumping data (from a database, a transaction log. or a file).
A. Database backup
B. Database restore
C. Database recovery
D. Database transaction
16. A type of diagram that represents an algorithm or process, showing the steps as boxes of
various kinds, and their order by connecting those with arrows.
A. Pseudo code
B. Algorithm
C. Flow chart
D. E-R Diagram
17. Defines the relationship between the entities in terms of numbers?
A. Degree
B. Cardinality
C. Dependency
D. Co-relations
18. A set of objects that share the same attributes , operations , and relationships
A. Object
B. Class
C. Interface
D. Coding

Prepared by HaymanotYihune Page 25 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

19. The process of extracting shared characteristics from two or more classes, and combining them
in to a super class?
A. Specialization
B. Generalization
C. Division
D. Separation
20. Desigrated to test and trial a new design to enhance precision by system analyst’s users.
A. Audit trial
B. Feed back
C. Prototype
D. Association
21. Entity types that Do Not have key attributes (strong key) are called?
A. Week entity types
B. Strong entity types
C. Week attribute types
D. Strong attribute type s

J. Match Column “A” with Column “B”

1. First Normal form (1NF) 6. Rapid Application Development E

2. Second Normal form (2NF) A 7. Incremental back up

3. Third Normal form (3NF) C 8. Differential backups H

4. Boyce-coded normal form (BCNF) D 9. UML.Q

5. Hierarchy plus input-process-output G 10. Leadership.

Prepared by HaymanotYihune Page 26 of 34
 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

11. sorting O I. Unified Method Language

J. Id number
12. Work planning P K. Identifying
L. The view of a person whether positive or
13. Stored attribute M
negative
14. Derived attribute N M. Age
N. Birth_ Date
15. Attitude L O. Identify people and other resources needed
to get the work done
P. Influencing people to get things done to a
standard and quality above their norm.
Q. Unified modeling Language
R. Stores only the data changes that have
occurred since the last full back up.

A. It has no partial dependency

B. No duplicate row in the table
C. It has no transitivity decencies
D. Every determinate is a candidate key
E. RAD
F. HIPO
G. HPIPO
H. Back up of all changes made since last back
up

1. Student(ID, name, dept name, Credit_ Hr)

Using the above information, which attribute can be the primary key for the
studenttable?
A. Name
B. Dept
C. Credit_ Hr
D. ID

Prepared by HaymanotYihune Page 27 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

2. Using Database management systems is preferable than file system when

A. The number of records is small
B. The Data we need to keep is very secure
C. The speed of accessing data is our first priority
D. The company have no capacity to add new hardware and software

3. You created a table called department that stores company departments’ detail.The
table contains departmentIDdatatype int and departmentName data type varchar(50).
The primary key of this table is foreign key for other tables.You selected departmenID
as a primary key of the table. The reason to do this
A. It identifies uniquely
B. It is easy to remember
C. It is sequential
D. It needs lesser storage space

4. You are creating a table named Customer .The table includes the customerID Column,
which has an int data type and the customerName column which has a char data type.
Which SQL statement should you use to create a table?

A. CREAT E TABLE Customer (Customer.customerID int ,

Customer.customerName char(60));
B. CREAT E TABLE Customer (customerID, customerName(60));
C. CREAT E TABLE (customerID, customerName(60));
D. CREAT E TABLE Customer (customerID int, customerName char(60));

5. Assume that there are two given tables, STUDENT table and COURSE table under the
same database name. What will be the possible relationship between those tables?

A. One - to - Many relationship

B. One - to - One relationship
C. Many - to – Many relationship
D. Has no relationship

Prepared by HaymanotYihune Page 28 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

6. For two queries to be UNION-compatible, they must:

A. Both have compatible data types for each column

B. Both have the same number of lines in their SQL statements
C. Both return at least one row
D. Both has the same number of records

7. You have a Bank Database system to store account transaction data. What doyou do if
you need to get ordered transaction data from the most recent to the oldest transaction

A. sort “transaction date” in ascending order

B. sort “transaction date” in descending order
C. sort “transaction amount” in descending order
D. sort “transaction amount” in ascending order

8. Which SQL expression is syntactically incorrect?

A. SELECT FROM EMPLOYEE;

B. SELECT * FROM EMPLOYEE;
C. SELECT NAME FROM EMPLOYEE;
D. SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;

9. Which one of the following is not factor that affect work place communication
A. personal behavior
B. Lack of good governance
C. Office location
D. Motivation to work together

Prepared by HaymanotYihune Page 29 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

10. You are a Database developer for an insurance company. Every insurance policy is
managed by one and only one product manager. One product manager can manage
many policies. How can you represent that information in the database?

A. Include the manager ID in the Policies entity

B. Include the policy ID in the Managers entity
C. Create a relationship entity formed by the policy ID and the manager ID
D. Include the manager ID in the Policies entity and the policy ID in the Managers
entity

11. Which of the following is not a task in gathering data to identify business requirements

A. Ensuring stakeholder involvement at all levels

B. Giving training on how to operate to users and technicians
C. Understand the needs of your client
D. Identify the key people who will be affected by the project.

12. Indexes are created in most RDBMSs to:

A. Provides a quicker way to store data.

B. Increase the cost of implementation.
C. Provide rapid random and sequential access to base-table data.
D. Decrease the amount of disk space utilized.

13. What do you do if an important table in your database is removed accidentally?

A. Undo the operation to bring it back to its prior state
B. Get the deleted data from recycle bin and restore it
C. Create the table and add all the data from documents
D. Restore the table from backup file

Prepared by HaymanotYihune Page 30 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

14. A power failure occurred while the database was operating. Unfortunately, the UPS did
not function properly and did not stop the SQL server in a proper manner. Once power
comes back, what do you have to do to your server to recover the transactions that
have been committed but not checkpointed?

A. You need to back up the transaction log, restore the Database from the last full
Database backup, and then restore all the transaction logs
B. Nothing. SQL Server will recover automatically, rolling back pending
transactions and rolling forward committed ones.
C. Nothing. All transactions since the last checkpoint are lost, the effects of the
others are in the Database.
D. Run ROLL FORWARD ALL TRANSACTIONS.

15. While gathering data to determine the organization business requirement you might
take records of the organization like, annual reports and organizational policies. These
kinds of information resources are considered as

A. Tertiary sources
B. Secondary sources
C. Primary sources
D. Informal sources

16. A database technical documentation should contain all except

A. Descriptions of what the table means and how it's functionally used
B. Descriptions of what each attribute means
C. Explanations of the relationships
D. Descriptions of clients

17. An application where only one user accesses the database at given time is an example
of

Prepared by HaymanotYihune Page 31 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

A. Single user database

B. Multiuser database application
C. E -commerce database application
D. Data mining database application

18. The database administrator wants to fix the database after a failure such as a hard disk
malfunction, from where he/she start to make database functional again?

A. From backup
B. From partition D
C. From security
D. From access control

19. You created foreign key constraints and need to update the value in the referencing
column. If the values in the referenced column are updated which referential integrity
command should be used.
A. ON UPDATE RESTRICT
B. ON UPDATE NO ACTION
C. ON UPDATE CASCADE
D. ON UPDATE SET DEFAULT

20. 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. Perform all duties of the team by your own
C. Possess necessary leadership skill
D. Understand the team role

Prepared by HaymanotYihune Page 32 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

21. You need to bring data from an Access database in to 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

Column A Column B
_A__1. Arranging the activities of database system A. Planning
development lifecycle B. Arrow with a unique label
_Q__2. Identifying information gaps and proposing a C. Kaizen
solution for the organization D. Data Control Language(DCL)
_G__3. The process of constructing a model of the E. Data Definition Language (DDL)
database used in the organization F. Data Manipulation Language
_B__4. The process of testing and deploying the designed (DML)
database. G. Design
_D__5. Administering and maintaining a deployed database H. Diamond
system. I. ALTER
_S__6. database object about which information is to be J. Double rectangle
collected K. Ellipse
_C__7. continues change of work procedures L. Entity
_O__8. the process of removing duplicated records in M. Implementation
database modelling N. Join
_N__9. An SQL command that combines records from two O. Normalization
or more tables in a database P. Operation and Support
_I__10. An SQL command used to add column Q. Analysis
_H__11. In ER diagram relationships are represented R. Rectangle
_R__12. In ER diagram entities are represented S. SELECT
_K__13. In ER diagram attributes are represented
_E__14. Language that is used to create structure of a
database
_F__15. Language that is used to store, retrieve, and
access data in a database

Prepared by HaymanotYihune Page 33 of 34

 Database Administration Level III COC Theory Model Exam for
Both Regular and Extension TRAINEE’S

Prepared by HaymanotYihune Page 34 of 34