Answer Posted / arvind
Transaction is a logical unit of sql commands which are
performed in a singlge step.
If any of the steps is failed then the transaction is not
completed and all the steps are rolled back automatically.
Howeveer a transaction must follow the ACID properties.
A: Atomicity: All the steps an a transaction must execute
in a single group.
C: Consistency: Transaction should be consistence in the
database i.e. database after the transaction should be in
consistence state, it should not damage the DB.
I:Isolation: one transaction should not be affected by
other transactions.
D;Durability: Transaction should be durable even after
system crash...
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What is data mart? : sql server analysis services, ssas
What is an example of a primary key?
How many types of attribute relationships are there? : sql server analysis services, ssas
When cursors are useful?
How to populate a table in sql server?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What are system databases into sql server (2005/2008)?
What is query optimization process?
how to invoke a trigger on demand? : Sql server database administration
Explain primary key?
What is the maximum size of a row in sql server?
What are cursors in ms sql server?
What is the sql case statement used for? Explain with an example?
What is service broker?
What is a cache in ssrs?
