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.