CIS 4301
Information & Database Systems 1
4.0 Credits
Final Exam Review (Qns & Ans)
2025
©2025
, 1. [Multiple Choice]
Question:
In a distributed transaction environment, which protocol is most
commonly used to guarantee atomicity of commits?
a. Two-Phase Commit (2PC)
b. Three-Phase Commit
c. Paxos Consensus
d. Gossip Protocol
ANS:
a. Two-Phase Commit (2PC)
Rationale:
The Two-Phase Commit protocol ensures that either all
participating nodes commit a transaction or none do, thereby
supporting the atomicity property in distributed systems.
---
2. [Fill in the Blank]
Question:
The acronym ACID in transaction processing stands for
Atomicity, Consistency, ________, and Durability .
ANS:
Isolation
Rationale:
ACID properties are fundamental to reliable transaction processing
in databases. "Isolation" ensures that concurrently executing
transactions do not affect each other’s intermediate states.
---
3. [True/False]
©2025
, Question:
In distributed systems that employ eventual consistency, every
node sees the most recent update immediately after a write
operation.
ANS:
False
Rationale:
Eventual consistency implies that nodes will converge to a
consistent state over time, but it does not guarantee immediate
visibility of the latest update across all nodes.
---
4. [Multiple Response]
Question:
Which of the following properties constitute the CAP theorem?
(Select all that apply)
a. Consistency
b. Availability
c. Partition Tolerance
d. Atomicity
e. Isolation
ANS:
a. Consistency, b. Availability, c. Partition Tolerance
Rationale:
The CAP theorem states that a distributed system can
simultaneously guarantee only two of the three properties:
Consistency, Availability, and Partition Tolerance. Atomicity and
Isolation relate to transaction properties, not to CAP.
---
5. [Multiple Choice]
©2025
Information & Database Systems 1
4.0 Credits
Final Exam Review (Qns & Ans)
2025
©2025
, 1. [Multiple Choice]
Question:
In a distributed transaction environment, which protocol is most
commonly used to guarantee atomicity of commits?
a. Two-Phase Commit (2PC)
b. Three-Phase Commit
c. Paxos Consensus
d. Gossip Protocol
ANS:
a. Two-Phase Commit (2PC)
Rationale:
The Two-Phase Commit protocol ensures that either all
participating nodes commit a transaction or none do, thereby
supporting the atomicity property in distributed systems.
---
2. [Fill in the Blank]
Question:
The acronym ACID in transaction processing stands for
Atomicity, Consistency, ________, and Durability .
ANS:
Isolation
Rationale:
ACID properties are fundamental to reliable transaction processing
in databases. "Isolation" ensures that concurrently executing
transactions do not affect each other’s intermediate states.
---
3. [True/False]
©2025
, Question:
In distributed systems that employ eventual consistency, every
node sees the most recent update immediately after a write
operation.
ANS:
False
Rationale:
Eventual consistency implies that nodes will converge to a
consistent state over time, but it does not guarantee immediate
visibility of the latest update across all nodes.
---
4. [Multiple Response]
Question:
Which of the following properties constitute the CAP theorem?
(Select all that apply)
a. Consistency
b. Availability
c. Partition Tolerance
d. Atomicity
e. Isolation
ANS:
a. Consistency, b. Availability, c. Partition Tolerance
Rationale:
The CAP theorem states that a distributed system can
simultaneously guarantee only two of the three properties:
Consistency, Availability, and Partition Tolerance. Atomicity and
Isolation relate to transaction properties, not to CAP.
---
5. [Multiple Choice]
©2025
