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)

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


Comments