GIAC
GSSP-.NET · Question #19
GSSP-.NET Question #19: Real Exam Question with Answer & Explanation
Sign in or unlock GSSP-.NET to reveal the answer and full explanation for question #19. The question stem and answer options stay visible for context.
Question
- (Topic 1) 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
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.