ODBC, OLE DB, ADO, AND ASP QUIZ

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

Abstractions

Collections

Properties

Methods

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

A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.

True

False

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

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.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

system data source.

file data source.

SQL text file.

user data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following are goals of OLE DB?

Create object interfaces for DBMS functionality pieces only.

All of these

Object interface over any type of data only.

Increase flexibility only.

TRUE ANSWER : ?
YOUR ANSWER : ?

An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑