PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

What method should be included in your code?

You are employed as a developer at ABC.com. ABC.com makes use of SQL Server databases in
their environment.
ABC.com has an application that contains a SqlDataAdapter object and an OleDbDataAdapter
object. You are required to link up to a SQL Server database table. ABC.coms application
contains a DataSet object for this specific table.
You want to make sure that data from the database is loaded into the DataSet object using a
strategy that provides the most efficient execution.
What method should be included in your code?

What actions should you take?

You are employed as a developer at ABC.com.
ABC.com makes use of SQL Server in their environment.
You have created a new application for ABC.com that contains a SqlDataAdapter object. The
SqlDataAdapter object has been linked to a table. You are planning to make use of the Fill method
for returning information from the table.
You have been informed that the Fill method should access the SQL server database connection,
read the data, and leave a closed connection.
What actions should you take? (Choose all hat apply.)