Transactions in RDBMS follow the ___________ properties to ensure data integrity and consistency.

  • ACID
  • CRUD
  • DDL
  • DML
ACID (Atomicity, Consistency, Isolation, Durability) properties are fundamental principles that guarantee reliability and accuracy in database transactions. Atomicity ensures that all operations in a transaction are completed successfully or none at all, maintaining data integrity. Consistency ensures that a transaction brings the database from one valid state to another, preserving data correctness. Isolation ensures that transactions are independent of each other, preventing interference between concurrent transactions. Durability guarantees that once a transaction is committed, its changes are permanently saved, even in the event of system failures. CRUD (Create, Read, Update, Delete) is a set of basic operations for manipulating data but doesn't encompass the principles necessary for transaction management. DML (Data Manipulation Language) and DDL (Data Definition Language) are SQL categories for manipulating and defining data structures, respectively, but they don't specifically address transactional properties. Therefore, ACID properties are the correct choice for ensuring data integrity and consistency in transactions.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *