ODBC, OLE DB, ADO, AND ASP QUIZ

In OLE DB, a tabular data provider:

transforms data through ODE DB interfaces.

does not own data.

exposes data via rowsets.

is both a consumer and a provider of data.

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?

Data source

Driver

Driver manager

DBMS

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC is a foundation of data access in the specifically Microsoft world.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Properties

Methods

Collections

Abstractions

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a service provider:

is both a consumer and a provider of data only.

does not own data only.

All of these

transforms data through OLE DB interfaces only.

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following are goals of OLE DB?

Create object interfaces for DBMS functionality pieces only.

Object interface over any type of data only.

Increase flexibility only.

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ODBC

JPCD

OLE DB

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

Users of OLE DB functionality are referred to as data providers.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

An abstraction is a generalization of something.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

user data source.

file data source.

SQL text file.

system data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑