ODBC, OLE DB, ADO, AND ASP QUIZ

Properties

Collections

Methods

Abstractions

False

True

is both a consumer and a provider of data.

exposes data via rowsets.

transforms data through ODE DB interfaces.

does not own data.

True

False

Driver manager

Data source

Driver

OLE DB

True

False

Literals for date, time and timestamp only

INSERT, UPDATE, DELETE only

Stored Procedures only

CREATE VIEW, DROP VIEW only

Full SELECT (includes subqueries) only

INSERT, UPDATE, DELETE only

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

Stored procedures only

system data source.

user data source.

SQL text file.

file data source.

False

True