What is ACID Property of Transaction?

Answer Posted / sd

Adding to what POO said

Automicity : Group of T-SQL stmts act in a batch .

Consistency : All or none concept.

Isolation: Visibility of resources used in one transaction
to concurrent transactions
Durability : Once changes are commited to database they are
permanent .

Is This Answer Correct ?    36 Yes 37 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can I delete event logs?

707


What is check constraint in sql server?

718


I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

783


What is DCL?

764


What is an active database?

765






How to delete existing rows in a table?

769


Define clusters?

815


How to create a simple table to test triggers in ms sql server?

688


Explain what are the events recorded in a transaction log?

739


What is the difference between getdate and sysdatetime?

722


Is mysql better than sql server?

736


How dts is used to extract, transform and consolidate data?

795


Which joins are sql server default?

683


What are the rendering extensions of ssrs?

125


How many types of cursor type are there?

755