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 the data tier application?
How fixed length strings are truncated and padded?
What is a virtual table in sql?
What are the types of sql server?
Are connections to sql server encrypted?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What is collation?
What number sorts of privileges are accessible in sql?
What are the different types of data sources in ssrs?
What is awe?
What is sql stored procedure?
Find columns used in stored procedure?
What is resource db in sql server?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
How to check table values in sql server?
