ODBC, OLE DB, ADO, AND ASP QUIZ

Stored procedures only

INSERT, UPDATE, DELETE only

Both 1 and 3 above are contained in the ODBC core SQL.

Full SELECT (includes subqueries) only

Connect to data sources with driver-specific information only

Commit or rollback transactions only

Connect to data sources only

All of these

False

True

False

True

user data source.

file data source.

SQL text file.

system data source.

Browse possible connections and data sources only

Connect to data sources with driver-specific information only

Both 1 and 3 above are in the OBDC Level 1 API

Process a scrollable cursor only

properties.

collections.

methods.

abstractions.

Increase flexibility only.

All of these

Create object interfaces for DBMS functionality pieces only.

Object interface over any type of data only.

True

False

True

False