ODBC, OLE DB, ADO, AND ASP QUIZ

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

True

False

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

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

True

False

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following are goals of OLE DB?

Increase flexibility only.

Object interface over any type of data only.

Create object interfaces for DBMS functionality pieces only.

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is considered to be one of the foundations of data access in the Microsoft world.

ODBC

OLE DB

JPCD

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 1 API contains which of the following functions?

Process a scrollable cursor only

Both 1 and 3 above are in the OBDC Level 1 API

Connect to data sources with driver-specific information only

Browse possible connections and data sources only

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a service provider:

does not own data only.

is both a consumer and a provider of data only.

transforms data through OLE DB interfaces only.

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

↑