Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 78516 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
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is difference between primary key and foreign key?
List the different types of collation sensitivities in sql server?
Can we use where clause with group by?
How to stop a loop early with break statements in ms sql server?
What is the most common trace flags used with sql server?
Tell me when is the update_statistics command used?
List some case manipulation functions in sql?
What do you understand by check constraint in sql server?
Explain about Views?
What are audit control procedures?
Explain about system database?
What is sql server profiler?
How to integrate the ssrs reports in application?
Write a SQL command to insert and update only a particular field?
