ODBC, OLE DB, ADO, AND ASP QUIZ

In OLE DB, a tabular data provider:

exposes data via rowsets.

transforms data through ODE DB interfaces.

is both a consumer and a provider of data.

does not own data.

TRUE ANSWER : ?
YOUR ANSWER : ?

An abstraction is a generalization of something.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The ADO connection object is created after the ADO errors object is created.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC core API consists of which of the following functions?

Both 1 and 3 above are in the OBDC core API

Connect to data sources with driver-specific information only

Commit or rollback transactions only

Connect to data sources only

TRUE ANSWER : ?
YOUR ANSWER : ?

The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In ODBC, a file that can be shared among database users is called a:

system data source.

user data source.

SQL text file.

file data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

Users of OLE DB functionality are referred to as data providers.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A OLE DB collection is an object that contains a group of other objects.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑