ADO.NET interview questions
ADO.NET interview questions
Take as many assements as you can to improve your validate your skill rating
Total Questions: 15
1. Which .net Data Provider offers best performance when connected to SQLServer Database ?
Correct Answer is : SQLServer .NET Data Provider
2. What is the Best approach that has to be used, if you need continuous connection to the Database ?
Correct Answer is : ADO
3. Which of the following statements is true about Dataset ?
Correct Answer is : Dataset can store multiple tables in cache
4. The Databases that make up the data in a dataset
Correct Answer is : Can include many heterogeneous databases sources
5. In ADO, the data from one component to other is sent in Binary format, where as in ADO.Net it is sent in
Correct Answer is : XML Format
6. To use the .NET Framework Data Provider for SQL Server, an application must reference the _____________ namespace.
Correct Answer is : System.Data.SqlClient
7. Point out the correct statement :
Correct Answer is : System.Data.SqlClient includes a tabular data stream (TDS) parser to communicate directly with SQL Server
8. Valid Code for Creating a SqlConnection Object would be :
Correct Answer is : SqlConnection conn = NEW SqlConnection(
"Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI");
9. Code snippet for having a named instance of SQL Server would be :
Correct Answer is : “Server=localhost\sqlexpress”
10. Point out the wrong statement :
Correct Answer is : The goal of dotConnect for SQL Server is to enable developers to maintain database applications.
11. Which of the following is enumeration for ADO.net with SQL Server ?
Correct Answer is : SqlBulkCopyOptions
12. Syntax for closing and opening the connection in ADO.net is :
Correct Answer is : sqlConn.Open() and sqlConn.Close()
13. Which of the following gives trusted Connection from a CE device ?
Correct Answer is : connetionString="Data Source=ServerName;
Initial Catalog=DatabaseName;Integrated Security=SSPI;
User ID=myDomain\UserName;Password=Password;
14. The main features of dotConnect for SQL Server includes :
Correct Answer is : All of the mentioned
15. __________object is used to fill a DataSet/DataTable with query results in ADO.net.
Correct Answer is : DataAdapter
