ODBC, OLE DB, ADO, AND ASP QUIZ

In ODBC, a data source that is local to a single computer is called a:

file data source.

system data source.

user data source.

SQL text file.

TRUE ANSWER : ?
YOUR ANSWER : ?

An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.

False

True

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

An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):

data source.

API.

driver manager.

driver.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

JPCD

ODBC

OLE DB

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

JPCD

ODBC

ASP

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, actions that an object can perform are called:

methods.

properties.

collections.

abstractions.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑