Which of the following 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

Asynchronous execution is supported in ADO.NET 2.0 for ExecuteReader, ExecuteScalar, and ExecuteNonQuery.

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?

Read the following statement: DataTable.Merge (DataTable, Boolean) What is the boolean parameter?

You have to update some values in the database. Which method would you execute on a command object named ''cmdUpdate?''

You have a table named 'FirstQTR' and want to create another table 'SecondQTR' which is exactly the same as 'FirstQTR', including DataTable schema and constraints. Which of the following methods fulfills the requirement?

Which one is not a member of the CommandType enumeration?

Which statement is incorrect with regard to ADO?

Which are used for database connections between SQL Server and ASP.NET?

Which one is not associated with the command object in ADO.NET 2.0?

Which option is ideally suited for managing database connections?