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
how would you store your query in an SSRS report or a Database server?
How to connect php with different port numbers?
Explain what is scheduled job and how to create it?
What are the reporting services components?
How many databases can we create in a single server?
What is the difference between insensitive and scroll cursor?
What is the difference between NOROW and LOCKROW?
What are the advantages of having an index on the sql server?
How to concatenate two character strings together?
what purpose does the model database serve? : Sql server database administration
How to verify a user name with sqlcmd tool?
Explain the difference between clustered and non-clustered index?
What are the differences between triggers and stored procedures?
How do I edit a procedure in sql server?
How do I create a stored procedure in dbml?
