Correct Answer: Close the connection as soon as database operation is done
Explanation:
Note: This Question is unanswered, help us to find answer for this one
ADO.NET Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More ADO.NET MCQ Questions
Which one is not associated with the command object in ADO.NET 2.0?
Which are used for database connections between SQL Server and ASP.NET?
Which statement is incorrect with regard to ADO?
Which one is not a member of the CommandType enumeration?
Which statement is incorrect with regard to a CommandBuilder object?
You have to update some values in the database. Which method would you execute on a command object named ''cmdUpdate?''
Read the following statement: DataTable.Merge (DataTable, Boolean) What is the boolean parameter?
In .Net application, you have to update 40 records together in the update query. Previous versions of ADO.NET would be making 40 calls to database. Which parameter is set to 40 with version 2.0?
Asynchronous execution is supported in ADO.NET 2.0 for ExecuteReader, ExecuteScalar, and ExecuteNonQuery.
Which statements are correct? (a)SQL statements are generally faster than stored procedures (b)The database engine works out the execution plan for SQL statements at run time