Ado.Net Interview Question and Answers part 5

1.) Why we use indexing concepts in sql server ?                                                            
We can apply indexing features on a table's column for faster retrieval of data.

2.) What are the two types of indexing used in sql server ?                                        

• Cluster Index
• Non Cluster Index

3.) Is Data Adopter always connected with database?                                                  

No,It establishes the connection with database when any operation (events) occurs with database.

4.) What method is used to get xml data and schema from database ?                  

• Get Schema()
• Get XML()

5.) What are the method used in Data View in Ado.NET ?                                           

• Find
• Add New
• Delete
• Find Row

6.) What is difference between oleDB Provider and Sql Client provider ?             

• Sql Client is more optimized because .NET classes are highly optimized for the .NET/SQL Server combination and achieve optimal results.
• Sql client provider is faster than the Oracle provider as well as accessing database via the oleDB layer.
• Sql client is faster because it uses native library.

7.) How to merge two database into third data set in a simple way ?                   
Data set ds1 =new Data set ();
Data set ds2 =new Data set ();
Data set ds3 =new Data set ();
ds1.merge(ds2,true);
ds1.merge(ds3,true);

8.) What are the basic methods of Data Adopter ?                                                        

• Fill
• Update
• Fill Schema

9.) How can be delete the row in a Data table ?                                                               
Data set ds =new Data set ();
ds.Tables("table_name").rows(1).Delete);
cmd.update (ds,"table_name");

10.) How many techniques are used in locking in data set  ?                                    

• Data set
• Time stamp
• Roll Back & Commit

11.) What are the two types of locking used in ado.net  ?                                          

• Optimistic Locking
• Pessimistic Locking

12.) How can close the connection in ado.net  ?                                                            

• Con.Close();