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

What do you understand by sql server agent?

525


Explain features of analysis services?

519


What are the differences between sql server and mysql.

530


What are logical/boolean operations in ms sql server?

537


In how many ways you can invoke ssrs reports?

99






Explain isolation levels that sql server supports?

565


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1846


How to automatically create a log when an exception is being received into SQL Server?

731


How to scale out a federation by Sql statement?

92


What is reference section?

495


What is key set driven?

535


Mention the differences between local and global temporary tables.

560


What is normalization? Explain different forms of normalization?

531


How to create percentile function?

108


When I run the sql server 2000 setup, it just hangs. What do I do?

646