nerdexam
Microsoft

70-516 · Question #89

70-516 Question #89: Real Exam Question with Answer & Explanation

Sign in or unlock 70-516 to reveal the answer and full explanation for question #89. The question stem and answer options stay visible for context.

Question

You are going to execute a Select command to SQL Server that returns several rows of customer data. You don't need a data table to hold the data because you will simply loop over the returned results to build a string of information that will be displayed to the user. You create and open a connection and then create the command and set its properties. Which method on the command will you execute to retrieve the results?

Options

  • AExecuteScalar
  • BClose
  • CExecuteReader
  • DExecuteNonQuery

Unlock 70-516 to see the answer

You've previewed enough free 70-516 questions. Unlock 70-516 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 70-516 Practice
You are going to execute a Select command to SQL Server that... | 70-516 Q#89 Answer | NerdExam