ODBC, OLE DB, ADO, AND ASP QUIZ

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

SQL text file.

file data source.

user data source.

system data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 2 API contains which the following functions?

Connect to data sources only

All of these

Connect to data sources with driver-specific information only

Commit or rollback transactions only

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

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, actions that an object can perform are called:

methods.

collections.

properties.

abstractions.

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

________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.

ASP

ADO

XML

ODBC

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a tabular data provider:

is both a consumer and a provider of data.

exposes data via rowsets.

does not own data.

transforms data through ODE DB interfaces.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑