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 difference between Clustered and Non-Clustered Index?
What are user defined functions in ms sql server?
What do you know about system database? : SQL Server Architecture
Explain about Normalization?
What does dml stand for?
Which language rdl files made of?
What is a covered index?
Do you know what is blocking?
What is cursor in ms sql server?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
How network traffic be reduced by using the stored procedure?
How many servers can we create in a single subscription?
What is the osql utility?
Explain what is “asynchronous” communication in sql server service broker?
Explain the difference between function and stored procedure?
