1.
In a database environment, which group is responsible for designing the
database structure?
a) End Users
b) Database Administrators (DBA)
c) System Analysts
d) Application Programmers
2. What is the main purpose of a Database Management System (DBMS)?
a) To store data in flat files
b) To provide an environment for storing and retrieving database
information efficiently
c) To design hardware for data storage
d) To process spreadsheet data
3. The three levels of data abstraction in DBMS are:
a) Physical, Logical, and View levels
b) Data, Information, and Knowledge levels
c) Internal, External, and Conceptual levels
d) Relational, Hierarchical, and Network levels
4. Which level describes how data is physically stored?
a) External
b) Conceptual
c) Internal
d) Logical
5. Why is a DBMS preferred over traditional file systems?
a) It makes data access slower
b) It increases redundancy
c) It reduces inconsistency and improves sharing
d) It uses more memory
6. Which process removes data redundancy?
a) Indexing
b) Normalization
c) Mapping
d) Encapsulation
7. Normalization in DB design is mainly used to:
a) Remove redundant data and anomalies
b) Increase redundancy
c) Improve query performance only
d) Create backup copies
8. Why is a DBMS preferred over traditional file systems?
a) It makes data access slower
b) It increases redundancy
c) It reduces inconsistency and improves sharing
d) It uses more memory
9. Why do we use ER diagrams in database design?
a) To write SQL queries faster
b) To visually represent entities and relationships
c) To store data physically
d) To normalize tables
10.
Which of these explains the conceptual schema?
a) Shows user views
b) Defines logical structure of database
c) Deals with indexes and files
d) Describes stored procedures only
11. What is the first stage in database design?
a) Logical design
b) Physical design
c) Conceptual design
d) Implementation
12. Which level provides logical structure of the entire database?
a) Physical level
b) Conceptual level
c) External level
d) File level
13. Which of these explains the conceptual schema?
a) Shows user views
b) Defines logical structure of database
c) Deals with indexes and files
d) Describes stored procedures only
14. Generalization in EER is:
a) Bottom-up approach combining multiple entities into a higher-level
entity
b) Top-down approach dividing an entity into sub-entities
c) Creating foreign keys
d) Creating indexes
15. What does specialization in EER represent?
a) Combining many entities into one
b) Dividing an entity into sub-entities
c) Creating indexes for faster retrieval
d) Removing entities
1. 1. Which of the following best describes the purpose of an ER model?
a) To define the physical storage of data in a database.
b) To represent the logical structure of a database.
c) To specify the programming language used to access the database.
d) To manage user access permissions to the database.
2. What is the role of a relationship in an ER model?
a) To define the data types of attributes.
b) To represent the association between two or more entities.
c) To specify the primary key of an entity.
d) To define the storage structure of the database.
3. A derived attribute is one that:
a) Must be stored in the database.
b) Cannot be stored in the database, but can be computed from other
attributes.
c) Must be unique for each entity.
d) Represents the primary key of an entity.
4. For the following functional dependencies A->B, B->C, which of the
following holds?
A. A->C
B. C->A
C. A->B
D. None of the mentioned.
5. Choose, from the given, A functional dependency is a relationship
between or among
a) Tables
b) Rows
c) Relations
d) Attributes
6. Which process removes data redundancy?
a) Indexing
b) Normalization
c) Mapping
d) Encapsulation
7. Normalization in DB design is mainly used to:
a) Remove redundant data and anomalies
b) Increase redundancy
c) Improve query performance only
d) Create backup copies
8. Which of the following is most accurately generalized by functional
dependencies?
a) Key dependencies
b) Relation dependencies
c) Database dependencies
d) None of the above
9. Which of them belongs to Non-trivial functional dependency?
a) It occurs when B is a subset of A
b) It occurs when B is not a subset of A
c) It occurs when A intersection B is null
d) All of the mentioned
10. In a lossless join decomposition, what is a possible consequence of the
added join overhead?
a) Improved data integrity
b) Performance impacts on query operations
c) Simplified data retrieval
d) Reduced data consistency
11. Find which one of the following, is one of the primary goals of lossless
join decomposition in DBMS?
a) Achieving a higher normal form without data loss.
b) Minimizing data consistency.
c) Minimizing data integrity.
d) Simplifying database design.
12. What does lossless join decomposition refer to in the context of
database decomposition in DBMS,
a) Decomposing a database to minimize data redundancy.
b) Decomposing a database to maximize data loss.
c) A decomposition that results in the loss of some data.
d) A decomposition that ensures no information is lost when joining the
decomposed tables.
13. In ..................., a composite attribute is decomposed into individual
attributes.
a) 1st Normal Form
b) 2nd Normal Form
c) 3rd Normal Form
d) BCNF
14. In a one-to-many or many-to-many relationship, the table on the “many”
side should have ...........................
a) lossless decomposition
b) non-lossless decomposition
c) a single attribute key
d) a composite key
15. Normal form which only includes indivisible values or single atomic
values is classified as
a) third normal form
b) first normal form
c) second normal form
d) fourth normal form
16. In the _________ normal form, a composite attribute is converted to
individual attributes.
a) First
b) Second
c) Third
d) Fourth
17. --------------------is the primary objective of Second Normal Form (2NF)
in database normalization.
a) To eliminate duplicate rows in a table.
b) To ensure that every non-prime attribute is fully functionally
dependent on the primary key.
c) To organize data into a two-dimensional table structure.
d) To define primary and foreign key relationships.
18. Normalization form which is based on transitive dependency is
classified as
a) first normal form
b) second normal form
c) fourth normal form
d) third normal form
19. Considering functional dependency, one in which removal from some
attributes must affect dependency is called
a) full functional dependency
b) partial dependency
c) prime functional dependency
d) transitive dependency
20. Which of the following is a common approach to detect join
dependencies in a database schema?
a) Analyzing query logs
b) Conducting user surveys
c) Examining table relationships
d) Performing data encryption
21. The normal form which satisfies multivalued dependencies and which is
in BCNF is
a) 4NF
b) 3NF
c) 2NF
d) All of the mentioned
22.. Which one among the following, Fifth Normal Form (5NF) focuses on
handling dependencies in a database.
a) Partial
b) Multi-valued
c) Transitive
d) Join
23. A dependency-preserving decomposition ensures that no new
______________ are introduced.
A. Rows
B. Columns
C. Dependencies
D. Tuples
24. Fifth Normal Form (5NF) focuses on handling ______________
dependencies in a database.
A. Partial
B. Multi-valued
C. Transitive
D. Join
25. Fourth Normal Form (4NF) deals with ______________ dependencies
in a database.
A. Partial
B. Multi-valued
C. Transitive
D. Composite