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.

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.

Accepted Answer

B. Use a SqlCommand object instead of an OleDbCommand object. F. Use a stored procedure instead of the CommandText property.

Answer

A. Use a Cache object to execute the program code.

Answer

C. Use the Prepare method on the OleDbCommand object before executing the program code.

Answer

D. Use an OleDbDataReader object to execute the program code.

Answer

E. Use database indexing.

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…

Question

Options

How the community answered

Community Discussion