ODBC, OLE DB, ADO, AND ASP QUIZ

ODBC is a foundation of data access in the specifically Microsoft world.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 2 API contains which the following functions?

Commit or rollback transactions only

All of these

Connect to data sources with driver-specific information only

Connect to data sources only

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.

OLE DB

ADO

JPCD

ODBC

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a tabular data provider:

does not own data.

exposes data via rowsets.

is both a consumer and a provider of data.

transforms data through ODE DB interfaces.

TRUE ANSWER : ?
YOUR ANSWER : ?

An OLE DB rowset is equivalent to a cursor.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?

Driver manager

Data source

OLE DB

Driver

TRUE ANSWER : ?
YOUR ANSWER : ?

An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):

API.

data source.

driver.

driver manager.

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a service provider:

does not own data only.

transforms data through OLE DB interfaces only.

All of these

is both a consumer and a provider of data only.

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is a cover for utilizing OLE DB that is designed for use by almost any language.

JPCD

ASP

ADO

ODBC

TRUE ANSWER : ?
YOUR ANSWER : ?

↑