Ado.Net Interview Questions and Answers for Experienced - 1
What is the full form of ADO?
The full form of ADO is ActiveX Data Object.
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.
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.
Which object is used to add a relationship between two DataTable objects?
The DataRelation object is used to add relationship between two DataTable objects.
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
7000+ TNPSC Group 1, 2, 4, VAO Indian Economy Study Materials Pdf More
7000+ Gate Computer Science Engineering Previous Year Questions More
7000+ Fill in the Blanks with Suitable Homonyms More
7000+ Fill in the Blanks with Suitable Homophones More
Power Semiconductor Device and Integrated Circuits MCQ Questions Pdf More
Tourism General Knowledge Questions and Answers 2020-2021 More
Top 100+ Environment and Ecology GK Quiz Questions & Answers More
Common Abbreviatons Pdf for Competitive Exams 2020-2021 More
Top 150+ J2EE MCQ Questions and Answers 2020-2021 More
7000+ Computer Science MCQS with Answers More