ODBC, OLE DB, ADO, AND ASP QUIZ

Stored Procedures only

Literals for date, time and timestamp only

INSERT, UPDATE, DELETE only

CREATE VIEW, DROP VIEW only

True

False

True

False

True

False

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

Browse possible connections and data sources only

Connect to data sources with driver-specific information only

Process a scrollable cursor only

True

False

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

Stored procedures only

INSERT, UPDATE, DELETE only

Full SELECT (includes subqueries) only

transforms data through ODE DB interfaces.

is both a consumer and a provider of data.

does not own data.

exposes data via rowsets.

Object interface over any type of data only.

All of these

Increase flexibility only.

Create object interfaces for DBMS functionality pieces only.

False

True