IT 220 Database Management Systems
Comprehensive Final Exam (Qns & Ans)
2025
Question 1 (Multiple Choice)
Question:
Which normal form specifically removes transitive dependencies
from a relational schema, ensuring that non–primary-key
attributes depend solely on the primary key?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce–Codd Normal Form (BCNF)
Correct ANS:
C) Third Normal Form (3NF)
©2025
, Rationale:
Third Normal Form (3NF) is designed to eliminate transitive
dependencies—situations where non-prime attributes depend on
other non-prime attributes. Ensuring that every non–primary-key
attribute is directly dependent on the primary key helps reduce
redundancy and potential anomalies.
---
Question 2 (Fill in the Blank)
Question:
A highly efficient, balanced data structure commonly used for
indexing in DBMS, which supports range queries and ordered
traversal, is known as a ________ .
Correct ANS:
B+ tree
Rationale:
B+ trees are widely used in databases to index large datasets.
Their balanced structure and ability to support efficient range
queries make them indispensable for speeding up retrieval
operations in disk-based storage systems.
©2025
,---
Question 3 (True/False)
Question:
True/False: The ACID properties—Atomicity, Consistency,
Isolation, and Durability—are fundamental guarantees that ensure
that database transactions are processed reliably and preserve data
integrity.
Correct ANS:
True
Rationale:
ACID properties form the backbone of reliable transaction
processing in DBMS. They ensure that transactions are executed
completely (atomicity), maintain data integrity (consistency),
isolate concurrent transactions (isolation), and persist data even in
the event of failures (durability).
---
Question 4 (Multiple Response)
Question:
©2025
, Select all techniques commonly used to enforce transactional
consistency and recoverability in database management systems:
A) Two-phase locking (2PL)
B) Write-Ahead Logging (WAL)
C) Snapshot isolation
D) Round-robin scheduling
E) Deadlock detection
Correct ANS:
A, B, C, E
Rationale:
Two-phase locking and snapshot isolation are methods to preserve
isolation; WAL ensures durability and atomicity by logging
changes before they are applied; and deadlock detection is critical
to manage resource conflicts. Round-robin scheduling is unrelated
to transactional consistency.
---
Question 5 (Multiple Choice)
Question:
©2025
Comprehensive Final Exam (Qns & Ans)
2025
Question 1 (Multiple Choice)
Question:
Which normal form specifically removes transitive dependencies
from a relational schema, ensuring that non–primary-key
attributes depend solely on the primary key?
A) First Normal Form (1NF)
B) Second Normal Form (2NF)
C) Third Normal Form (3NF)
D) Boyce–Codd Normal Form (BCNF)
Correct ANS:
C) Third Normal Form (3NF)
©2025
, Rationale:
Third Normal Form (3NF) is designed to eliminate transitive
dependencies—situations where non-prime attributes depend on
other non-prime attributes. Ensuring that every non–primary-key
attribute is directly dependent on the primary key helps reduce
redundancy and potential anomalies.
---
Question 2 (Fill in the Blank)
Question:
A highly efficient, balanced data structure commonly used for
indexing in DBMS, which supports range queries and ordered
traversal, is known as a ________ .
Correct ANS:
B+ tree
Rationale:
B+ trees are widely used in databases to index large datasets.
Their balanced structure and ability to support efficient range
queries make them indispensable for speeding up retrieval
operations in disk-based storage systems.
©2025
,---
Question 3 (True/False)
Question:
True/False: The ACID properties—Atomicity, Consistency,
Isolation, and Durability—are fundamental guarantees that ensure
that database transactions are processed reliably and preserve data
integrity.
Correct ANS:
True
Rationale:
ACID properties form the backbone of reliable transaction
processing in DBMS. They ensure that transactions are executed
completely (atomicity), maintain data integrity (consistency),
isolate concurrent transactions (isolation), and persist data even in
the event of failures (durability).
---
Question 4 (Multiple Response)
Question:
©2025
, Select all techniques commonly used to enforce transactional
consistency and recoverability in database management systems:
A) Two-phase locking (2PL)
B) Write-Ahead Logging (WAL)
C) Snapshot isolation
D) Round-robin scheduling
E) Deadlock detection
Correct ANS:
A, B, C, E
Rationale:
Two-phase locking and snapshot isolation are methods to preserve
isolation; WAL ensures durability and atomicity by logging
changes before they are applied; and deadlock detection is critical
to manage resource conflicts. Round-robin scheduling is unrelated
to transactional consistency.
---
Question 5 (Multiple Choice)
Question:
©2025
