ODBC, OLE DB, ADO, AND ASP QUIZ

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

driver.

API.

data source.

driver manager.

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC core SQL grammar contains which of the following?:

Both 1 and 3 above are contained in the ODBC core SQL.

INSERT, UPDATE, DELETE only

Stored procedures only

Full SELECT (includes subqueries) only

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.

ASP

ODBC

ADO

XML

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

OLE DB

ADO

ODBC

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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

In OLE DB, a tabular data provider:

does not own data.

transforms data through ODE DB interfaces.

is both a consumer and a provider of data.

exposes data via rowsets.

TRUE ANSWER : ?
YOUR ANSWER : ?

An abstraction is a generalization of something.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑