GIAC Secure Software Programmer - C#.NET
Question No. 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";
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.
Choose all the correct options from the given list.