ODBC, OLE DB, ADO, AND ASP QUIZ

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

In OLE DB, a tabular data provider:

exposes data via rowsets.

is both a consumer and a provider of data.

does not own data.

transforms data through ODE DB interfaces.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

driver manager.

API.

driver.

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.

ADO

ODBC

ASP

XML

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following are goals of OLE DB?

Create object interfaces for DBMS functionality pieces only.

Increase flexibility only.

Object interface over any type of data only.

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

properties.

collections.

methods.

abstractions.

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 manager

DBMS

Driver

Data source

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ODBC

ASP

JPCD

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑