ODBC, OLE DB, ADO, AND ASP QUIZ

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

An OLE DB interface is specified by a set of objects and the properties and methods that they expose.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Connect to data sources only

Connect to data sources with driver-specific information only

Both 1 and 3 above are in the OBDC core API

Commit or rollback transactions only

TRUE ANSWER : ?
YOUR ANSWER : ?

When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?

Data source

OLE DB

Driver

Driver manager

TRUE ANSWER : ?
YOUR ANSWER : ?

When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?

Data source

DBMS

Driver manager

Driver

TRUE ANSWER : ?
YOUR ANSWER : ?

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

API.

driver manager.

data source.

driver.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ODBC

ADO

OLE DB

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, which of the following represents characteristics of the recordset abstraction?

Methods

Properties

Collections

Abstractions

TRUE ANSWER : ?
YOUR ANSWER : ?

OLE DB tabular data providers present data in the form of rowsets.

False

True

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

↑