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 Multiple Choice Questions and Answers

1 / 35

In a connection string _____________ represents name of the database

Data Source

Initial Catalog

Catalog Initial

Database

2 / 35

Method which is used to read XML file.

ReadXmlSchema()

ReadXML()

GetXML()

ViewXML()

3 / 35

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

A UniqueConstraint is added to the parent table

A ForeignKeyConstraint is added to the child table by default

Both a and b

None

4 / 35

Object which needs to be closed.

OLDDBConnection

OLEDB connect

ADODB connection

ADDDB connection

5 / 35

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

Put Method

Fill Method

Fills Method

Insert Method

6 / 35

What is Dataset object?

It is set to be collection of data with a tabular column representation.

It is set to be collection of data with a tabular cell representation

It is set to be collection of data with a tabular row representation

It is set to be collection of data with a tabular field representation

7 / 35

What is the use of SQL command object?

SQLCommand object allows user to interact with the users.

SQLCommand object allows user to interact with the database.

SQLCommand object allows user to interact with the dataset.

SQLCommand object allows user to interact with the server.

8 / 35

Keyword is used to accept variable number of parameters.

Programs

Params

Parameters

Param

9 / 35

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

BeginExecute=true

MultiThreaded=true

MultipleActiveResultSets=true

Asynchronous=true

10 / 35

Which is not an ADO.NET DataAdapter Object?

OleDbDataAdapter

SQLDataAdapter

QueryDataAdapter

All of the above.

11 / 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?

Data Source=Admin\SQLEXPRESS;Initial Catalog=Diploma;Integrated Security=True

Data Source=Admin/SQLEXPRESS;Initial Catalog=Diploma;Integrated Security=True

Data Source=Admin\SQLEXPRESS;Initial Catalog=Diploma;Integrated Security=False

All of the above

12 / 35

Which is a property of the DataGrid control?

DataMember

DataSource

DataQuery

All of the above

13 / 35

ADO.NET provides the communicator between

Data object and Dataset

Data object and Data source

Dataset and Data base

Dataset and the Data source.

14 / 35

Class which is NOT available in System.Data Namespace.

DataTable

Data Record

DataColumn

DataRow

15 / 35

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

Interoperability

It uses DataSet to represent data in memory that can store data from multiple tables and multiple sources.

Disconnected data access

All of the above

16 / 35

Can you use a DataView to filter rows in a DataTable

Yes, by setting the Filter property of the DataView

Yes, by setting the RowFilter property of the DataView

No, a DataView cannot be used to filter rows in a DataTable

17 / 35

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

BindingContext

BindingData

DataBinding

DataBound

18 / 35

Which ado.net class provide disconnected environment?

DataReader

DataSet

Command

None of the above.

19 / 35

Component which is NOT used in ADO.NET.

ExecuteNonQuery

ExecuteScalar

ExecuteReader

ExecuteQuery

20 / 35

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

Use SQL statements.

Create new stored procedure.

Use existing stored procedure.

All of the above.

21 / 35

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

ConnectionStatus

Status

State

ConnectionState

22 / 35

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

System.Int32

Object

No of effected records.

None of the above.

23 / 35

Function which is used to stop running thread.

Thread.Aborts() function

Thread.Stop() function

Thread.Abort() function

Threads.Abort() function

24 / 35

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

Database login

Database name

Database type

All of the above.

25 / 35

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

Application and Database

Application and Dataset

Application and the data source.

Application and Data object

26 / 35

Layer which is NOT supported by the ADO.NET.

Database Access Layer

Business Logic Layer

Presentation Layer

Data Link Layer

27 / 35

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

ODBC

MS SQL Server

MyAccess

OLEDB

28 / 35

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

zero

one

any value defined by the programmer

All of the above

29 / 35

What is ADO.NET

ActiveX Data ObjectsNetwork

ActiveDataObjectsNetwork

ActiveDataObjectNetwork

AccessDataObjectsNetwork

30 / 35

Default timeout for SqlCommand.Command timeout property

10 Seconds

20 Seconds

30 Seconds

40 Seconds

31 / 35

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

Sort() method of ListViewControl

Sort() method of DataViewControl

Sort() method of GridViewControl

ToSort() method of GridViewControl

32 / 35

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

Execute Query

ExecuteNonQuery

Execute Scalar

Execute Reader

33 / 35

SQLclient provider is used to access only ______database

MySql Server

Sql Server

Wamp Server

MS SQL Server.

34 / 35

What is the use of SQL command object?

XML

HTML

PHP

JAVASCRIPT

35 / 35

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

Interoperability

It uses DataSet to represent data in memory that can store data from multiple tables and multiple sources.

Disconnected data access

All of the above

Your score is
LinkedIn Facebook Twitter VKontakte
0%

Aticleworld

aticleworld offer c tutorial,c programming,c courses, c++, python, c#, microcontroller,embedded c, embedded system, win32 API, windows and linux driver, tips

Ado.net MCQ (Multiple choice questions) and answer

Recommended Articles for you:

About

One comment

Leave a Reply Cancel reply

Recommended Articles for you:

About

You might also like

One comment

Leave a Reply Cancel reply