What is transaction ? Give me one example.
Answer Posted / mobin sathupally
A transaction is a logical unit of work, it ensures that
multiple data modifications are procecessed together.
A transaction follows four properties(rules).
Those properties are "ACID".
ACID stands for Automocity
Consistency
Isolation and
Durability
| Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
How to create a dml trigger using create trigger statements?
What happens if we shrink log file in sql server?
Explain nested trigger in sql?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Explain the xml support sql server extends?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What is an indice?
How can we improve performance by using SQL Server profiler?
What is Sqlpaging in SqlServer 2005 ?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Do you know what is difference between index seek vs. Index scan?
What is the full form of ddl?
How to truncate the log in sql server 2012? : sql server database administration
How to delete duplicate rows in sql server?