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

Which statement with regard to DataSet is correct?

When users edit data in your program, the code runs to completion without error, but no data changes appear in the database. You test the update query and the connection string that you are passing to the procedure, and they both work correctly. What changes do you need to make to your code to ensure that data changes appear in the database?

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

Read the following statements: OleDbDataAdapter oOrderDetailsDataAdapter; OleDbCommandBuilder oOrderDetailsCmdBuilder = New OleDbCommandBuilder(oOrderDetailsDataAdapter); oOrderDetailsDataAdapter.FillSchema(oDS, SchemaType.Source); What is wrong in this code?

How can you make a data reader close connection automatically?