ADO.NET Interview Questions and Answers (445) - Page 22

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

445 records found.

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

Which of the following method of the Command object is best suited when we have an aggregate function associated with the select statement?

NOTE: This is objective type question, Please click question title for correct answer.

How can we perform transactions in .NET?

-Open a database connection using open method of the connection object.
-Begin a transaction using the Begin Transaction method of the connection object.
-Execute the SQL commands using the command object.
-Commit or roll back the transaction using the commit or rollback method of the transaction object.
-Close the database connection.

What are the namespaces provided by .net for data management?

Following Namespaces are provided by Dot Net:-

System.Data
System.Data.OLEDB
System.Data.SQLClient
System.XML

How can we perform transactions in .NET?

1. Open a database connection using open method of the connection object.
2. Begin a transaction using the Begin Transaction method of the connection object.
3. Execute the SQL commands using the command object.
4. Commit or roll back the transaction using the commit or rollback method of the transaction object.
5. Close the database connection.

Which of the following method provided by the DataSet object to generate XML?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following is not true about Ado.Net?

NOTE: This is objective type question, Please click question title for correct answer.

When do we need to create a relationship among tables in Ado.Net Data Set?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following ado.net object is faster and consume lesser memory?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the statement is false about Datareader?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the statement is false about Dataset?

NOTE: This is objective type question, Please click question title for correct answer.

How can we identify whether a DataReader object is closed or opened?

NOTE: This is objective type question, Please click question title for correct answer.

Which method is used to Merge one Datatable to another Datatable?

NOTE: This is objective type question, Please click question title for correct answer.

What are the rules needs to be considered while Merging one datatable to another datatable?

NOTE: This is objective type question, Please click question title for correct answer.

Which method of SqlCommand is used to fetch single value.

NOTE: This is objective type question, Please click question title for correct answer.

Which SqlCommand method is used to retrieve all columns?

NOTE: This is objective type question, Please click question title for correct answer.

Which SqlCommand method is used for Insert/Update/Delete statements?

NOTE: This is objective type question, Please click question title for correct answer.

Which datatype ExecuteNonQuery method does support?

NOTE: This is objective type question, Please click question title for correct answer.

Which datatype ExecuteReader method does support?

NOTE: This is objective type question, Please click question title for correct answer.

Which datatype ExecuteScaler method does support?

NOTE: This is objective type question, Please click question title for correct answer.

What is the alter native for sqldatareader in ADO.NET for connection with database?

NOTE: This is objective type question, Please click question title for correct answer.

1
...
15
16
17
18
19
20
21
22
23

More ADO.NET Exclusive Interview Questions & Answers here

Found this useful, bookmark this page to the blog or social networking websites.

GooglePlus

StumbleUpon

Delicious

Reddit

Email

Bookmark It

Interview Questions and Answers Categories

.NET Certifications

ASP.NET Web API

Data Structures & Algorithms

Design Pattern & Practices

DotNetFunda.Com

Entity Framework

Error and Solution

Function Points (FPA)

Interview Questions

Mobile Development

MSBI (SSIS, SSRS, SSAS)

News and Community

Product Reviews

Project Management

Regular Expressions

Web Services, Remoting