Database Administration Level-3 Theoretical Question

1. A method of data collection in which the situation is watched and the relevantnes
facts action and behaviors are recorded.
A. Interview
B. Observation
C. Survey
D. Questionnaire
2. Assume the there is a table named R with attributes A,B,C and D, and A is the
primary key (determinant ) of R, then which of the following is true about fully
functional dependency.
A. {A} {B,C,D}
B. {A,C} {B,D}
C. {B,C} {A,D}
D. {B,C,D} {A}
3. You run a SELECT statement and multiple duplicates of values are retrieved. What
keywords can you to retrieve only the non-duplicate value?
A. DUPILCATE
B. INDIVIDUAL
C. DISTINCT
D. SEPARATE
4. In data base modeling ,a set of objects with the same properties or characteristics is
termed as
A. Entity instance
B. Entity type
C. Relationship type
D. Relationship instance
5. With SQL, which types of join should you use if you want to return only matched
rows?
A. Inner join
B. Left outer join
C. Right outer join
D. Full outer join
6. Dropping a table will remove:
A. Only the table definition, but not the stored values
B. Only the permission specified for that table
C. Only the stored values, but not the table definition.
D. The table definition and all store values.
7. Among the following, which one can considered as composite attribute for
EMPLOEE table?
A. Address
B. Salary
C. Id
D. Sex

Set by:- Zelalem.A Good luck!!!!!!!! Page 1

8. If you have two entities that have a many (M:N) relationship between them , how do
you map them to relation tables
A. You create two tables by defining the column as foreign key to the M side of the
entity on relationship
B. You create each individual relation as separate tables and introduce a third
(new) table by taking the primary key of the two tales combined together as
primary keys and used by taking keys
C. You create three separate tables without defining a foreign key to the table on
the M side of the relationship
D. You create two tables by defining the column as foreign key to the N side of the
entity c relation ship

9. How can you change “bertukan “ in to “Birtukan “ in the “ Last Name “column in the
student
Table?
A. UPDATE Student SET Last Name = Bertukan “ INTO Last Name = Birtukan’
B. MODIFY Student SET Last Name = Bertukan’ WHERE Last Name = Bertukan’
C. UPDATE Student SET Last Name = Bertukan’ WHERE Last Name = Bertukan
D. MODIFY Student SET Last Name = Bertukan’ INTO Last Name = Birtukan’
10. There are certain packages that allow people to define data items, place these mines
in particular record combine the records into designated files and the manipulated
and retrieve the store data. What are they called?
A. Data store system
B. Batch processing system
C. Data management system
D. Data communication package
11. 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
B. Entity integrity constraint
C. User defined integrity constraint
D. Referential integrity constraint
12. Given the table shown below which normalization step is missing
VEHICLE
Serial No Owner Model Manufacture Engine – Size
A. 2NF
B. 3NF
C. 1NF
D. Boyce code
13. In the above given table how to remove a field name “Engine –Size”?
A. Modify table EMPLOYEE delete engine – size
B. Alter table EMPLOYEE drop Engine – size
C. Modify table EMPLOYEE delete column engine – size
D. Alter table EMPLOYEE drop column Engine size

Set by:- Zelalem.A Good luck!!!!!!!! Page 2

14. SQL, how do you select all the record from a table named “Student” where the value
of the column “First Name “starts with a “B”?
A. Select * from STUDENT where First Name Like% B%
B. Select * from STUDENT where First Name=Like B%
C. Select * from STUDENT where First Name Like %B’
D. Select * from STUDENT where First Name Like=’B’
15. Among the following which activity helps you to determine the attribute and
Relationship
A. Conceptual data base modeling
B. Logical—data base modeling
C. Physical data base modeling
D. Data base modeling
16. In the relational modes, cardinality is termed as:
A. Number of tuples
B. Number of attributes
C. Number of tables.
D. Number of constraints.

17. Where does the DBMS store the definition of data elements and their relationship?
A. Data file C. Data
B. Index D. Data Maps
18. An entity set that does not have sufficient attributes to from a primary key can be
Considered as
A. A strong entity set C. Simple entity set
B. Weak entity set D. Primary entity set
19. With SQL, how can you populate TRAING Table with rows from EMPLOYEE table?
A. Insert in to first Name, Last Name
B. Select First Name, Last Name in to EMPLOYEE from TRAINING
C. Insert in to First Name Last Name EMPOLOYEE from TARINING
D. Select First Name in to TRAING from EMPLOYEE
20. An instance of relational schema R (A, B,C) has distinct for A including NULL values
Which one of the following is true?
A. A is a candidate key C. A is primary key
B. A is on –key D. A is foreign key
21. The data base design that consists of multiple is termed as
A. Hierarchical data base C. Relation data base
B. Network D. Object oriented data base

Set by:- Zelalem.A Good luck!!!!!!!! Page 3

SELCTION B-MATCHIN TYPE QUESTIONS

Column A Column B
1.The process of periodically taking a copy of the A. Pseudo code
data base & log file into offline storage media B. Implantation
2. Sort a result set C. Relationship
3.Value of one attribute uniquely determines the D. Union
value of another attribute E. Entity Integrity
4.No primary key value can be null F. first Normal form
5. The number of participating entities in the relationship G. Drop
6.Aproperty of an entity or a relationship H. Data structure
7. Building a working model of data base system I. Order By
8. A collection of normalized table J. Entity type
9. Represent a value for this record K. second Normal form
10. The physical realization of the data base L. Null
and application designs M. Degree of relationship
11. Method used to define an algorithm N. Third Normal form
12.combine the result – set of two or more SELECT O. Attribute
Statements P. Relation data base
13. No partial dependencies Q. Backup
14.A set of meaningful association among entities R. prototyping
15. Way of storing and organizing data in a computer S. Functional dependency
T. Back up

Set by:- Zelalem.A Good luck!!!!!!!! Page 4