Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 78023 Views
- Config Systems, IBM, TCS, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / ravina
A transaction is a sequence of sql Operations(commands),
work as single atomic unit of work. To be qualify
as "Transaction" , this sequence of operations must satisfy
4 properties , which is knwon as ACID test.
A(Atomicity):-The sequence of operations must be atomic,
either all or no operations are performed.
C(Consistency):- When completed, the sequence of operations
must leave data in consistent mode. All the defined
relations/constraints must me Maintained.
I(Isolation): A Transaction must be isolated from all other
transactions. A transaction sees the data defore the
operations are performed , or after all the operations has
performed, it can't see the data in between.
D(Durability): All oprtaions must be permanently placed on
the system. Even in the event of system failure , all the
operations must be exhibit.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Comment,Datatypes are unlimited
How to update multiple rows with one update statement in ms sql server?
Explain how to send email from sql database?
What are constraints?
Which tcl commands are available on the sql server?
What is local temp table?
What are the tables in sql?
Which trace flags are enabled in sql server?
What is the recovery model?
How to set a database state to offline in ms sql server?
How many non clustered indexes there can be on table ?
How to delete all rows with truncate table statement in ms sql server?
What is the command used to check locks in microsoft sql server?
Explain the concept of view and Types of views in SQL server?
Why olap is used?
