Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 77352 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
Explain view in sql server?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
what are the Prerequisites for Replication?
What is data source document?
What is sql server schema compare? How we can compare two database schemas?
How can we solve concurrency problems?
What is triggers and stored procedures?
Explain “row_number()” in sql server with an example?
What is difference between delete & truncate commands?
Tell me what do we need queues in sql service broker?
Can binary strings be used in arithmetical operations?
What is difference between views and stored procedures?
Explain external key management in sql server 2008
How global temporary tables are represented and its scope?
Do you know sql server 2008 introduces automatic auditing?
