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 function of master database?
Name the different type of indexes in sql?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
How can you list all the table constraints in a database?
Is BCNF better than 2NF & 3NF? Why?
How to create function without parameter in sql server?
What is the current pricing model of SQL Azure?
What is mean by candidate key?
Why de-normalization required?
How to encrypt data between dialogs?
Is it possible to call a stored procedure within a stored procedure?
What is filtered index?
What is the difference between varchar and varchar types?
How to Update from select query in sql server?
What is bcnf normalization form?
