ODBC, OLE DB, ADO, AND ASP QUIZ

In OLE DB, a tabular data provider:

is both a consumer and a provider of data.

does not own data.

exposes data via rowsets.

transforms data through ODE DB interfaces.

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, which of the following represents characteristics of the recordset abstraction?

Methods

Properties

Collections

Abstractions

TRUE ANSWER : ?
YOUR ANSWER : ?

An OLE DB rowset is equivalent to a cursor.

True

False

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.

data source.

driver.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A OLE DB collection is an object that contains a group of other objects.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC identifies two types of drivers: single tier and multiple-tier.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

properties.

collections.

abstractions.

methods.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑