ODBC, OLE DB, ADO, AND ASP QUIZ

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

Connect to data sources with driver-specific information only

Process a scrollable cursor only

Browse possible connections and data sources only

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

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

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

When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?

Data source

Driver manager

OLE DB

Driver

TRUE ANSWER : ?
YOUR ANSWER : ?

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

________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.

ADO

OLE DB

ODBC

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ADO

ODBC

JPCD

OLE DB

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is a cover for utilizing OLE DB that is designed for use by almost any language.

ADO

ODBC

JPCD

ASP

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑