Ado.Net Interview Questions and Answers for Experienced - 1

Question: 1

What is the full form of ADO?

The full form of ADO is ActiveX Data Object.

Question: 2

What is the role of the DataSet object in ADO.NET?

One of the major component of ADO.NET is the DataSet object, which always remains disconnected from the database and reduces the load on the database.

Question: 3

How can you implement transactions in ADO.NET?

The following are the most common sequence of steps that would be performed while implementing transactions in ADO.NET
i. Make a connection to the database
ii. Create the SQLCommand object
iii. Open the database connection by using the open () method of the Connection object.
iv. Call the BeginTranscation () method of the connectiontransaction object.
v. Execute the SQL commands using the command object
vi. Call the Commit () method of the transaction object to complete the transaction and the Rollback () method to abort the transaction
vii. Close the database connection by using the close () method.

Question: 4

Which object is used to add a relationship between two DataTable objects?

The DataRelation object is used to add relationship between two DataTable objects.

Question: 5

What are the parameters that control most of connection pooling behaviors?

The parameter that control most of connection pooling behaviors are as follows
i. Connect Timeout
ii. Max Pool Size
iii. Min Pool Size
iv. Pooling