What is a transaction and what are ACID properties?
Answer Posted / hloni
A transaction is a sequence of database operations that
access the database. It must be a logical unit of work,
meaning that no portion of the transaction can exist on its
own. Either all parts are executed or the transaction is
aborted.
Transaction has five main properties called ACIDS:
1. Atomicity -- all parts of the transaction are executed
or else the transaction is aborted.
2. Consistency -- indicates the permanence of the
database's consistent state. When a transaction is
completed the database reaches a consistence state.
3. Isolation -- means that the data used during the
exercution of a transaction cannot be used by the a second
transaction until the first transaction is complete.
4. Durability -- ensures that once transaction changes are
commited, they cannot be lost even in the event of system
failure.
5. Serializability -- ensures that concurrent execution of
several transaction yields consistent results. This
property is important in a multi-user and distributed
datbases, where multiple transaction are likely to be
executed concurrently.
Is This Answer Correct ? | 14 Yes | 10 No |
Post New Answer View All Answers
How to convert character strings into numeric values?
What command is used to create a database in the sql server and how?
Why union all is faster than union?
Does table partitioning improve performance?
What is SQL Server?
Explain differences between web edition and business edition?
Explain foreign key in sql server?
how to create a scrollable cursor with the scroll option? : Sql server database administration
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What is difference between inner join and join?
What is truncate table?
Can you explain what is sql server english query?
What do you understand by triggers and mention the different types of it?
what stored procedure would you use to view lock information? : Sql server administration
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?