Microsoft
98-361 · Question #308
Your C# program needs to return the total number of customers in a SQL Server database. The program will be used several times a day. What is the fastest way to return this information from your…
The correct answer is B. Write a stored procedure. D. Use the SqlCommand.ExecuteScalar method. See the full explanation below for the reasoning.
Question
Your C# program needs to return the total number of customers in a SQL Server database. The program will be used several times a day. What is the fastest way to return this information from your program? (Select all answers that apply.)
Options
- AWrite a SQL query.
- BWrite a stored procedure.
- CUse the SqlDataAdapter.Fill method.
- DUse the SqlCommand.ExecuteScalar method.
- EUse the OleDbDataAdapter.Fill method.
How the community answered
(50 responses)- A8% (4)
- B72% (36)
- C2% (1)
- E18% (9)
Community Discussion
No community discussion yet for this question.