Ado.net MCQ (Multiple choice questions) and answer

Ado.net MCQ (Multiple choice questions) with answers and explanations for placement tests and job interviews. These solved Ado.net Programming MCQ questions are useful for the campus placement of all freshers including Engineering Students, MCA students, Computer and IT Engineers, etc.

Our Ado.net MCQ ( Ado.net Multiple Choice Questions )  focuses on all areas of the Ado.net programming language. We will regularly update the quiz and most interesting thing is that questions come in a random sequence. So every time you will feel new questions.

Note: Your score along with correct answers will be visible after answering all of these questions.

ado.net mcq

Ado.net MCQ: Ado.net Multiple Choice Questions and Answers

1 / 35

Layer which is NOT supported by the ADO.NET.

2 / 35

In a connection string _____________ represents name of the database

3 / 35

Which of the following illustrates the benefit of ADO.NET?

4 / 35

Function which is used to stop running thread.

5 / 35

Component which is NOT used in ADO.NET.

6 / 35

Data provider which is NOT supported by the ADO.NET.

7 / 35

Default timeout for SqlCommand.Command timeout property

8 / 35

SQLclient provider is used to access only ______database

9 / 35

Which object contains the Position property of the current record in a dataset?

10 / 35

What data type is returned when calling the ExecuteScalar method of a command object?

11 / 35

What information is specified in the Connection tab of the DataLink window?

12 / 35

Object which needs to be closed.

13 / 35

Method is used by command class to execute SQL statements that return single value.

14 / 35

The data is stored in a Microsoft SQL Server database on a server named Admin and the Database name is Diploma. You connect to Diploma by using Windows authentication mode. You use a SqlConnection object to connect to the database. Then which is the correct connection string from below?

15 / 35

ADO.NET provides the communicator between

16 / 35

Method which is used to sort the data in ADO.NET.

17 / 35

When you create a relationship between tables in ADO.NET DataSe

18 / 35

What is the use of SQL command object?

19 / 35

Which DataAdapter Query Type can be used with the Access database?

20 / 35

Keyword is used to accept variable number of parameters.

21 / 35

Can you use a DataView to filter rows in a DataTable

22 / 35

The first record in a dataset has a position property of:

23 / 35

Class which is NOT available in System.Data Namespace.

24 / 35

Which is a property of the DataGrid control?

25 / 35

To perform asynchronous data access, what must be added to the connection string?

26 / 35

Which method in OLEDB adapter is used to populate dataset with records.

27 / 35

What is ADO.NET

28 / 35

To check the status of the connection, ____ property is useful

29 / 35

ADO.Net connection object is used to establish a connection between

30 / 35

Which ado.net class provide disconnected environment?

31 / 35

What is Dataset object?

32 / 35

Which of the following illustrates the benefit of ADO.NET?

33 / 35

Which is not an ADO.NET DataAdapter Object?

34 / 35

What is the use of SQL command object?

35 / 35

Method which is used to read XML file.

 

Recommended Articles for you: