Ethiopian Police University

Information Technology and Cybersecurity Department

Model Exit Exam Sample for Fundamentals of Database Systems

Target Group: Information Technology Graduating Class Students

May, 2025
Instruction: -Read each statement carefully and choose the most appropriate answer from the
provided alternatives. The answer for each question is provided to you at the end of
each question.
1. What is the purpose and objective of the Three-Level database architecture?
A. User's view is affected by changes made in other views.
B. Internal structure of database should be unaffected by changes to physical aspects of
storage.
C. Users need to know physical database storage details.
D. DBA should not be able to change conceptual structure of database without affecting all
users.
Answer:- B
2. One of the following is not an example of Record-based data model.
A. Entity-relationship (ER) data model
B. Relational data model
C. Network data model
D. Hierarchical data model
Answer: - A
3. Which one of the following is not the primary purpose of Database management system
(DBMS)?
A. To store and retrieve large amounts of data efficiently.
B. To manage the database and its users.
C. To maintain and control access to the database.
D. To design graphic interfaces.
Answer: - D
4. Which of the following is not a database constraint?
A. NOT NULL
B. UNIQUE
C. PRIMARY KEY
D. SORT
Answer: - D
5. Which of the following is a valid SQL statement to add a column to an existing table?
A. UPDATE TABLE table_name
ADD column_name datatype;
B. ADD to TABLE table_name
ADD column_name datatype
C. ALTER TABLE table_name
ADD column_name datatype
D. CHANGE TABLE table_name
ADD column_name datatype
Answer:- C
6. Which SQL command is used to retrieve data from a database?
A. GET
B. RETRIEVE
C. SELECT
D. EXTRACT
Answer:- C
7. What is normalization in the context of database design?
a) The process of minimizing redundancy and dependency by organizing fields and table
of a database
b) The process of denormalizing a database
c) The process of converting data into a binary format
d) The process of indexing the database
Answer: - A
8. What is the inconsistency occurred in the Database Management System (DBMS) during
the operations performed on the relational table.
A. Normalization
B. Anomaly
C. Denormalization
D. Indexing
Answer:- B
9. Consider the following table named ‘student’ and answer the question following it.
Name Sex Dept. Date-of-birth
Abebe M Comp 12-01-2010
Kebede M Civil 19-05-1990
Chala M Elec 05-06-1980

Which of the following SQL query will be used to change the data type of column
‘Date-of-birth’ from dd-mm-yyyy to only yyyy?
A. ALTER TABLE student
ALTER COLUMN Date-of-birth year
B. CHANGE TABLE student
UPDATE COLUMN Date-of-birth year
C. UPDATE TABLE student
ALTER COLUMN Date-of-birth year
D. ALTER TABLE student
CHANGE COLUMN Date-of-birth year
Answer: -A
10. In SQL, which keyword is used to sort the result-set?
A. SORT BY
B. ARRANGE BY
C. ORDER BY
D. GROUP BY
Answer: - C
11. What is a view in SQL?
A. A table containing summarized data.
B. A virtual table based on the result-set of an SQL statement.
C. E-R diagram
D. A physical copy of data
Answer:- B
12. Which of the following provides the ability to query information from the database and
insert tuples into, delete tuples from, and modify tuples in the database?
A. DML (Data Manipulation Language)
B. DDL (Data Definition Language)
C. Query
D. Relational Schema
Answer: - A
13. Which of the following normal forms eliminates transitive dependencies?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: - C
14. What is the function of the GROUP BY clause in SQL?
A. To combine multiple tables.
B. To arrange data in a specific order.
C. To filter records
D. To aggregate data across multiple rows
Answer: - D
15. Which key in DBMS is used to create connectivity between the two tables?
A. Foreign key
B. Super key
C. Candidate key
D. Primary key
Answer: - A
16. What is the purpose of an entity-relationship (ER) diagram?
A. To design the user interface.
B. To represent the data and relationships in a database.
C. To outline the database queries.
D. To manage database transactions.
Answer:- B
17. In a relational database, field refers to?
A. A column in a table
B. A row in a table
C. A table itself
D. A database schema
Answer: - A
18. Which one of the following given statements possibly contains the error?
A. Select * from emp where empid = 10003;
B. Select empid from emp where empid = 10006;
C. Select empid from emp;
D. Select empid where empid = 1009 and Lastname = 'GELLER';
Answer:- D
19. Which of the following is generally used for performing tasks like creating the structure of
the relations, deleting relation?
A. Data dictionary
B. Query
C. DDL (Data Definition Language)
D. Metadata
Answer:- C
20. Which one of the following command is used to delete the existing row in a table?
A. DELETE
B. UPDATE
C. INSERT
D. SELECT
Answer: - A
21. Why the following statement is erroneous SQL statement?
SELECT dept_name, ID, avg (salary)
FROM instructor
GROUP BY dept_name;
A. Dept_id should not be used in group by clause
B. Group by clause is not valid in this query
C. Avg(salary) should not be selected
D. None
Answer:-A
22. ______________ is a set of one or more attributes taken collectively to uniquely identify
a record.
A. Primary Key
B. Foreign key
C. Super key
D. Candidate key

Answer: - C

23. _________ is a set of interrelated and sharable data records

A. Database
B. Spreadsheet
C. Management information system
D. Text file

Answer: - A

24. Which of the following is true about relational database tables?

A. The columns must be created in alphabetical order
B. Columns are called tuples
C. Each row must be unique.
D. Rows are called fields

Answer: - C
25. Which of the following database model establishes a top-to-bottom relationship among the
data items?
A. Relational model
B. Network model
C. Hierarchical model
D. Object oriented model

Answer: - C
26. Which of the following statement is false in representing a relationship
A. For 1:1 cardinality, one of the table’s primary key is mapped in to the other as a
foreign key
B. RBMS do not allow a N:M relationship direct implementation
C. For N:M cardinality, the primary key of both relations should be mapped in to
another third relation as a foreign key
D. For 1: N cardinality, the primary key of the “N” side relation should be mapped in
to the 1 side relation as a foreign key.
Answer: - D
27. Identify the false statement about normalization
A. Normalization minimizes database anomalies
B. First normal form assumes every tuple field to take a single atomic value
C. Third normal form avoids transitive dependency of the non key attributes on the
primary key
D. 2nd normal form avoids whole dependency of non-key attributes on the primary
key.
Answer: - D
28. ________ refers to the number of instances associated with a single instance of an entity
in a relationship.
A. Domain B. Degree C. Cardinality D. Schema
Answer:- C
29. A composite attribute of an ERD is represented by ----------
A. Rectangle B. Double oval C. Dotted oval D. Diamond
Answer: - B
30. Identify the false statement about the relational data model
A. It is a logical level model
B. Its rows are called tuples
C. Its columns are called records
D. Relationship between two relations is represented using foreign key
Answer: - C
31. ________ refers to the number of instances associated with a single instance of an entity
in a relationship.
B. Domain B. Degree C. Cardinality D. Schema
Answer: - C
32. Which of the following attribute can be considered as a multi valued attribute
A. e-mail B. Sex C. Age D. Name
Answer: - A
33. Given the notation “A--> B” of functional dependency :
A. B is functionally dependent on A C. A is a non-key field
B. A is functionally dependent on B D. B uniquely identifies A
Answer: - A
34. Identify the false statement about object-oriented database and relational database systems
A. Unlike relational databases, defining primary key in OO database is optional
B. Unlike SQL which produces relations, Object Query Language (OQL) produces
collection as a query output
C. Object RDBMS is more extensible than Object Oriented DBMS and RDBMS
D. In object-oriented model the heart of the system is object but for object relational
database it is the relation
Answer:- C
35. Which of the following statements is true?
A. All super keys can be candidate keys
B. Each table can have only one candidate key
C. Primary key can be a composite key
D. All of the above
Answer: - C
36. The number of entities participating in a relationship is known as
A. Cardinality C. Participation
B. Degree D. Multiplicity
Answer: - B
37. For each attribute of a relation, there is a set of permitted (allowable) values, called
______
A. Domain B. Relation C. Set D. Schema
Answer: - A
38. An attribute that can be divided into sub parts (composed of other attributes).
A. Multi-valued attribute C. Composite attribute
B. Derived attribute D. Simple

Answer: - C

39. Which of the following keyword is not used as a data manipulation language?
A. ALTER D. DELETE
B. SELECT E. NONE
C. UPDATE
Answer: - A
40. The concept that refers to the content of a database at a moment in time is called?
A. Database state C. Valid state
B. Initial database state D. Schema

Answer: - A

41. Which SQL command is used for deleting a table or a database itself?
A. ALTER C. DROP
B. UPDATE D. DELETE
Answer: - C

42. A normalization type which does not require dependencies between non key attributes is
called?
A. 1NF B. 2NF C. 3NF D. 4NF E. ALL
Answer: - C
43. Which of the following is true in relational database tables?
A. The columns must be created in alphabetical order C. Each row has a name
B. Each row must be unique. D. All of the above
Answer: - B
44. In addition to containing data required by an organization, database also contains a
description of the data and this is known as?
A. Data dictionary B. System catalogue C. Meta data D. ALL
Answer: - D
45. A category of data model that is able to model complex relationships and represents
semantics of add/delete on the relationships is called?

A. Network model C. Relational model

B. Hierarchical D. ALL
Answer: - A
46. A concise description of the data requirements of the users and includes detailed
descriptions of the entity types, relationships, and constraints is called?
A. Physical design B. Logical design C. Conceptual design D. None
Answer: - C
47. Finding the key with which we can find all data is called?
A. 1NF B. 2NF C. 3NF D. 4NF
Answer: - A
48. A failure to place information about a new database entry into all the places in the database,
where information about that new entry needs to be stored.
A. Insertion anomaly B. Deletion Anomaly C. Modification anomaly D. All are Answers
Answer: - A
49. Among the following one is not the characteristics of the super key, which one?
A. uniqueness B. Reducibility C. Irreducibility D. Candidate key
Answer: - B
50. A language which is also called as query language is?
A. Data Structuring Language B. Data Definition Language C.SQL D. Natural Language
Answer: - C