ODBC Level 2 features Which of the following function categories are provided by the ODBC Level 2 API (in addition to core and Level 1)?

Introduction / Context:ODBC divides capabilities into tiers. Level 2 augments the core and Level 1 with richer features such as advanced cursor support, extended diagnostics, catalog functions, and broader connection and transaction control coverage for maximum portability.

Given Data / Assumptions:

• Level 2 encompasses a superset of core and Level 1 behaviors.
• Transaction control and connection variations remain available.
• Vendors may implement even more capabilities as extensions.

Concept / Approach:

By definition, Level 2 includes and extends earlier tiers. Therefore, it will cover standard connection routines (including driver-assisted flows), as well as commit/rollback functions. It also adds optional advanced features such as scrollable cursors, bookmarks, and positioned updates, improving portability of sophisticated applications.

Step-by-Step Solution:

Verification / Alternative check:

Level 2 feature matrices published with ODBC versions show broader coverage, including advanced cursor and catalog features, above and beyond basic connection/transaction routines.

Why Other Options Are Wrong:

• A–C narrow the scope unnecessarily.
• E is false—Level 2 adds many capabilities.

Common Pitfalls:

• Assuming Level 2 features are universal—applications should test for support or use capability flags.
• Relying on vendor extensions that may not be portable to other drivers.

Final Answer:

All of the above are contained in the ODBC Level 2 API.