Scribd
Upload
3 views1 page

ACID Properties Practice Answer Key

The document contains an answer key for a practice exercise on ACID properties in databases. It includes multiple choice questions and scenario-based answers related to atomicity, isolation, durability, and consistency. The scenarios illustrate practical applications in banking, online shopping, and healthcare.

Uploaded by

akds.singh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views1 page

ACID Properties Practice Answer Key

The document contains an answer key for a practice exercise on ACID properties in databases. It includes multiple choice questions and scenario-based answers related to atomicity, isolation, durability, and consistency. The scenarios illustrate practical applications in banking, online shopping, and healthcare.

Uploaded by

akds.singh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Answer Key – ACID Properties Practice

Part A: Multiple Choice Questions


1. b) Either all steps of a transaction happen or none happen

2. c) Atomicity

3. b) Transactions run in parallel but behave as if they were alone

4. c) Durability

5. b) Database moves from one valid state to another

Part B: Scenario-Based
1. Atomicity

2. Isolation

3. Durability

4. Consistency

5. Banking: Ensures no money disappears or duplicates.


Online Shopping: Guarantees orders and payments are consistent.
Healthcare: Patient records remain accurate and reliable.

You might also like