ODBC, OLE DB, ADO, AND ASP QUIZ

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

ADO

OLE DB

JPCD

ODBC

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is a cover for utilizing OLE DB that is designed for use by almost any language.

ODBC

ASP

ADO

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A file data source is one that is local to a single computer.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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

Browse possible connections and data sources only

Connect to data sources with driver-specific information only

Process a scrollable cursor only

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following are goals of OLE DB?

Increase flexibility only.

Object interface over any type of data only.

All of these

Create object interfaces for DBMS functionality pieces only.

TRUE ANSWER : ?
YOUR ANSWER : ?

The ADO connection object is created after the ADO errors object is created.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑