ODBC, OLE DB, ADO, AND ASP QUIZ

A data source is an ODBC data structure that identifies a database and the DBMS that processes it.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

JPCD

ADO

ODBC

OLE DB

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Methods

Properties

Abstractions

Collections

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a tabular data provider:

is both a consumer and a provider of data.

does not own data.

transforms data through ODE DB interfaces.

exposes data via rowsets.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Driver

OLE DB

Data source

Driver manager

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑