ODBC, OLE DB, ADO, AND ASP QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Connect to data sources with driver-specific information only

Connect to data sources only

Both 1 and 3 above are in the OBDC core API

Commit or rollback transactions only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

SQL text file.

user data source.

system data source.

file data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?

Driver

DBMS

Data source

Driver manager

TRUE ANSWER : ?
YOUR ANSWER : ?

OLE DB tabular data providers present data in the form of rowsets.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A user data source is one that can be shared among database users.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

SQL text file.

user data source.

system data source.

file data source.

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

↑