GIAC
GSSP-.NET · Question #280
GSSP-.NET Question #280: Real Exam Question with Answer & Explanation
Sign in or unlock GSSP-.NET to reveal the answer and full explanation for question #280. The question stem and answer options stay visible for context.
Question
- (Topic 3) 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 a Cache object to execute the program code.
- BUse a SqlCommand object instead of an OleDbCommand object.
- CUse the Prepare method on the OleDbCommand object before executing the program
- DUse an OleDbDataReader object to execute the program code.
- EUse database indexing.
- FUse a stored procedure instead of the CommandText property.
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.