ODBC, OLE DB, ADO, AND ASP QUIZ

ODBC identifies two types of drivers: single tier and multiple-tier.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

driver manager.

driver.

API.

data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

In ODBC, a data source that is local to a single computer is called a:

user data source.

file data source.

system data source.

SQL text file.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a tabular data provider:

transforms data through ODE DB interfaces.

is both a consumer and a provider of data.

exposes data via rowsets.

does not own data.

TRUE ANSWER : ?
YOUR ANSWER : ?

An OLE DB rowset is equivalent to a cursor.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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

________ is an object-oriented interface that encapsulates data-server functionality.

JPCD

OLE DB

ODBC

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

↑