CS – D426 ITEC 2116 Data Management -
Foundations
Comprehensive Objective Assessment (Qns &
Ans)
2025
Question 1 (Multiple Choice)
Question:
Which normal form requires that every non-prime attribute is
fully functionally dependent on the entire primary key, thereby
eliminating partial dependencies?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
©2025
, Correct ANS:
B) Second Normal Form (2NF)
Rationale:
2NF builds on 1NF by ensuring that no non-prime attribute is
partially dependent on any candidate key. This means that each
non-key attribute must depend on the entire primary key, which
reduces data redundancy and supports better data integrity in
relational designs.
---
Question 2 (Fill in the Blank)
Question:
In relational database design, the process of structurally
organizing tables to minimize redundancy and dependency is
called ________ .
Correct ANS:
Normalization
Rationale:
©2025
,Normalization systematically decomposes a database into
multiple related tables to eliminate data anomalies, reduce
redundancy, and ensure consistency. It is a fundamental process
in designing robust, efficient databases.
---
Question 3 (True/False)
Question:
A primary key in a relational database can consist of a single
attribute or a combination of attributes (composite key).
Correct ANS:
True
Rationale:
A primary key uniquely identifies each record in a table. It can be
formed by one column (simple key) or by multiple columns
(composite key), as long as the combination uniquely defines each
row.
---
©2025
, Question 4 (Multiple Response)
Question:
Select all the components that comprise the ACID properties
essential for reliable database transactions:
A) Atomicity
B) Consistency
C) Isolation
D) Durability
E) Availability
Correct ANS:
A, B, C, D
Rationale:
ACID stands for Atomicity, Consistency, Isolation, and
Durability—all of which ensure that transactions are processed
reliably. While availability is critical in system design, it is not
one of the ACID transaction properties.
---
Question 5 (Multiple Choice)
©2025
Foundations
Comprehensive Objective Assessment (Qns &
Ans)
2025
Question 1 (Multiple Choice)
Question:
Which normal form requires that every non-prime attribute is
fully functionally dependent on the entire primary key, thereby
eliminating partial dependencies?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce-Codd Normal Form (BCNF)
©2025
, Correct ANS:
B) Second Normal Form (2NF)
Rationale:
2NF builds on 1NF by ensuring that no non-prime attribute is
partially dependent on any candidate key. This means that each
non-key attribute must depend on the entire primary key, which
reduces data redundancy and supports better data integrity in
relational designs.
---
Question 2 (Fill in the Blank)
Question:
In relational database design, the process of structurally
organizing tables to minimize redundancy and dependency is
called ________ .
Correct ANS:
Normalization
Rationale:
©2025
,Normalization systematically decomposes a database into
multiple related tables to eliminate data anomalies, reduce
redundancy, and ensure consistency. It is a fundamental process
in designing robust, efficient databases.
---
Question 3 (True/False)
Question:
A primary key in a relational database can consist of a single
attribute or a combination of attributes (composite key).
Correct ANS:
True
Rationale:
A primary key uniquely identifies each record in a table. It can be
formed by one column (simple key) or by multiple columns
(composite key), as long as the combination uniquely defines each
row.
---
©2025
, Question 4 (Multiple Response)
Question:
Select all the components that comprise the ACID properties
essential for reliable database transactions:
A) Atomicity
B) Consistency
C) Isolation
D) Durability
E) Availability
Correct ANS:
A, B, C, D
Rationale:
ACID stands for Atomicity, Consistency, Isolation, and
Durability—all of which ensure that transactions are processed
reliably. While availability is critical in system design, it is not
one of the ACID transaction properties.
---
Question 5 (Multiple Choice)
©2025
