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


Please Help Members By Posting Answers For Below Questions

How can you know if the row fetched from cursor is still valid in underlying table?

781


Explain iaas, paas and saas?

86


Why people hate cursor?

919


Difference between Inner vs outer joins?

716


Can a database be shrunk to 0 bytes, if not, why?

845


What are cursors and when they are useful?

765


What are the recovery models in sql server 2000?

733


How is sql server used?

711


How to insert a new row into a table with "insert into" statements in ms sql server?

744


Explain filtered indexes benefits?

790


How to change the data type of an existing column with "alter table" statements in ms sql server?

757


What is purpose of normalization?

728


How to create function with parameter in sql server?

800


List out some of the requirements to set up a sql server failover cluster?

785


What is intellisense?

810