ADO.Net/ADO.Net Mcq Question Set 1 Sample Test,Sample questions

  1. Home
  2. Back

Question: 
 How to load XML in DataSet?

1.Using the ReadXml method

2.Using the GetXml method

3.Both of the above

4.none of the above

Posted Date:-2022-02-04 10:43:22

Question: 
ADO.Net provides the ability to process and create an in-memory database which is called

1. DataSets

2. Views

3.Tables

4. Relations

Posted Date:-2022-02-04 10:51:30

Question: 
Can we use DataView to Filter rows in a DataTable?

1. Yes by setting Filter property

2. Yes by setting FilterRow property

3. Yes by setting the SetFilter method

4.none of the above

Posted Date:-2022-02-04 10:42:28

Question: 
DataSet object is

1.disconnected

2. connected

3.Can't say

4.none of the above

Posted Date:-2022-02-04 10:45:05

Question: 
DateSet contains one or more DataTables?

1.True

2.False

3. Can't say

4.none of the above

Posted Date:-2022-02-04 10:42:04

Question: 
If we want that the command object should return XML data then which Command object will be used?

1.GetXMLData

2.GetXml

3.ExecuteXmlReader

4.none of the above

Posted Date:-2022-02-04 10:59:31

Question: 
It is not required to open the connection when I am using DataAdapter.

1. True

2. False

3.all of the above

4.None of the mentioned

Posted Date:-2022-02-04 10:52:41

Question: 
On which object we set the properties to create a primary key for DataTable?

1.DataSet

2.DataTable

3.DataRelation

4.DataColumn

Posted Date:-2022-02-04 10:56:37

Question: 
SqlConnection object is used for?

1.MySql database

2. Oracle database

3.Microsoft SQL Server database

4.Access database

Posted Date:-2022-02-04 10:54:31

Question: 
What is the default specified timeout period for "SQLCommand.CommandTimeout" property?

1.30 seconds

2.60 Seconds

3. 90 Seconds

4.120 Seconds

Posted Date:-2022-02-04 10:46:44

Question: 
What is the Full form of ADO.Net?

1.Active Display Object

2.ActiveX Data Object

3. Asp Data Object

4.Active Dot Object

Posted Date:-2022-02-04 10:47:14

Question: 
When to use the OleDbConnection object?

1.When we want to connect to the Oracle database.

2.When we want to connect to the Sql server database

3.When we want to connect to Office Access database

4.none of the above

Posted Date:-2022-02-04 10:48:46

Question: 
Which Adapter is used to get the data from the Access Database?

1.DataAdapter

2.OledbDataAdapter

3.SQLDataAdapter

4.OracleDataAdapter

Posted Date:-2022-02-04 10:47:46

Question: 
Which ADO.Net class provides a connected environment?

1.DataSet

2.DataReader

3.Both

4.None of the mentioned

Posted Date:-2022-02-04 10:48:19

Question: 
Which ADO.net object is very fast to get data from the database?

1.SqlDataAdapter

2.DataSet

3.SqlDataReader

4.none of the above

Posted Date:-2022-02-04 10:46:22

Question: 
Which are command object methods?

1.ExecuteScalar

2. ExecuteNonQuery

3.ExecuteReader

4.All of the above

Posted Date:-2022-02-04 10:50:11

Question: 
Which CommandType is used to define the StoredProcedure?

1.Command.TableDirect

2.CommandType.StoredProcedure

3.CommandType.TableDirect

4.Command.Stored

Posted Date:-2022-02-04 10:53:17

Question: 
Which Data Provider gives the maximum performance when connected to SQL Server?

1. SqlClient Data Provider

2. OLEDB Data Provider

3.Oracle Data Provider

4.All of the above

Posted Date:-2022-02-04 10:58:25

Question: 
Which is Read-only forward-only recordset?

1.DataSet

2.DataReader

3. DataAdapter

4.DataCommand

Posted Date:-2022-02-04 10:45:27

Question: 
Which is the return type of the ExecuteScalar class?

1.System.Int32

2.object

3.Both

4.none of the above

Posted Date:-2022-02-04 10:49:07

Question: 
Which method is suited best when we have aggregate values in the SELECT statement?

1.ExecuteScalar()

2.ExecuteNoQuery().

3.ExecuteReader()

4.None of the above

Posted Date:-2022-02-04 10:55:34

Question: 
Which method is used to fill DataSet?

1.Populate

2. Fill

3.Open

4.Close

Posted Date:-2022-02-04 10:43:46

Question: 
Which method is used to retrieve the single value?

1.ExecuteScalar

2.ExecuteReader

3. ExecuteSingle

4.ExecuteNonQuery

Posted Date:-2022-02-04 10:42:54

Question: 
Which namespace is used to access the connection string from the Web.Config file?

1.Web.Configuration

2.Web.Config

3.System.Configuration

4.System.Web.Configuration

Posted Date:-2022-02-04 10:53:56

Question: 
Which namespace is used to fetch data from Oracle database?

1.Sql.Data

2.Sql.Data.SqlClient

3.Sql.Data.OracleClient

4.none of the above

Posted Date:-2022-02-04 10:45:56

Question: 
Which object is used to Fill DataSet using the query in SQL Server?

1.DataSet

2. DataTable

3. DataAdapter

4.none of the above

Posted Date:-2022-02-04 10:44:13

Question: 
Which object will be used to sort the data of DataSet?

1.DataView object

2.DataSet

3.DataTable

4.DataAdapter

Posted Date:-2022-02-04 10:44:40

Question: 
Which of the following are the events of the DataTable object?

1.RowChanged

2. ColumnChanged

3.RowChanging

4.All of the above

Posted Date:-2022-02-04 10:57:34

Question: 
Which of the following is the benefit of the ADO.Net?

1.Interoperability

2.Disconnected Data Access

3.Store Data in multiple tables

4.All of the above

Posted Date:-2022-02-04 10:51:00

Posted on by R4R Team

More MCQS

  1. ADO.Net Mcq Question Set 1
  2. ADO.Net Multiple Choice Questions
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!