ODBC, OLE DB, ADO, AND ASP QUIZ

ODBC identifies two types of drivers: single tier and multiple-tier.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

file data source.

system data source.

SQL text file.

user data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a service provider:

transforms data through OLE DB interfaces only.

does not own data only.

is both a consumer and a provider of data only.

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ADO

ODBC

OLE DB

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 2 API contains which the following functions?

Connect to data sources with driver-specific information only

Connect to data sources only

All of these

Commit or rollback transactions only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

OLE DB

JPCD

ODBC

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.

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.

False

True

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

Full SELECT (includes subqueries) only

Stored procedures only

TRUE ANSWER : ?
YOUR ANSWER : ?

↑