CS – D427 ITEC 2117
Data Management Applications
LATEST FINAL ASSESSMENT
REVIEW
Q&S
©2024/2025
,1. Multiple Choice: Which of the following is a key feature of
NoSQL databases?
a) Fixed schema
b) SQL compatibility
c) Scalability
d) Single data model
Correct ANS: c) Scalability
Rationale: NoSQL databases are designed to provide high
scalability, which is essential for handling large volumes of data
and high transaction rates that are common in big data and real-
time web applications.
2. Fill-in-the-Blank: __________ is the process of ensuring that
data in a database remains accurate and consistent over time.
Correct ANS: Data integrity
Rationale: Data integrity is crucial for maintaining the reliability
of data in a database. It involves various processes and
mechanisms to prevent accidental or intentional data corruption.
3. True/False: Data mining is exclusively concerned with the
extraction of patterns from large datasets.
©2024/2025
, Correct ANS: False
Rationale: While data mining does involve the extraction of
patterns, it is not limited to this function. It also includes the
analysis of data and the use of statistical techniques to predict
future trends.
4. Multiple Response: Select all that apply. Which of the
following are common challenges in data management?
a) Data security
b) Data integration
c) Data analysis
d) Data creation
Correct ANSs: a) Data security, b) Data integration, c) Data
analysis
Rationale: Data security, integration, and analysis are significant
challenges in data management. Data creation is not typically
considered a challenge as it is a fundamental aspect of data
processes.
5. Multiple Choice: In the context of databases, ACID properties
ensure which of the following?
a) Data redundancy
b) Transaction reliability
c) Data normalization
©2024/2025
, d) Query optimization
Correct ANS: b) Transaction reliability
Rationale: ACID properties (Atomicity, Consistency, Isolation,
Durability) are a set of principles that guarantee transaction
reliability in a database system, ensuring that all transactions are
processed reliably.
6. Fill-in-the-Blank: The __________ model is used to describe
the logical structure of a database using diagrams and symbols.
Correct ANS: Entity-Relationship (ER)
Rationale: The ER model is widely used in database design to
represent the data entities, attributes, and relationships in a clear
and structured manner.
7. True/False: Big Data solutions are typically characterized by
their use of traditional database management systems.
Correct ANS: False
Rationale: Big Data solutions often require technologies beyond
traditional database management systems, such as distributed
processing frameworks, to handle the volume, velocity, and
variety of big data.
8. Multiple Response: Which of the following are benefits of
using cloud-based data management solutions?
©2024/2025
Data Management Applications
LATEST FINAL ASSESSMENT
REVIEW
Q&S
©2024/2025
,1. Multiple Choice: Which of the following is a key feature of
NoSQL databases?
a) Fixed schema
b) SQL compatibility
c) Scalability
d) Single data model
Correct ANS: c) Scalability
Rationale: NoSQL databases are designed to provide high
scalability, which is essential for handling large volumes of data
and high transaction rates that are common in big data and real-
time web applications.
2. Fill-in-the-Blank: __________ is the process of ensuring that
data in a database remains accurate and consistent over time.
Correct ANS: Data integrity
Rationale: Data integrity is crucial for maintaining the reliability
of data in a database. It involves various processes and
mechanisms to prevent accidental or intentional data corruption.
3. True/False: Data mining is exclusively concerned with the
extraction of patterns from large datasets.
©2024/2025
, Correct ANS: False
Rationale: While data mining does involve the extraction of
patterns, it is not limited to this function. It also includes the
analysis of data and the use of statistical techniques to predict
future trends.
4. Multiple Response: Select all that apply. Which of the
following are common challenges in data management?
a) Data security
b) Data integration
c) Data analysis
d) Data creation
Correct ANSs: a) Data security, b) Data integration, c) Data
analysis
Rationale: Data security, integration, and analysis are significant
challenges in data management. Data creation is not typically
considered a challenge as it is a fundamental aspect of data
processes.
5. Multiple Choice: In the context of databases, ACID properties
ensure which of the following?
a) Data redundancy
b) Transaction reliability
c) Data normalization
©2024/2025
, d) Query optimization
Correct ANS: b) Transaction reliability
Rationale: ACID properties (Atomicity, Consistency, Isolation,
Durability) are a set of principles that guarantee transaction
reliability in a database system, ensuring that all transactions are
processed reliably.
6. Fill-in-the-Blank: The __________ model is used to describe
the logical structure of a database using diagrams and symbols.
Correct ANS: Entity-Relationship (ER)
Rationale: The ER model is widely used in database design to
represent the data entities, attributes, and relationships in a clear
and structured manner.
7. True/False: Big Data solutions are typically characterized by
their use of traditional database management systems.
Correct ANS: False
Rationale: Big Data solutions often require technologies beyond
traditional database management systems, such as distributed
processing frameworks, to handle the volume, velocity, and
variety of big data.
8. Multiple Response: Which of the following are benefits of
using cloud-based data management solutions?
©2024/2025
