C792 NURS 6010 Data Modeling & Database
Management Systems (NI)
Objective Assessment Review (Qns & Ans)
2025
1. What is the primary purpose of data modeling in database
systems?
a. Increasing hardware efficiency
b. Structuring and organizing data logically ( Correct ANS )
c. Reducing query complexity
d. Automating data entry processes
Rationale: Data modeling provides a logical framework for
representing and organizing data relationships to support database
design.
2. Which type of data model provides a detailed representation
of a database’s physical storage?
©2025
, a. Conceptual model
b. Logical model
c. Physical model ( Correct ANS )
d. Object-oriented model
Rationale: Physical models focus on the storage and retrieval
mechanisms used within databases.
3. What does normalization aim to achieve in relational
databases?
a. Simplifying table structures
b. Removing redundant data and ensuring data consistency (
Correct ANS )
c. Reducing query processing time
d. Enhancing user interfaces
Rationale: Normalization eliminates data redundancy and
ensures consistency by organizing data into structured tables.
4. Which SQL command is used to retrieve data from a
database?
a. UPDATE
b. DELETE
c. SELECT ( Correct ANS )
©2025
, d. INSERT
Rationale: The SELECT command queries and retrieves data
from specified tables in a database.
---
Fill-in-the-Blank Questions
5. In relational databases, a __________ is a set of attributes that
uniquely identifies each record in a table.
ANS: Primary key
Rationale: Primary keys enforce uniqueness and enable
accurate identification of records within a table.
6. A __________ database system stores and retrieves data in
formats other than tables, such as graphs or documents.
ANS: NoSQL
Rationale: NoSQL databases are ideal for unstructured data
and provide flexibility beyond the relational model.
7. The process of __________ involves organizing tables in a
database to minimize redundancy and dependency.
©2025
Management Systems (NI)
Objective Assessment Review (Qns & Ans)
2025
1. What is the primary purpose of data modeling in database
systems?
a. Increasing hardware efficiency
b. Structuring and organizing data logically ( Correct ANS )
c. Reducing query complexity
d. Automating data entry processes
Rationale: Data modeling provides a logical framework for
representing and organizing data relationships to support database
design.
2. Which type of data model provides a detailed representation
of a database’s physical storage?
©2025
, a. Conceptual model
b. Logical model
c. Physical model ( Correct ANS )
d. Object-oriented model
Rationale: Physical models focus on the storage and retrieval
mechanisms used within databases.
3. What does normalization aim to achieve in relational
databases?
a. Simplifying table structures
b. Removing redundant data and ensuring data consistency (
Correct ANS )
c. Reducing query processing time
d. Enhancing user interfaces
Rationale: Normalization eliminates data redundancy and
ensures consistency by organizing data into structured tables.
4. Which SQL command is used to retrieve data from a
database?
a. UPDATE
b. DELETE
c. SELECT ( Correct ANS )
©2025
, d. INSERT
Rationale: The SELECT command queries and retrieves data
from specified tables in a database.
---
Fill-in-the-Blank Questions
5. In relational databases, a __________ is a set of attributes that
uniquely identifies each record in a table.
ANS: Primary key
Rationale: Primary keys enforce uniqueness and enable
accurate identification of records within a table.
6. A __________ database system stores and retrieves data in
formats other than tables, such as graphs or documents.
ANS: NoSQL
Rationale: NoSQL databases are ideal for unstructured data
and provide flexibility beyond the relational model.
7. The process of __________ involves organizing tables in a
database to minimize redundancy and dependency.
©2025
