ADO.NET MCQs (Chapterwise Multiple Choice Questions)

You must create a stored procedure to retrieve the following details for the given customer:

CustomerName, Address, PhoneNumber

Which of the following is an ideal choice to get the result?

Return the result as dataset using data adapter

Return the result as dataset using command object

Return the result as three out parameters and command object

All of the above

Answer & Explanation

Correct Answer: Return the result as three out parameters and command object

Note: This Question is unanswered, help us to find answer for this one

Read the following statements: Dim dr As DataRow Dim objCustReader As Data.SqlClient.SqlDataReader Dim dtCustomers As DataTable With dtCustomers.Columns.Add(New DataColumn(

Add is not a method of the Columns collection

Column collection should be used instead of columns collection

The Data Type of the column is a required parameter of 'Add' method

None of the above

Answer & Explanation

Correct Answer: None of the above

Note: This Question is unanswered, help us to find answer for this one

How can you make a data reader close connection automatically?

command.ExecuteReader()

command.ExecuteReader(CommandBehavior.Default)

command.ExecuteReader(CommandBehavior.CloseConnection)

command.ExecuteReader(CommandBehavior.SingleRequest)

Answer & Explanation

Correct Answer: command.ExecuteReader(CommandBehavior.CloseConnection)

Note: This Question is unanswered, help us to find answer for this one

ADO.NET is known for disconnected data extraction. Which of the following does not use the disconnected mechanism while extracting data from the database?

DataAdapter

DataReader

DataSet

None of the above

Answer & Explanation

Correct Answer: DataReader

Note: This Question is unanswered, help us to find answer for this one

Which of the following implements IDataReader interface?

SqlDataReader

OleDbDataReader

OracleDataReader

All of the above

Answer & Explanation

Correct Answer: All of the above

Note: This Question is unanswered, help us to find answer for this one

Which of the following options is ideally suited for managing database connections?

Pass the open connection objects between the methods

Close the connection as soon as database operation is done

Open a global connection and keep on using it without reopening

Within a transaction, a connection should be closed in each method and reopened in the other

Answer & Explanation

Correct Answer: Close the connection as soon as database operation is done

Note: This Question is unanswered, help us to find answer for this one

Which of the following is not associated with the command object in ADO.NET 2.0?

cmd.ExecuteScalar()

cmd.ExecutePageReader()

cmd.ExecuteReader()

cmd.ExecuteXmlReader()

Answer & Explanation

Correct Answer: cmd.ExecutePageReader()

Note: This Question is unanswered, help us to find answer for this one

Which of the following is capable of returning multiple rows and multiple columns from the database?

ExecuteReader

ExecuteXmlReader

Adapter.fill

All of the above

Answer & Explanation

Correct Answer: All of the above

Note: This Question is unanswered, help us to find answer for this one

Which of the following options should you use to copy the edited rows from a dataset called ProductInfo into another dataset called Product Changes?

productChanges = productInfo.GetChanges(DataRowState.Detached)

productChanges = productInfo.GetChanges()

productChanges.Merge(productInfo, true)

productChanges.Merge(productInfo, false)

Answer & Explanation

Correct Answer: productChanges = productInfo.GetChanges()

Note: This Question is unanswered, help us to find answer for this one

You use a Command object to retrieve employee names from the employee table in the database. Which of the following will be returned when this command is executed using the ExecuteReader method?

DataRow

DataSet

DataTable

DataReader

Answer & Explanation

Correct Answer: DataReader

Note: This Question is unanswered, help us to find answer for this one

ADO.NET Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.

ADO.NET MCQ

ADO.NET Quick Quiz

You must create a stored procedure to retrieve the following details for the given customer:CustomerName, Address, PhoneNumberWhich of the following is an ideal choice to get the result?

Read the following statements: Dim dr As DataRow Dim objCustReader As Data.SqlClient.SqlDataReader Dim dtCustomers As DataTable With dtCustomers.Columns.Add(New DataColumn(

How can you make a data reader close connection automatically?

ADO.NET is known for disconnected data extraction. Which of the following does not use the disconnected mechanism while extracting data from the database?

Which of the following implements IDataReader interface?

Which of the following options is ideally suited for managing database connections?

Which of the following is not associated with the command object in ADO.NET 2.0?

Which of the following is capable of returning multiple rows and multiple columns from the database?

Which of the following options should you use to copy the edited rows from a dataset called ProductInfo into another dataset called Product Changes?

You use a Command object to retrieve employee names from the employee table in the database. Which of the following will be returned when this command is executed using the ExecuteReader method?

You must create a stored procedure to retrieve the following details for the given customer:

CustomerName, Address, PhoneNumber

Which of the following is an ideal choice to get the result?