What is a transaction and what are ACID properties?
Answer Posted / piyush
transaction is a set of operation or activities which are
executed in a logical unit of work which is know as transaction.
ACID
A-Atomicity
C-Consistency
I-Isolation
D-Durability
| Is This Answer Correct ? | 28 Yes | 8 No |
Post New Answer View All Answers
Why I have to use stored procedures?
What are “lock” hints?
What is the difference between for xml raw and for xml auto?
Explain what is the difference between union and union all?
What are tables in sql server?
Can we delete data from a view?
What are the components of dbms?
Why do we need normalization?
What is sql server query analyzer?
Explain the commands in sql server?
what is unique and xaml nonclustered index
Can we check locks in database? If so, how can we do this lock check?
Can we return Data from 4(more than 1) tables in stored procedure?
how to control the amount of free space in your index pages? : Sql server database administration
What is dynamic cursor in SQL SERVER?