ADO.NET Interview questions


Total available count: 25
Subject - Microsoft Technologies
Subsubject - ADO.NET

How can a user determine which SQL commands are part of a transaction?

What database commands belong in a transaction can be determined by using ACID test. But those commands must be,

1. Atomic
2. Consistent
3. Isolated
4. Durable.
 
1. Atomic: Atomic is nothing but make up of a single work.
2. Consistent: All the relationships between the data are maintained correctly.
3. Isolated: Changes made by other clients can not affect the current changes.
4. Durable: Once a change is made, it is permanent.



Comments