ODBC, OLE DB, ADO, AND ASP QUIZ

A file data source is one that is local to a single computer.

False

True

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 : ?

In OLE DB, which of the following represents characteristics of the recordset abstraction?

Collections

Methods

Properties

Abstractions

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is considered to be one of the foundations of data access in the Microsoft world.

OLE DB

JPCD

ADO

ODBC

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Connect to data sources only

Commit or rollback transactions only

Both 1 and 3 above are in the OBDC core API

Connect to data sources with driver-specific information only

TRUE ANSWER : ?
YOUR ANSWER : ?

OLE DB has two types of data providers: tabular data providers and service providers.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

data source.

driver.

API.

driver manager.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a service provider:

transforms data through OLE DB interfaces only.

All of these

does not own data only.

is both a consumer and a provider of data only.

TRUE ANSWER : ?
YOUR ANSWER : ?

An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑