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.

Next 5 interview question(s)

How to connect a database through SqlConnection?
How to convert a DataSet into a DataReader?
How to fill a DataSet?
Is it possible to update the database by using SqlDataReader?
Types of DataSet in ADO.NET?