Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 78057 Views
- Config Systems, IBM, TCS, Virtusa, I also Faced
- E-Mail Answers
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 overcome kernel isssues
What is use of except clause?
What are the advantages of using stored procedures?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What happens to a statement batch if there is a compilation error?
What is model database in sql server?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
How many null values we can have in a unique key field in sql server?
What is dynamic cursor in SQL SERVER?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
How do I perform an unattended install of sql server 2000?
what are triggers? : Sql server database administration
is there a column to which a default can't be bound? : Sql server database administration
what is difference between view and Dip.
How to create indexed view?
