D426 ITEC 2116 Data Management
Foundations
Objective Assessment Review
(Questions & Solutions)
2025
©2025
, Question 1 (Multiple Choice)
Question:
Which of the following best describes the ACID properties essential for
reliable transaction management in relational databases?
Options:
A. Accuracy, Consistency, Integrity, Durability
B. Atomicity, Consistency, Isolation, Durability
C. Aggregation, Concurrency, Isolation, Distribution
D. Atomicity, Concurrency, Integrity, Decentralization
Correct ANS:
B. Atomicity, Consistency, Isolation, Durability
Rationale:
ACID stands for Atomicity, Consistency, Isolation, and Durability. These
properties ensure that database transactions are processed reliably, a
critical requirement for systems that support network management and
security applications.
---
Question 2 (Fill-in-the-Blank)
Question:
The process of organizing data in a database to reduce redundancy and
improve data integrity is known as ________ .
ANS:
Normalization
Rationale:
©2025
,Normalization involves structuring a relational database in accordance
with a series of normal forms to minimize redundancy and dependency,
ensuring accurate and secure data handling.
---
Question 3 (True/False)
Question:
True or False: Traditional NoSQL databases typically provide eventual
consistency rather than strict ACID guarantees by default.
Correct ANS:
True
Rationale:
Many NoSQL databases opt for eventual consistency to achieve better
scalability and performance in distributed environments, often trading
off strict ACID properties.
---
Question 4 (Multiple Response)
Question:
Select all that apply: In developing a data warehousing solution, which
components are essential?
Options:
A. ETL processes (Extract, Transform, Load)
B. OLAP tools for multidimensional analysis
C. Operational databases for real-time transactions (OLTP)
D. Data marts
E. Denormalized schemas
©2025
, Correct ANS:
A, B, D, E
Rationale:
Data warehousing relies on ETL processes to consolidate data; OLAP tools
enable multidimensional analysis; data marts serve as segmented data
stores; and denormalized schemas improve query performance. OLTP
systems are designed for operational transactions and are not core to
warehousing.
---
Question 5 (Multiple Choice)
Question:
Which SQL command is used to permanently remove a table and all its
data from a database?
Options:
A. DELETE
B. DROP
C. TRUNCATE
D. REMOVE
Correct ANS:
B. DROP
Rationale:
The DROP command removes both the table structure and its data
permanently, making it distinct from DELETE (which only removes
records) or TRUNCATE (which removes data but retains the schema).
---
Question 6 (Fill-in-the-Blank)
©2025
Foundations
Objective Assessment Review
(Questions & Solutions)
2025
©2025
, Question 1 (Multiple Choice)
Question:
Which of the following best describes the ACID properties essential for
reliable transaction management in relational databases?
Options:
A. Accuracy, Consistency, Integrity, Durability
B. Atomicity, Consistency, Isolation, Durability
C. Aggregation, Concurrency, Isolation, Distribution
D. Atomicity, Concurrency, Integrity, Decentralization
Correct ANS:
B. Atomicity, Consistency, Isolation, Durability
Rationale:
ACID stands for Atomicity, Consistency, Isolation, and Durability. These
properties ensure that database transactions are processed reliably, a
critical requirement for systems that support network management and
security applications.
---
Question 2 (Fill-in-the-Blank)
Question:
The process of organizing data in a database to reduce redundancy and
improve data integrity is known as ________ .
ANS:
Normalization
Rationale:
©2025
,Normalization involves structuring a relational database in accordance
with a series of normal forms to minimize redundancy and dependency,
ensuring accurate and secure data handling.
---
Question 3 (True/False)
Question:
True or False: Traditional NoSQL databases typically provide eventual
consistency rather than strict ACID guarantees by default.
Correct ANS:
True
Rationale:
Many NoSQL databases opt for eventual consistency to achieve better
scalability and performance in distributed environments, often trading
off strict ACID properties.
---
Question 4 (Multiple Response)
Question:
Select all that apply: In developing a data warehousing solution, which
components are essential?
Options:
A. ETL processes (Extract, Transform, Load)
B. OLAP tools for multidimensional analysis
C. Operational databases for real-time transactions (OLTP)
D. Data marts
E. Denormalized schemas
©2025
, Correct ANS:
A, B, D, E
Rationale:
Data warehousing relies on ETL processes to consolidate data; OLAP tools
enable multidimensional analysis; data marts serve as segmented data
stores; and denormalized schemas improve query performance. OLTP
systems are designed for operational transactions and are not core to
warehousing.
---
Question 5 (Multiple Choice)
Question:
Which SQL command is used to permanently remove a table and all its
data from a database?
Options:
A. DELETE
B. DROP
C. TRUNCATE
D. REMOVE
Correct ANS:
B. DROP
Rationale:
The DROP command removes both the table structure and its data
permanently, making it distinct from DELETE (which only removes
records) or TRUNCATE (which removes data but retains the schema).
---
Question 6 (Fill-in-the-Blank)
©2025
