Which DataAdapter Query Type can be used with the Access database?

  1. Use SQL statements.

  2. Create new stored procedure.

  3. Use existing stored procedure.

  4. Both a and b.

  5. All of the above.


Correct Option: A
Explanation:

To answer this question, the user needs to have knowledge of the different query types that can be used with a DataAdapter when working with an Access database.

Option A is correct. The "Use SQL statements" query type can be used with a DataAdapter when working with an Access database. This query type allows you to write SQL statements to retrieve, update, and delete data from the database.

Option B is incorrect. Creating new stored procedures is not a query type that can be used with a DataAdapter when working with an Access database. Stored procedures are typically used with SQL Server databases.

Option C is incorrect. Using existing stored procedures is also not a query type that can be used with a DataAdapter when working with an Access database. Again, stored procedures are typically used with SQL Server databases.

Option D is incorrect. Although option A is correct, option B is not. Therefore, option D cannot be correct because it includes option B.

Option E is incorrect. Although option A is correct, options B and C are not. Therefore, option E cannot be correct because it includes options B and C.

So, the correct answer is:

The Answer is: A. Use SQL statements.

Find more quizzes: