what are acid properties? : Sql server database administration



what are acid properties? : Sql server database administration..

Answer / Amit Kumar Minz

ACID stands for Atomicity, Consistency, Isolation, and Durability. These are four key properties that ensure reliable and consistent database transactions:nn1) Atomicity: A transaction is either completely successful or it fails as a whole.n2) Consistency: Transactions preserve the consistency of the database by enforcing business rules and integrity constraints.n3) Isolation: Concurrent transactions do not interfere with each other, ensuring that they operate independently.n4) Durability: Once a transaction is committed, its changes are permanent and will survive any subsequent failures (power outages, hardware problems, etc.).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to search for a string in all stored procedure in sql server?

1 Answers  


How to get a list of columns using the "sys.columns" view in ms sql server?

1 Answers  


Write a program using SQL queries to find a unique entry in a table.

1 Answers   Tech Mahindra,


what is statistics

1 Answers  


How we can compare two database data?

1 Answers  


If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

1 Answers  


Explain the relational database management system (rdbms)?

1 Answers  


How can I create a report based on a query? : sql server management studio

1 Answers  


which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,


What are the benefits of normalization?

1 Answers  


wht is normalization?can u explain me in detail?

9 Answers   TCS,


What are different types of table joins?

1 Answers  


Categories