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
Is it possible to update the database by using SqlDataReader?
2
What is the full-form of ADO?
3
What is the use of SqlParameter.Direction?
4
Explain differences between Dataset and Datareader?
5
What is the purpose of database transactions?