Which DataAdapter Query Type can be used with the Access database?
-
Use SQL statements.
-
Create new stored procedure.
-
Use existing stored procedure.
-
Both a and b.
-
All of the above.
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.
Microsoft Access (using the Jet/ACE database engine) does not support stored procedures in the way SQL Server does, so a DataAdapter configured against an Access database can only use plain SQL statements (SELECT/INSERT/UPDATE/DELETE text) for its commands — the wizard's "stored procedure" options are grayed out/unavailable for Access. That rules out "create new stored procedure," "use existing stored procedure," and any option combining them with SQL statements, leaving "Use SQL statements" as the only valid choice for an Access-backed DataAdapter.