ODBC, OLE DB, ADO, AND ASP QUIZ

Object interface over any type of data only.

Increase flexibility only.

Create object interfaces for DBMS functionality pieces only.

All of these

True

False

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

Browse possible connections and data sources only

JPCD

ASP

ODBC

ADO

transforms data through OLE DB interfaces only.

does not own data only.

All of these

is both a consumer and a provider of data only.

False

True

Connect to data sources only

Connect to data sources with driver-specific information only

Commit or rollback transactions only

Both 1 and 3 above are in the OBDC core API

does not own data.

transforms data through ODE DB interfaces.

is both a consumer and a provider of data.

exposes data via rowsets.

Literals for date, time and timestamp only

CREATE VIEW, DROP VIEW only

INSERT, UPDATE, DELETE only

Stored Procedures only

True

False