Interested to Buy Any Domain ? << Click Here >> for more details...
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 difference between oltp and olap?
can you implement data mining in SSRS?
How to get a list of columns in a view using the "sp_help" stored procedure?
How to concatenate two binary strings together?
What are Spatial data types in SQL Server 2008
What are types of subqueries?
How to generate create table script on an existing table in ms sql server?
What is database black box testing?
What are .mdf files?
What is change data capture (cdc) in sql server 2008?
Difference between Sql server reporting services and Crystal reports?
Explain ranking functions?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What is filtered index?
Will the writetext statement activate a trigger?
