Ado.Net Interview Question and Answers part 5

By // No comments:
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.
3

Ado.Net Interview Questions and Answers Part 4

By // No comments:
1. ) What is DataTable collection in Ado.Net ?                                                                  
The Data Tables collection contains all the Data Table objects in a DataSet.

2. ) What is the use of Data view in Ado.Net ?                                                                    

Data View is mainly used to sort and filter the Table data.

3. )Can we return a result set using ExecuteNonQuery() method  in Ado.Net ?    

No, It only show "Row effected " when any user perform insert ,delete and update operation on a table.We use ExecuteReader() method for return the result set from Database.
3

Ado.Net Interview Questions and Answers Part 3

By // No comments:
1.) What are the method Provided by Data Set to Generate XML ?                            
  • Get XML :- This Return the String containing XML Document.
  • Read XML :- It is used to Read XML Document to Data Set.
  • Write XML:-  This is used to write the XML Data to Disk (file).
2.) What are the meaning of Data Set Clone and Data Set Copy in Ado.Net?         
  • Data Set Clone :-It is used to copy the structure but not used to copy the data.
  • Data Set Copy:- It is used to copy the structure and Data both.
3

Ado.Net Interview Questions and Answers Part 2

By // No comments:
1.) How can draw a arrow diagram of connected Architecture ?                              
Application ---> DataReader ---> Database

2.) How can draw a arrow diagram of disconnected Architecture ?                              
Application ---> DataSet---> DataAdopter ---> Database

3.) What are the advantages of Ado.Net ?                                                                           
  • In Ado.Net ,Data is persisted as XML.
  • All Schema define data Structures.
  • Ado.Net does not depend on continuously Live connections.
  • In Ado.Net , Data cab be cached in Data set.
  • In this ,Data set are Independent of Data Source.
  • We can easily interact with database using command.  
3

Ado.Net Interview Questions and Answers Part 1

By // No comments:
1. ) What are the difference between ADO and ADO.NET ?                                         
There are some difference between ADO and ADO.NET as given below:-
  • Ado supports only connected Architecture but Ado.Net supports connected as well as Disconnected  Architecture .
  • In Ado, we can't create constraints but in Ado.NET , we can easily create constraints.
2. ) What are the two Architecture used in  ADO.NET ?                                                  
  1. Connected Architecture
  2. Disconnected Architecture
3
Powered by Blogger.