ODBC, OLE DB, ADO, AND ASP QUIZ

The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

JPCD

ODBC

ADO

OLE DB

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

An OLE DB interface is specified by a set of objects and the properties and methods that they expose.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

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

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

Driver

OLE DB

Driver manager

Data source

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

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

ADO

ODBC

ASP

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 2 API contains which the following functions?

Commit or rollback transactions only

Connect to data sources only

Connect to data sources with driver-specific information only

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

↑