ADODB Interview Questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. To use the .NET Framework Data Provider for SQL Server, an application must reference the _____________ namespace.

A. System.Data.Client

B. System.Data.SqlClient

C. System.Data.Sql

D. None of the mentioned

Correct Answer is : System.Data.SqlClient

2. Point out the correct statement :

A. Using the System.Data.SqlClient , you can fill a memory-resident DataSet that you can use to query and update the database

B. System.Data.SqlClient includes a tabular data stream (TDS) parser to communicate directly with SQL Server

C. SqlBulkCopyColumnMapping lets you efficiently bulk load a SQL Server table with data from another source

D. None of the mentioned

Correct Answer is : System.Data.SqlClient includes a tabular data stream (TDS) parser to communicate directly with SQL Server

3. Code snippet for having a named instance of SQL Server would be :

A. “Server=localhost\sqlexpress”

B. “Server=local\sqlexpress”

C. “Server=host\sqlexpress”

D. “Ser=localhost\sqlexpress”

Correct Answer is : “Server=localhost\sqlexpress”

4. Point out the wrong statement :

A. The goal of dotConnect for SQL Server is to enable developers to maintain database applications.

B. dotConnect for SQL Server combines connected and disconnected data access models in single SqlDataTable component

C. dotConnect for SQL Server supports new ADO.NET features and technologies as soon as they are released

D. None of the mentioned

Correct Answer is : The goal of dotConnect for SQL Server is to enable developers to maintain database applications.

5. Which of the following is enumeration for ADO.net with SQL Server ?

A. SqlInfo

B. SqlBulkCopyOptions

C. SqlNotification

D. All of the mentioned

Correct Answer is : SqlBulkCopyOptions

ADODB interview questions