ODBC, OLE DB, ADO, AND ASP QUIZ

An OLE DB interface is specified by a set of objects and the properties and methods that they expose.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

user data source.

system data source.

SQL text file.

file data source.

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

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

ASP

XML

ODBC

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 2 API contains which the following functions?

Connect to data sources with driver-specific information only

Connect to data sources only

All of these

Commit or rollback transactions only

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a service provider:

transforms data through OLE DB interfaces only.

is both a consumer and a provider of data only.

All of these

does not own data only.

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 1 API contains which of the following functions?

Both 1 and 3 above are in the OBDC Level 1 API

Connect to data sources with driver-specific information only

Process a scrollable cursor only

Browse possible connections and data sources only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Both 1 and 3 above are in the OBDC core API

Commit or rollback transactions only

Connect to data sources with driver-specific information only

Connect to data sources only

TRUE ANSWER : ?
YOUR ANSWER : ?