ODBC, OLE DB, ADO, AND ASP QUIZ

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

Browse possible connections and data sources only

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

Process a scrollable cursor only

Connect to data sources with driver-specific information only

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC core SQL grammar contains which of the following?:

INSERT, UPDATE, DELETE only

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

Full SELECT (includes subqueries) only

Stored procedures only

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a service provider:

does not own data only.

transforms data through OLE DB interfaces only.

All of these

is both a consumer and a provider of data only.

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

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 a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.

ASP

ODBC

XML

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

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

system data source.

file data source.

SQL text file.

user data source.

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 driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a tabular data provider:

transforms data through ODE DB interfaces.

does not own data.

is both a consumer and a provider of data.

exposes data via rowsets.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑