GIAC
GSSP-NET · Question #56
GSSP-NET Question #56: Real Exam Question with Answer & Explanation
Sign in or unlock GSSP-NET to reveal the answer and full explanation for question #56. The question stem and answer options stay visible for context.
Question
John works as a Web developer for HiTech Inc. He develops an application named MyApp by using Visual C# .NET. John uses a SQL Server database. He writes the following code: OleDbCommand cmd = new OleDbCommand(); cmd.CommandText = "UPDATE Employees SET Rank = 'Senior' WHERE Basic > 10000"; cmd.ExecuteNonQuery(); Now he wants to improve the performance of the program code. Which of the following actions will he perform to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.
Options
- AUse database indexing.
- BUse an OleDbDataReader object to execute the program code.
- CUse a Cache object to execute the program code.
- DUse a SqlCommand object instead of an OleDbCommand object.
- EUse a stored procedure instead of the CommandText property.
- FUse the Prepare method on the OleDbCommand object before executing the program code.
Unlock GSSP-NET to see the answer
You've previewed enough free GSSP-NET questions. Unlock GSSP-NET 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.