Answer
A transaction is a unit of work ensured by ACID properties:
- Atomicity: All-or-nothing behavior.
- Consistency: Constraints must remain valid.
- Isolation: Controls concurrency.
- Durability: Committed data survives crashes via logging.
Quick Answer
A transaction groups multiple operations into one atomic unit. In SQL Server: Atomicity means the transaction commits fully or rolls back entirely. Consistency ensures constraints hold. Isolation controls what concurrent transactions can see. Durability means committed data survives crashes via the transaction log.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ