ODBC, OLE DB, ADO, AND ASP QUIZ

The ODBC core API consists of which of the following functions?

Connect to data sources with driver-specific information only

Commit or rollback transactions only

Both 1 and 3 above are in the OBDC core API

Connect to data sources only

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

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a service provider:

All of these

does not own data only.

transforms data through OLE DB interfaces only.

is both a consumer and a provider of data only.

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

ODBC minimum SQL grammar contains which of the following?

Literals for date, time and timestamp only

Stored Procedures only

INSERT, UPDATE, DELETE only

CREATE VIEW, DROP VIEW 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.

XML

ODBC

ADO

ASP

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a tabular data provider:

is both a consumer and a provider of data.

does not own data.

exposes data via rowsets.

transforms data through ODE DB interfaces.

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC is a foundation of data access in the specifically Microsoft world.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑