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.

3

Read More...

Ado.Net Interview Questions and Answers Part 4

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

Read More...

Ado.Net Interview Questions and Answers Part 3

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

Read More...

Ado.Net Interview Questions and Answers Part 2

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

Read More...

Ado.Net Interview Questions and Answers Part 1

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

Read More...